ادمج Microsoft Excel مع 171 تكاملاً جاهزاً
Read and write Excel workbooks in OneDrive / SharePoint through Microsoft Graph: table rows keyed by column name, worksheet rows updated by a key column, tables and worksheets listed.
Tables
- Read Rows — Read a table as one object per row keyed by the table's column names (row_index included); this step's items output is the row list
- Add Row — Add row(s) to a table by column name: columns (name → value, {{item.<field>}} over rowsSource) or rows (objects)
- List Tables — The tables of a workbook (id, name)
- Create Table — Create a table over a range of the workbook and name it (the range's first row is the header row unless hasHeaders is false)
Worksheets
- Update Rows — Update the rows of a worksheet whose key column equals a value: the used range's first row is the header row; columns (name → value) or rows (objects) carry the new cells
- List Worksheets — The worksheets of a workbook (id, name)
- Create Worksheet — Add a worksheet to the workbook
- Read Used Range — The worksheet's used range as a grid (address, values)