Differences

This shows you the differences between two versions of the page.

Link to this comparison view

action type - read excel [2016/09/14 14:19]
127.0.0.1 external edit
action type - read excel [2017/08/23 11:36] (current)
kstennett [Column Number]
Line 14: Line 14:
  
 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. ​ 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 ​ ==== ==== Row Number ​ ====
action type - read excel.txt ยท Last modified: 2017/08/23 11:36 by kstennett
Copyright WorkXpress, 2018