I am using Aspose cells (18.104.22.168)
I am reading data from a excel file which have macro on load (which actully ask for some option to check and depend on option it hides some columns of the sheet)
In my code i am reading the columns untill i found a blank cell in perticular row (say header row)
and later reading data from this columns to the get values the columns.
Now,i have used the cells.getColumnWidth() method but it is not returning zero for the hidden column.
Is there any way i can either disable the macro ( because if i directly open excel sheet with macro disable it do not show me the hidden column) or get the columns that are not hidden by macro.
(without unprotecting the sheet)