writecell( [.... -inf inf ...] gives 65535 and 65535 in Excel both for -inf and +inf
11 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
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 日
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:
Hope this Helps!
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!