清空筛选条件
清空筛选条件

Writing structure type variable to excel file after passing it throught struct2table failes.

4 次查看（过去 30 天）
Philip Nahmias
Philip Nahmias 2018-12-22
回答： madhan ravi 2018-12-22
Hi,
I have a structure with 9 fields that are either numbers or strings. I then convert that to a table using the struct2table command and I attempt to write the resulting table using xlswrite into an excel sheet. Everytime I try though I get the following result:
Error using xlswrite (line 172)
Input data must be a numeric, cell, or logical array.
How can I resolve this error while maintaining the method I am using as when the table is created it keeps the headers making it easier to keep track of data later.

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

回答（2 个）

Cris LaPierre
Cris LaPierre 2018-12-22
Use struct2table still, but then you need to use the writetable function, not xlswrite. If you want an 'xlsx' file, just give the filename that extension and MATLAB will do the rest.
madhan ravi
madhan ravi 2018-12-22
Download the below file exchange to achieve what you want:
https://www.mathworks.com/matlabcentral/fileexchange/22510-struc2xls

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by