How to name the sheet in excel using MATLAB

53 次查看（过去 30 天）

MakM 2022-3-31

编辑： Arif Hoq 2022-3-31

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

Arif Hoq 2022-3-31

编辑：Arif Hoq 2022-3-31

try this:

writetable(T,'test.xlsx','FileType','spreadsheet','Sheet','a')
% T is your output variable

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by