Read Spreadsheet Displayed Data
Command description
Read the text displayed in the spreadsheet cells rather than the underlying typed values.
Cell formatting can change how a value is displayed. For example, a cell containing 1.234 may display 1.23 when formatted to two decimal places. This command returns the displayed value ("1.23") as text. To retrieve the underlying typed value instead, use Read Spreadsheet Raw Data.
The default openpyxl mode converts the original cell value to text but may not reproduce the exact display formatting used by Office or WPS. To read the displayed text exactly as shown, select Office or WPS in Open or Create Spreadsheet.
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 | Displayed cell data converted to text |
The default openpyxl mode does not require the installation of Microsoft Office or Kingsoft WPS.
Example
Copy the data in each sheet to a new sheet
-
Copy the table on the left to the blank table on the right and automatically create a sheet
-
Copy method 1: Copy cell by cell
-
Copy method 2: Copy line by line