Error while using xlswrite

5 次查看（过去 30 天）
Suchetana Gupta
Suchetana Gupta 2015-6-24
评论： Suchetana Gupta 2015-6-27
I am running Matlab 2014b in my Ubuntu 14.04 desktop. I have an xlswrite command in my piece of code. On running it, I get the message that cannot connect to excel server, attempting to write in csv format. However, even a csv format file doesn't come up. The expected file has ~45000 rows and 6 columns. The same piece of code works quite fine, without any error and gives the desired output in a Windows machine. Earlier codes having xlswrite have worked on my Ubuntu machine with the same error/warning message too and in those cases I actually got a csv file. Can someone please suggest me a solution? Thanks

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

回答（1 个）

Stephen23
Stephen23 2015-6-24
编辑：Stephen23 2015-6-24
For more robust and portable code you should use csvwrite or dlmwrite instead.
xlswrite is dependent on Excel for Windows® and its COM server (part of the typical installation of Excel), and so its behavior is really quite system dependent. This is described in the documentation.
  3 个评论
显示 1更早的评论
Stephen23
Stephen23 2015-6-24
编辑：Stephen23 2015-6-24
It makes our lives easier if you format code properly on this forum, you can use the {} Code button that you will find above the textbox.
Please post your exact code that you are using to save the data with, and some sample data for us to try.
Note the csvwrite documentation clearly states it does not support mixed character and numeric data, so you cannot use it with a header: the data must be pure numeric. If you need a header, then you can use low-level functions to write your own file-writing function.
Suchetana Gupta
Suchetana Gupta 2015-6-27
Well, I solved my problem by using xlwrite function from Matlab Central.

请先登录，再进行评论。

类别

在 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