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

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

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.

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”.

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.

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

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