How to name the sheet in excel using MATLAB

34 Ansichten (letzte 30 Tage)
MakM
MakM am 31 Mär. 2022
Bearbeitet: Arif Hoq am 31 Mär. 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')

Akzeptierte Antwort

Arif Hoq
Arif Hoq am 31 Mär. 2022
Bearbeitet: Arif Hoq am 31 Mär. 2022
try this:
writetable(T,'test.xlsx','FileType','spreadsheet','Sheet','a')
% T is your output variable

Weitere Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by