Read an Excel File

This Action allows values to be read from an Excel .xls spreadsheet into a table's fields in WorkXpress.

XLSX support will be available in Platform Version 15.02.1047

Settings

Excel file to read

Select the file attachment field that contains the Excel file you wish to read.

Sheet Number

If you are reading from only one sheet, you can enter the sheet number. If you need to read from multiple sheets, use the Expression Builder to fill this field dynamically.

Column Number

If you are reading from only one column, you can enter the column number. If you need to read from multiple sheets, use the Expression Builder to fill this field dynamically.

It's important to note that in excel, the first column number starts with “0”. If you want to read the value in column A on the sheet, then you would need to enter “0”. If you want to read the value in column B on the sheet, then you would need to enter “1”.

Row Number

If you are reading from only one row, you can enter the row number. If you need to read from multiple sheets, use the Expression Builder to fill this field dynamically.

Store Value

Select the field in which to store the value you are reading from Excel.

Describe this action

Useful as a comment, this description will overwrite the automatically generated description in the Action Manager.

action type - read excel.txt · Last modified: 2017/08/23 11:36 by kstennett
Copyright WorkXpress, 2019