How do you write to excel a cell array that contains both strings and numbers?

Question

Avery Krovetz 2017-6-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343058-how-do-you-write-to-excel-a-cell-array-that-contains-both-strings-and-numbers

评论： Jacinta Cleary 2018-10-8

I have to write a relatively large cell array to excel. The text is primarily column headers but the data does have some text intertwined in it. Is there a simple way to do this?

I've done some digging but most everything I've found says use fprintf and specify when data is of a specific type. This data is too large to run something like that.

The text data is in specific columns, if there were a way to identify text data as strings and just tell MATLAB that all other fields are numeric, that's viable.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Guillaume 2017-6-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343058-how-do-you-write-to-excel-a-cell-array-that-contains-both-strings-and-numbers#answer_269375

在 MATLAB Online 中打开

Just pass your cell array to xlswrite, nothing more complex.

%simple demo
c = {'abcd', 1234; 'foobar', -56}
xlswrite('test.xlsx', c);

I don't know where you've seen most everything that says use fprintf. You cannot write excel files with fprintf which is for writing text files. Excel files are binary (or in newer versions, a complex mess that you'd never write yourself as text).

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

Avery Krovetz 2017-6-2

I'm running R2016b. that code generates the warning:

Could not start Excel server for export. XLSWRITE will attempt to write file in CSV format.

Then the error:

An error occurred on data export in CSV format.

请先登录，再进行评论。

Answer 2

Fangjun Jiang 2017-6-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/343058-how-do-you-write-to-excel-a-cell-array-that-contains-both-strings-and-numbers#answer_269376

在 MATLAB Online 中打开

As long as each cell is a single scalar or a single string, what is wrong with using xlswrite() directly?

TestData={'a',1;2,'b'};
xlswrite('ExcelFile',TestData);

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

Jacinta Cleary 2018-10-8

I'm not sure if its a Mac thing (I think I saw that somewhere) but it doesn't seem like xlswrite can write text and data together. I've been trying to get this to work for a while. Does anyone have any updates?

Thanks!

请先登录，再进行评论。