Writing to an Excel Spreadsheet

7 次查看（过去 30 天）

显示更早的评论

Matt Brianik 2018-2-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380268-writing-to-an-excel-spreadsheet

评论： Jingrui Ge 2020-2-25

I keep getting this error:

The specified data range is invalid or too large to write to the specified file format. _ _ Try writing to an XLSX file and use Excel A1 notation f or the range argument, for example, ‘A1:D4’.

I only have 1000 rows and 30 columns of Data but it says I should try writing to an XLSX spreadsheet and not an XLS spreadsheet. How do I do this, Currently I'm using "XLSWRITE"?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rik 2018-2-1

What is the syntax you are using?

请先登录，再进行评论。

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

回答（1 个）

Matt Brianik 2018-2-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/380268-writing-to-an-excel-spreadsheet#answer_303040

xlswrite('TESTTESTTEST',Compound_Identifier,'MDL Sheet','B1')

6 个评论
显示 4更早的评论隐藏 4更早的评论

Rik 2019-7-10

Have you read the documentation for this function?

Jingrui Ge 2020-2-25

Thanks Walter, that totally works

请先登录，再进行评论。

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

类别

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

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

标签

Community Treasure Hunt

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

Translated by