====== Read an Excel File ======
This Action allows values to be read from an Excel .xls spreadsheet into a [[Table|table]]'s [[Field|fields]] in WorkXpress.

//XLSX support will be available in Platform Version 15.02.1047//
===== Settings =====

==== Excel file to read ====
Select the [[Field Type - File Attachment|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 Manager]].