How to name the sheet in excel using MATLAB

82 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)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by