how to set a range for xlsread command

15 次查看（过去 30 天）
Sara
Sara 2018-7-24
编辑： 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 个评论
Sara
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.

请先登录，再进行评论。

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

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2018-7-24
编辑：Fangjun Jiang 2018-7-24
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更早的评论
Sara
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
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by