How to name the sheet in excel using MATLAB

85 views (last 30 days)
MakM
MakM on 31 Mar 2022
Edited: Arif Hoq on 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')

Sign in to answer this question.

Accepted Answer

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

More Answers (0)

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!