This question is closed. Reopen it to edit or answer.
The technique of using "xlsread"
1 view (last 30 days)
Hi, I am extracting lots of data from 100 Excel sheets. They are financial statement table. For instance in sheet one, the "Total assets" is in row A10, but in second table, "Total assets" is in row 17. How can I use 'xlsread' function to extract data from the given name? Thank you!
Leah on 30 Mar 2012
First you have to read in both numbers and txt
then you can find the cell that contains Total assets
Without knowing exactly what else is in your sheet it's hard to give you much more. Hope it helps.
Image Analyst on 30 Mar 2012
Unless you use ActiveX programming, reading 100 Excel files will be horribly slow because it will involve launching Excel, reading the data, and shutting down Excel 100 times. Better to just open Excel once, reading the files, then shutting it down once. That will bring the time from very many minutes to probably less than one minute.
Richard on 3 Apr 2012
The following link may be useful:
It follows from image analysts' suggestion.