I am trying to read a protected sheet of an excel file using Read Range in Excel Application Scope.
The sheet has 39 columns. However, when I display the number of columns using dt.columns.count.tostring it shows as 45.
I tried to output the data table as string using ‘Output Data Table’. It shows blank headers from 40th to 45th column.
What’s more surprising is when I read the excel sheet using Workbook activities Read Range it works as expected. It shows only 39 columns.
Can anyone tell me why does this happen with Excel App Scope Read Range?