Return the names of all sheets in the workbook.

Return every named table in the workbook.

Each entry contains:

• name: display name of the table

• sheet: sheet the table lives on

• ref: cell range (e.g. "A1:D20")

Return every pivot table in the workbook.

Each entry contains:

• name: pivot table name

• sheet: sheet the pivot table is rendered on

• ref: cell range of the pivot table output

• source_sheet: data source sheet (if determinable, else null)

• source_ref: data source range (if determinable, else null)

Return cell data from a sheet.

• sheet_name: name of the sheet to read

• cell_range: optional Excel range string (e.g. "A1:D10"). When omitted the entire used range is returned.

Returns a dict with:

• sheet: sheet name

• range: the range that was read

• rows: list of rows; each row is a list of cell values

Return data from a named Excel table.

• table_name: the display name of the table (from list_tables)

Returns a dict with:

• table: table name

• sheet: sheet the table lives on

• ref: cell range

• headers: first row (column headers)

• rows: remaining rows as list of lists

Export a single Excel sheet to a CSV file.

• file_path: path to the source .xlsx workbook

• sheet_name: name of the sheet to export

• output_path: destination file path (e.g. "/tmp/data.csv"), or "return inline" to return the content directly without saving

• delimiter: column separator — "comma" (default), "pipe", or "tab"

• cell_range: optional Excel range string (e.g. "A1:D10"). When omitted the entire used range is exported.

Returns a dict with:

• output_path: path of the file written (omitted when returning inline)

• content: CSV text (only present when returning inline)

• sheet: sheet name

• range: the range that was exported

• rows_written: number of rows written

Export a single Excel sheet to a plain-text delimited file.

Values are joined with the chosen delimiter with no CSV quoting applied, making output easy to read as a flat text file.

• file_path: path to the source .xlsx workbook

• sheet_name: name of the sheet to export

• output_path: destination file path (e.g. "/tmp/data.txt"), or "return inline" to return the content directly without saving

• delimiter: column separator — "pipe" (default), "comma", or "tab"

• cell_range: optional Excel range string (e.g. "A1:D10"). When omitted the entire used range is exported.

Returns a dict with:

• output_path: path of the file written (omitted when returning inline)

• content: text content (only present when returning inline)

• sheet: sheet name

• range: the range that was exported

• rows_written: number of rows written

Export a single Excel sheet to a Markdown table.

The first row is treated as the header row and a separator line is inserted beneath it. All column widths are padded to align the table.

• file_path: path to the source .xlsx workbook

• sheet_name: name of the sheet to export

• output_path: destination file path (e.g. "/tmp/data.md"), or "return inline" to return the content directly without saving

• cell_range: optional Excel range string (e.g. "A1:D10"). When omitted the entire used range is exported.

Returns a dict with:

• output_path: path of the file written (omitted when returning inline)

• content: markdown text (only present when returning inline)

• sheet: sheet name

• range: the range that was exported

• rows_written: number of rows written (including header)

Create a new blank Excel file at the given path.

Add a new sheet to the Excel file.

Add data to a sheet starting at the given cell.

Add a table to a sheet over the given cell range (ref).

Set the value of a single cell in a sheet.

Set a formula in a single cell in a sheet (formula should start with '=').