Error using csvread to import massive excel file

1 次查看（过去 30 天）

Colin Gilbert 2015-11-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/257663-error-using-csvread-to-import-massive-excel-file

评论： per isakson 2015-11-26

I am using csvread to open a excel file in segments because the original file is too large to open in excel. I can open the first portion of the file with the following code:

% determine the number of data points 
datapoints = 250000;
nc = 54;
% Calculate the range of data removed frome the csv file
r1 = 4;
r2 = ((datapoints*nc)+r1);
c1 = 0;
c2 = 0;
%gather data from csv file
data1 = csvread(file,r1,c1,[r1,c1,r2,c2]);

However when I manipulate the variables to carry on to the next portion of data using the following code:

% determine the number of data points 
datapoints = 100000;
nc = 54;
% Calculate the range of data removed frome the csv file
r3 = ((datapoints*nc)+r2);
c1 = 0;
c2 = 0;
%gather data from csv file
data2 = csvread(file,r2,c1,[r2,c1,r3,c2]);