How to name the sheet in excel using MATLAB

56 views (last 30 days)
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')

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)

Tags

Community Treasure Hunt

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

Start Hunting!