Excel

Configuration

Microsoft Excel source connector integrates with the Microsoft Graph API.

Synchronizes data from Microsoft Excel including workbooks, worksheets, and tables.

It provides comprehensive access to Excel resources with proper token refresh and rate limiting.

Source Code: View on GitHub

Authentication

This connector uses OAuth 2.0 authentication. You can connect through the Graffo UI or API using the OAuth flow.

Supported authentication methods:

• OAuth Browser Flow (recommended for UI)

• OAuth Token (for programmatic access)

• Auth Provider (enterprise SSO)

Configuration Options

This connector does not have any additional configuration options.

Data Models

The following data models are available for this connector:

ExcelWorkbookEntity

Schema for a Microsoft Excel workbook (file).

Represents the Excel file itself with metadata.

Reference: https://learn.microsoft.com/en-us/graph/api/resources/driveitem

Field	Type	Description
id	str	Drive item ID for the workbook.
name	str	Workbook name (without extension).
created_datetime	Optional[datetime]	When the workbook was created.
last_modified_datetime	Optional[datetime]	When the workbook was last modified.
file_name	str	The full file name including extension.
size	Optional[int]	Size of the file in bytes.
created_by	Optional[Dict[str, Any]]	Identity of the user who created the workbook.
last_modified_by	Optional[Dict[str, Any]]	Identity of the user who last modified the workbook.
parent_reference	Optional[Dict[str, Any]]	Information about the parent folder/drive location.
drive_id	Optional[str]	ID of the drive containing this workbook.
description	Optional[str]	Description of the workbook if available.
web_url_override	Optional[str]	Direct URL to open the workbook in Excel Online.

ExcelWorksheetEntity

Schema for a Microsoft Excel worksheet (sheet/tab).

Represents individual sheets within an Excel workbook.

Reference: https://learn.microsoft.com/en-us/graph/api/resources/worksheet

Field	Type	Description
id	str	Worksheet ID within the workbook.
name	str	Worksheet display name.
workbook_id	str	ID of the parent workbook.
workbook_name	str	Name of the parent workbook.
position	Optional[int]	The zero-based position of the worksheet within the workbook.
visibility	Optional[str]	The visibility of the worksheet (Visible, Hidden, VeryHidden).
range_address	Optional[str]	The address of the used range (e.g., 'A1:Z100').
cell_content	Optional[str]	Formatted text representation of the cell content in the used range.
row_count	Optional[int]	Number of rows with data in the worksheet.
column_count	Optional[int]	Number of columns with data in the worksheet.
last_modified_datetime	Optional[datetime]	Timestamp at which the worksheet was last modified.
web_url_override	Optional[str]	URL that opens the containing workbook focused on this sheet.

ExcelTableEntity

Schema for a Microsoft Excel table.

Represents structured data tables within worksheets.

Reference: https://learn.microsoft.com/en-us/graph/api/resources/table

Field	Type	Description
id	str	Table ID within the workbook.
name	str	Table name as defined in Excel.
workbook_id	str	ID of the parent workbook.
workbook_name	str	Name of the parent workbook.
worksheet_id	str	ID of the parent worksheet.
worksheet_name	str	Name of the parent worksheet.
display_name	Optional[str]	Display name of the table.
show_headers	Optional[bool]	Indicates whether the header row is visible.
show_totals	Optional[bool]	Indicates whether the total row is visible.
style	Optional[str]	Style name of the table.
highlight_first_column	Optional[bool]	Indicates whether the first column contains special formatting.
highlight_last_column	Optional[bool]	Indicates whether the last column contains special formatting.
row_count	Optional[int]	Number of rows in the table.
column_count	Optional[int]	Number of columns in the table.
column_names	List[str]	Names of the columns in the table.
table_data	Optional[str]	The actual table data as formatted text (rows and columns).
last_modified_datetime	Optional[datetime]	Timestamp at which the table was last modified.
web_url_override	Optional[str]	URL that opens the workbook focused on this table.