writecell( [.... -inf inf ...] gives 65535 and 65535 in Excel both for -inf and +inf
11 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
dpb
am 18 Aug. 2020
For some purposes, maybe...a string in the column instead of numeric may break import and return as cellstr() though...not convenient.
Antworten (1)
Maadhav Akula
am 20 Aug. 2020
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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!