about write data to the first sheet of excel
3 次查看(过去 30 天)
显示 更早的评论
hello, i want wrtie specific data to several sheet of the excel, and i have named each sheet, but i find may new target sheet will added after sheet1, how i can replace sheet1
0 个评论
采纳的回答
Abhishek Kumar Singh
2024-7-1
I suppose you want to write some data to a specific sheet, here's a sample code you can refer to, which also doesn't creates or adds any new sheet:
% Create a sample table
data = table([1; 2; 3], [4; 5; 6], 'VariableNames', {'Column1', 'Column2'});
% Write the table to a specific sheet in an Excel file
filename = 'testBook.xlsx';
sheet = 'mySheet';
writetable(data, filename, 'Sheet', sheet);
This is what I got:
Hope it helps!
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!