清空筛选条件
清空筛选条件

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

12 次查看（过去 30 天）
Manu Gowda
Manu Gowda 2022-1-5
评论： Manu Gowda 2022-1-7
File of one row is attached here. Iwant it to be 50 rows file of same values

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

回答（1 个）

Jan Kudlacek
Jan Kudlacek 2022-1-5
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

类别

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

标签

产品


版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by