Precision lost while reading from Excel file to a Matlab table
10 ビュー (過去 30 日間)
古いコメントを表示
Hi,
I am using readtable to read a large high precision matrix from Excel. How to make sure I read the entire decimal points? Thanks,
Jennifer
2 件のコメント
dpb
2016 年 10 月 31 日
How did you determine there was a loss of precision? If the values in the spreadsheet are numeric, then by default readtable will read them as double precision which is the same as what Excel uses.
Show your work and a sample of the data...
採用された回答
Walter Roberson
2016 年 10 月 31 日
readtable() will read the entire binary content that is present in Excel.
However, when you display the output of readtable, the output might not show the entire content. The output would depend upon the "format" command that is in effect.
2 件のコメント
Walter Roberson
2016 年 10 月 31 日
This is not a matter of the readtable() 'Format' option.
At the MATLAB command line give the command
format long g
and display the table again.
The default output is "format short" which is only 4 decimal places.
その他の回答 (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!