Importing XLS to a dataset truncates decimal places

3 次查看（过去 30 天）
Jason
Jason 2014-6-30
评论： Star Strider 2014-7-2
Hi all, I am importing a small XLS file into a dataset with mixed numerical and string data. Upon import Matlab truncates all decimals to 4 places. I don't have any super long # of decimals, but the file contains currency rates which extend up to 8 decimal places.
Is there any way to retain the number of decimal places in the dataset from the original XLS file using mixed data types?
Thanks.

请先登录，再回答此问题。

回答（1 个）

Star Strider
Star Strider 2014-6-30
MATLAB is most likely displaying only 4 decimal places. All the data should be there. Consider temporarily setting:
format long
or other such options. See the documentation for format for details.
  3 个评论
显示 1更早的评论
Jason
Jason 2014-7-1
Hi all, thanks for your comments. However, this is not a viewing issue. Matlab is truncating the decimals places to 4. The reason I know is because after importing the file I remove a few columns and export the data back out to XLS and the decimals are truncated to 4 places.
I was using the command:
XLSData = dataset('XLSFile', TempFilePath, 'ReadVarNames', false);
It appears the "'ReadVarNames', false" command causes the decimal truncation when there are column headers in the original XLS file. After removing the "'ReadVarNames', false" command the decimals are no longer truncated. I had to adjust my code somewhat as the column headers are now the column variable names, but that is trivial.
Thanks

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by