Reading a Protected Sheet using Excel App Scope Read Range

Help
1

Hi,

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?

2

Hi @PRIYA_GUPTA

What is the Range set in the Read Range activity?
If you use double quotes "" and the Excel file remembered working range is a bit corrupted it will read more than it should.