Info

此问题已关闭。 请重新打开它进行编辑或回答。

The technique of using "xlsread"

1 次查看(过去 30 天)
weijie
weijie 2012-3-30
关闭: MATLAB Answer Bot 2021-8-20
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!
  1 个评论
Leah
Leah 2012-3-30
Is "Total assets" always in column A? Was your example suppose to be: Sheet1 A10 and Sheet2 A17?

回答(3 个)

Leah
Leah 2012-3-30
First you have to read in both numbers and txt
[num txt]=xlsread('Book2.xlsx','Sheet1')
then you can find the cell that contains Total assets
ismember(txt,'Total assets')
Without knowing exactly what else is in your sheet it's hard to give you much more. Hope it helps.

Image Analyst
Image Analyst 2012-3-30
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
Richard 2012-4-3
The following link may be useful:
<http://www.mathworks.com/matlabcentral/fileexchange/22365-function-for-faster-data-transfer-matlab-%3C-%3E-excel>
It follows from image analysts' suggestion.

此问题已关闭。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by