Effacer les filtres
Effacer les filtres

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 vues (au cours des 30 derniers jours)
Manu Gowda
Manu Gowda le 5 Jan 2022
Commenté : Manu Gowda le 7 Jan 2022
File of one row is attached here. Iwant it to be 50 rows file of same values

Connectez-vous pour répondre à cette question.

Réponses (1)

Jan Kudlacek
Jan Kudlacek le 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

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Produits


Version

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by