how to set a range for xlsread command

Question

Sara 2018-7-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411895-how-to-set-a-range-for-xlsread-command

编辑： Guillaume 2018-7-25

I write a function to read all CSV files in my folder at once and and save all of them in one table. But I have problem regarding the xlsread command (ensemble data store).

I write my command in this way cell = xlsread(filename, 'H24:S1000'); and this command will be applied for all my CSV files in my folder. However my CSV files have different rows (some of them have more rows than 1000 rows and some of them have less).

Now what I need is to write my command in the way that be able to write this range "from column H row 24 to column S to last row" how should I set this range in my xlsread command.

Thanks for your help

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sara 2018-7-24

I solve my problem in this way. I set the range of the csv file with maximum rows in xlsread command. However I would be happy if somebody suggests me a command since sometimes it is hard to know which file has the maximum rows.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Fangjun Jiang 2018-7-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411895-how-to-set-a-range-for-xlsread-command#answer_330134

编辑：Fangjun Jiang 2018-7-24

在 MATLAB Online 中打开

I would just read the whole sheet and then cut it in MATLAB

[~,~,RawData]=xlsread(filename);
UsefulData=RawData(8:19,24:end);
% 8 and 19 are corresponding to column H and S
char('A'+7)
char('A'+18)

use csvread()

UsefulData=csvread('filename.csv',23,7);
UserfulData(:,19:end)=[];

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sara 2018-7-25

there is no need to use for loop since there is data-store in matlab called "ensemble data" which can read all files with csv or mat extension but you should define a read function. however I found my solution. Tanx

Guillaume 2018-7-25

编辑：Guillaume 2018-7-25

first of all my data are too big and it is time consuming

Using xlsread to read csv data is always going to be very time consuming. dlmread, csvread or the more modern readtable (the latter sounding exactly like what you need) will all be significantly faster than xlsread.

xlsread delegates the parsing of the file to excel. The first thing matlab has to do is start excel (invisibly in the background) which takes a while. It's a complete waste of time when matlab is perfectly capable of reading the files itself.

请先登录，再进行评论。