[Components] microsoft_excel

[pipedream-component-development]

We should do a general usability audit for Excel, and below are some suggestions for triggers and actions:

microsoft_excel

URLs

Polling Sources

new-row-added

Description

Emit new event when a row is added to a specified worksheet in an Excel file. Requires the file path, worksheet name, and polling interval.

new-workbook-created

Description

Emit new event when a new Excel workbook is created in a specified OneDrive or SharePoint folder. Requires the folder path and polling interval.

new-cell-value-changed

Description

Emit new event when a specific cell's value changes in a workbook. Requires the file path, worksheet name, cell address (e.g., A1), and polling interval.

Actions

add-row

Description

Insert a new row into a specified Excel worksheet. Requires file path, worksheet name, and a set of key-value pairs representing column headers and values.

update-cell

Description

Update the value of a specific cell in an Excel worksheet. Requires the file path, worksheet name, cell address, and new value.

get-table-rows

Description

Retrieve rows from a specified table in an Excel worksheet. Requires the file path and table name. Optional filters can be applied based on column values.

[ethankinnan-lindy-ai]

We really need excel functions to read.

Would be great to have (in order of priority)

• Get Spreadsheet: Read in the full spreadsheet in a structured way like .csv (must be able to specify by which worksheet of the workbook as input. Ideally can also get spreadsheet by a dynamic spreadsheet ID if possible)
• Get Column(s): Read in specific column(s) by inputting the column(s) of a specific spreadsheet I want returned
• Find Row: Essentially V lookup. You get to input a lookup column and lookup value for a spreadsheet and it returns the row

[vunguyenhung]

Hello everyone, I have tested this PR and there're some test cases failed or needed improvement.

Please check the test report below for more information
https://vunguyenhung.notion.site/Components-microsoft_excel-1dabf548bb5e8116b9e5e6720c5cc9be