Microsoft Excel

Operations 9

• Add Table Rows
  Append one or more rows to a table. Batching the rows into a single call is far faster than one call per row.
  ms_excel.add_table_rows
• Recalculate Workbook
  Force Excel to recalculate the workbook, so formulas written by an earlier step are evaluated before the next step reads them.
  ms_excel.calculate
• Create Workbook Session
  Open a workbook session and return its id, so a run of several reads and writes shares one Excel transaction instead of one per call.
  ms_excel.create_session
• Read Range
  Read the values, text and formulas of one A1 range on a worksheet, e.g. A1:D10.
  ms_excel.get_range
• Read Used Range
  Read the whole populated area of a worksheet, without needing to know how far the data goes.
  ms_excel.get_used_range
• List Table Rows
  Read a table's rows, following Graph paging up to max_results.
  ms_excel.list_table_rows
• List Tables
  List the named tables in a workbook, with their ids and names.
  ms_excel.list_tables
• List Worksheets
  List the worksheets in a workbook, with their names and positions.
  ms_excel.list_worksheets
• Write Range
  Write values, formulas or number formats into one A1 range. Each is a two-dimensional array shaped exactly like the range.
  ms_excel.update_range