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

22 ビュー (過去 30 日間)
Jos Indenkleef
Jos Indenkleef 2020 年 8 月 17 日
回答済み: Maadhav Akula 2020 年 8 月 20 日
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 件のコメント
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
Maadhav Akula 2020 年 8 月 20 日
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:
Also the documentation of xlswrite and writetable mention regarding this.
Hope this Helps!


Community Treasure Hunt

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

Start Hunting!

Translated by