I need to read very large excel data and I want to calculate it. My data have so much sheets and every sheet has much columns and number of columns isn't specific (e.g: Sheet1 have 150 columns but Sheet2 have 3000 columns) however number of rows are known.
get(Excel.Activesheet.UsedRange)
This code is not working because it select only 256 columns. So, I need to know number of columns for different sheets. Can you help me?