splitting 2 rows of excel using matlab
1 view (last 30 days)
Show older comments
I have 121 rows with data in excel - data for 120 subjects
The first row is the heading coloumn
I want that if Matlab can split each of the 2 rows - heading row and one other row - to be spilit into new excel sheet
So I want Matlab to split the data into 120 excel files with the heading row constant in them combined with another row
Can anyone help ??
2 Comments
dpb
on 12 Jun 2021
That's not clear to me what you want, but MATLAB can write whatever you want however you want it; you just have to have an algorithm by which to generate the file names and pick which data you want for each...
Answers (1)
KSSV
on 15 Jun 2021
T = readtable(myfile) ; % excel file with extension
n = height(T) ;
for i = 1:n
fname = strcat('row',num2str(i),'.xlsx') ;
writetable(T(i,:),fname)
end
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!