How to name the sheet in excel using MATLAB

16 vues (au cours des 30 derniers jours)
MakM
MakM le 31 Mar 2022
Modifié(e) : Arif Hoq le 31 Mar 2022
I am writing table to excel sheet, is there any way I can name the excel sheet no. Like instead of sheet 1 or sheet 2 I want to name it a and b.
writetable([Table{1,j}], 'test.xlsx','Sheet', j, 'Range', 'A1')

Réponse acceptée

Arif Hoq
Arif Hoq le 31 Mar 2022
Modifié(e) : Arif Hoq le 31 Mar 2022
try this:
writetable(T,'test.xlsx','FileType','spreadsheet','Sheet','a')
% T is your output variable

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by