How to read hidden columns from excel


#1

I have two columns in my input excel and want to read data from that column. But while executing the process, i hide those columns and run. So i get an exception saying “Top exception caught :: Object reference not set to an instance of an object. @@@ Anonymously Hosted DynamicMethods Assembly”. I would like to know is there a way to read data even from hidden columns. Thanks


How to get total number of filled rows in excel?
#2

Hi, I tried to read hidden columns from excel file and have no problem.
“Read Cell” for workbook and “Read Range” for Excel Application Scope both worked.

I might misunderstand what you want to do.
Please upload your xaml and Excel file if possible, it’ll help certified members to diagnose your issue :slight_smile:


#3

Hi @ArchanaN,
Reading data from hidden cells in an excel file should not create a problem because

  1. If you are going via Read Cell then you are specifying the cell reference.
  2. If you are going by read range also you are specifying all or Range.
  3. You can try using SQL Query method and check.

Object reference not set to an instance of an object: May be you have some un-referenced variables.
It will be helpful if you upload your workflow or screenshot of your code.

Regards,
Jiban