CODEWITHSUNDEEP
excelmatlabcom-server
hileli
hileli

Reputation: 21

How to read all excel data with Matlab COM server

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?

Upvotes: 2

Views: 85

Answers (0)

Related Questions