Precision lost while reading from Excel file to a Matlab table

10 次查看（过去 30 天）
JFz
JFz 2016-10-31
评论： Walter Roberson 2016-10-31
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 个评论
JFz
JFz 2016-10-31
I used 'Format' in readtable, but I got this error:
Invalid parameter name: Format.
dpb
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
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 个评论
JFz
JFz 2016-10-31
Thanks. My matrix is 3000x3000 and each cell is a number with 6 decimals. But after readtable reads in the matrix, each cell becomes only 4 decimals after looking at the output of readtable. I am struggling at how to keep the 6 decimals.
Thanks,
jennifer
Walter Roberson
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!

Translated by