Index number of excel column off


#1

Scenario: Read workbook(add headers setting on) and show row(1),row(2), with empty column header in row(0)

Steps to reproduce: Read workbook and in a for each loop add message box for row(1),row(2). In the .xlsx file have no header for column A, but have headers for columns B and C

Current Behavior: Column A is skipped all together and index 0 is column B

Expected Behavior: Column A should be index 0

Studio/Robot/Orchestrator Version: 2018

Last stable behavior:
Last stable version:
OS Version:
Others if Relevant: (workflow, logs, .net version, service pack, etc):https://nofile.io/f/jg3ZJRStaZS/Main.xaml


#2

Hi there,

Assuming you are using the Read Range activity from the Workbook package, you might need to specify the range to include the column that is being excluded. By default, UiPath is likely ignoring the column with blank data and looking for the first column that contains text.

I just tested this scenario locally using the range “A1:D10” and UiPath outputs the blank String from column A in the For Each loop. You can make the “D10” portion dynamic to read all the necessary data by using an int variable instead of the hard-coded “10” value.

Please let me know if this works for you.

Best,
Nick