Helpful components right under your fingers

Use huge amount of integrated technologies to create best integrations

Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only Office 365 or OneDrive for Business supported at this time with Zapier.

Featured applications for   Microsoft Excel   connector
No applications available
Microsoft Excel   connector features
Actions
Data read
  • Read data from single table at single worksheet in workbook presented by Base64 string

    Parameters:

      • Document content, String
      • Contains names row, Boolean
      • Worksheet name, String
      • Read starting position, String
      • Read end position, String

    Returns:

    • data, Array [Object]
  • Read data from all worksheets in workbook using provided URL

    Parameters:

      • Workbook source URL, String
      • Contains names row, Boolean

    Returns:

    • worksheetsData, Array [Object]
  • Read data from single table at single worksheet in workbook

    Parameters:

    • Workbook source URL, String
    • Contains names row, Boolean
    • Worksheet name, String
    • Read starting position, left top corner of table (e.g. A2), String
    • Read end position, right bottom corner of table (e.g. Z15), String

    Returns:

    • data, Array [Object]
  • Workbook generation
  • Generates workbook with provided sheets and data(with styles)

    Parameters:

      • Workbook name, String
      • Worksheets settings, Array [Object]

    Returns:

    • url, String
    • workbookName, String
  • Generates workbook with provided sheets and data(without styles)

    Parameters:

      • Worksheets settings, Array [Object]
      • Workbook name, String

    Returns:

    • url, String
    • workbookName, String
  • Generate workbook with provided single sheets and data(with styles)

    Parameters:

      • Workbook name, String
        • Workbook sheet name, String
        • Columns settings, Array [Object]
        • Data source, Array [Object]
          • Width auto size, Boolean
          • Cell width, Number
          • Text color (e.g. 3C3C3C), String
          • Font family, String
          • Font size, String
          • Word wrap, Boolean
          • Text color (e.g. F0F0F0), String
          • Width auto size, Boolean
          • Cell width, Number
          • Text color (e.g. 3C3C3C), String
          • Font family, String
          • Font size, String
          • Word wrap, Boolean
          • Text color (e.g. F0F0F0), String

    Returns:

    • url, String
    • workbookName, String
  • Generate workbook with provided single sheets and data(without styles)

    Parameters:

        • Workbook sheet name, String
        • Columns settings, Array [Object]
        • Data source, Array [Object]
      • Workbook name, String

    Returns:

    • url, String
    • workbookName, String
Triggers
  • No triggers available for this connector