How to Split excel file with multi columns into equal smalller excel files using matlab

2 次查看（过去 30 天）
Furat Alobaidy
Furat Alobaidy 2019-10-18
评论： Furat Alobaidy 2019-11-4
Please how can splitting Excel file (n*m) into smallaer equal excel files by matalb
  5 个评论
显示 3更早的评论
dpb
dpb 2019-10-19
"... excel( around (500,000) rwos , I need splitting them into seperate excel files in equal size , (for example each file arround 100000 rows"
Why do they need to be split into files, specifically?
Why not just process the parts desired in memory?
Furat Alobaidy
Furat Alobaidy 2019-10-19
ok thanks,
Why do they need to be split into files, specifically?
buz i need spliting the files into small parts in order to process them as traiining and testing samples for NN learning \
Why not just process the parts desired in memory? i will try that . thanks

请先登录，再进行评论。

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

回答（1 个）

Payas Bahade
Payas Bahade 2019-10-21
Hi Furat,
I have written a code which can be used to split one large excel file into multiple smaller excel files. Following sample code splits given excel file into 3 smaller files of 50 rows each.
inputFile = 'test11';% Input excel file name
M = 50; % Number of rows to be included in splitted excel files
N = 3; % Number of files to be created
for k = 0:N-1
outputFile = [ inputFile num2str(k+1,'%02i') '.xlsx' ];% Output file name
cellRange=[ 'A' num2str(M*k+1) ':' 'D' num2str(M*k+M) ];% Defining area of input excel file to be written in output file
X=readmatrix('test11.xlsx','Range',cellRange);% Reading required area in input excel file
writematrix(X,outputFile);% Writing required area in output file
end
You can achieve your objectives by changing the above code as per your requirements.
Hope this helps!
  6 个评论
显示 4更早的评论
Payas Bahade
Payas Bahade 2019-10-31
Hi Furat,
To resolve the above issue of 'C' column not been read, specify 'OutputType' as 'string' in 'readmatrix' function. Please use code mentioned below:
inputFile = ('book1F');% Input excel file name
M = 100; % Number of rows to be included in splitted excel files
N = 20; % Number of files to be created
for k = 0:N-1
outputFile = [ inputFile num2str(k+1,'%02i') '.xlsx' ];% Output file name
cellRange=[ 'A' num2str(M*k+1) ':' 'D' num2str(M*k+M) ];% Defining area of input excel file to be written in output file
X=readmatrix('book1F.xlsx','Range',cellRange,'OutputType','string'); % Reading required area in input excel file
writematrix(X,outputFile);% Writing required area in output file
end
Hope this helps!

请先登录，再进行评论。

类别

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

标签

产品


版本

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by