Read Spreadsheet Raw Data
Command description
Read the underlying spreadsheet values while preserving value types such as numbers and dates.
Command Input Parameters
| input parameters | Input parameter type | Description |
|---|---|---|
| Excel Object | ExcelApp | Spreadsheet object to read from |
| Read Mode | enum | Row, Column, Cell |
| Row Number | str | One-based row number; -n means the nth row from the bottom. Required for Row and Cell modes |
| Column Name | str | Column letter such as A or a one-based column number; -n means the nth column from the right. Required for Column and Cell modes |
| sheet | str | Worksheet name. Defaults to the active worksheet |
Command Output Parameters
| Output parameters | Output parameter type | Description |
|---|---|---|
| Excel Data | any | Raw cell data |
tip
The default openpyxl mode does not require the installation of Microsoft Office or Kingsoft WPS. If the table contains formulas that require real-time calculation by Office/WPS, openpyxl will not refresh the calculation results.