I have a excel file of single row,i want to copy it and paste it in rows below for some number of rows, so that a excel file is of many rows of same values of top original row
5 views (last 30 days)
Show older comments
File of one row is attached here. Iwant it to be 50 rows file of same values
0 Comments
Answers (1)
Jan Kudlacek
on 5 Jan 2022
Hi Manu, try this
t = readtable('avg1.xlsx', 'ReadVariableNames', false);
t = repelem(t, 50, 1); % Fill in the rows
writetable(t, 'avg50.xlsx', 'WriteVariableNames', false)
Cheers,
Jan Kudlacek
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!