How to name the sheet in excel using MATLAB

37 visualizzazioni (ultimi 30 giorni)
MakM
MakM il 31 Mar 2022
Modificato: Arif Hoq il 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')

Accedi per rispondere a questa domanda.

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by