writecell( [.... -inf inf ...] gives 65535 and 65535 in Excel both for -inf and +inf

11 次查看（过去 30 天）

显示更早的评论

Jos Indenkleef 2020-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/580737-writecell-inf-inf-gives-65535-and-65535-in-excel-both-for-inf-and-inf

回答： Maadhav Akula 2020-8-20

table2cell(ToperLow)

ans =

1×5 cell array

{[650]} {[-Inf]} {[-Inf]} {[-Inf]} {[500]}

>> xx = table2cell(ToperLow)

xx =

1×5 cell array

{[650]} {[-Inf]} {[-Inf]} {[-Inf]} {[500]}

writecell( xx, 'test.xls', 'Sheet', 'sheet1', 'UseExcel', false )

Resulting cells in Excel is +65535 instead of - 65535???

650 65535 65535 65535 500

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

Binbin Qi 2020-8-18

I think you can use string to instead of inf

dpb 2020-8-18

For some purposes, maybe...a string in the column instead of numeric may break import and return as cellstr() though...not convenient.

请先登录，再进行评论。

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

回答（1 个）

Maadhav Akula 2020-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/580737-writecell-inf-inf-gives-65535-and-65535-in-excel-both-for-inf-and-inf#answer_482657

Hi,

I believe this is how Excel treats Inf and -Inf in a cell, as @Binbin Qi mentioned one workaround would be to write them as strings as mentioned in the following post:

https://www.mathworks.com/matlabcentral/answers/101501-why-does-matlab-6-5-r13-not-export-nan-or-inf-data-types-properly-when-used-as-an-activex-client

Also the documentation of xlswrite and writetable mention regarding this.

xlswrite is not recommended anymore from R2019a.

Hope this Helps!

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

请先登录，再进行评论。

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

类别

Computational Finance Spreadsheet Link Data Export to MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by