Splitting an excel file using matlab

13 次查看（过去 30 天）
joseph Frank
joseph Frank 2011-7-18
Hi,
I have a 900,000 row excel file that I want to split to 900 files. I am wondering if i can do this with matlab. the content is a single column with strings like :US000305AA00. Kindly advise otherwise i have to do it manually which is very time consuming.

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

采纳的回答

Rick Rosson
Rick Rosson 2011-7-18
Yes, you can do this task with MATLAB. Please try the following:
inputFile = 'myfile';
A = xlsread([ inputFile '.xlsx' ]);
M = 1000;
N = 900;
for k = 0:N-1
outputFile = [ inputFile num2str(k+1,'%03i') '.xlsx' ];
xlswrite(outputFile,A(M*k+(0:M-1)+1));
end
I have tested this code for M = 20 and N = 10, and it works just fine. I suspect, however, that it will take a long time to run for a file containing 900,000 numbers.
HTH.
Rick
  8 个评论
显示 6更早的评论
Rick Rosson
Rick Rosson 2011-7-18
Hi Joseph,
I have given you everything you need to solve this problem. I have tested my code, and it works just fine. Please try to get it to work on your machine with your file. If you assign the correct values to the parameters, use the correct file name and extension, and make sure the file is available on the MATLAB path, it should work.
joseph Frank
joseph Frank 2011-7-18
I imported the file manually using the import wizard and it is working well. Thanks Rick but still I can't figure out why A was empty given that my xlsx file name was ISIN.xlsx

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-7-18
Is the file .csv format or .xls or .xlsx format?
Does the header of the file need to be repeated for each new file?
Is the output fixed at 900 files, or is it fixed at 1000 rows per file?
Probably you probably do not need a lot more than this FAQ
but if your file does happen to be .csv and you do not need to repeat the header line there might be easier alternatives (especially if you are using MacOS or Linux)
  1 个评论
joseph Frank
joseph Frank 2011-7-18
the file is .xlsx format without headers. Each file should contain 1000 observations.so in total I should have 900 files.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by