MATLAB Answers

splitting 2 rows of excel using matlab

3 views (last 30 days)
Sourav Datta
Sourav Datta on 12 Jun 2021
Answered: KSSV on 15 Jun 2021
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
Sourav Datta
Sourav Datta on 15 Jun 2021
in simple words
picking up any 2 rows from a series of rows in an excel file and then create another separate excel file keeping only the 2 rows
So if there are 120 rows and I want to split it into multiple excels by keeping the 1st row (which will be constant in all the excel sheets) and any other 1 row
How do I do it

Sign in to comment.

Answers (1)

KSSV
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

Tags

Community Treasure Hunt

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

Start Hunting!