Use xlwrite on a specific cell of an EXcel file

2 次查看（过去 30 天）
samar
samar 2014-10-27
回答： Ronit 2025-6-10
Hi everybody, I want to write matlab program results into an Excel file . For Windows Platform I used to use xlswrite and it works well
Example with xlswrite:
Filename='Results'; sheetName=strcat('Sheet11'); xlwrite(Filename, {'c2'},sheetName,'A7'); xlwrite(Filename, c2,sheetName,'B7');
Now, i need to get the samething with xlwrite that works for both Windows and Mac! write in the same sheet in extended mode on specific cells of an Excel file.
Thank you for your help

请先登录，再回答此问题。

回答（1 个）

Ronit
Ronit 2025-6-10
Hello @samar,
To write to specific cells in excel on both Windows and Mac, you should use "writematrix", "writecell", or "writetable" functions. These functions work cross-platform, including macOS and Linux.
However, unlike "xlswrite", they overwrite the entire sheet by default, so if you want to write to specific cells without deleting others, you’ll need to use "writecell" function.
Please refer to the documentation pages for the above functions for more details regarding their implementation:
I hope this helps!

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by