splitting 2 rows of excel using matlab
조회 수: 2 (최근 30일)
이전 댓글 표시
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
dpb
2021년 6월 12일
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...
답변 (1개)
KSSV
2021년 6월 15일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!