xlswrite precision problem

Question

Rok mr 2012-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/29461-xlswrite-precision-problem

Hi!

I have a huge amount of data in array (60000x17) with precision of 3 decimal places. After some operations I would like to save that array in excel file by using xlswrite command. The problem is that whenever I do that the excel file become where huge because all the numbers are stored as double (15 decimal places).

So my question is how can you store an array with only 3 decimal places by using xlswrite command?

I also tried to transform numbers into single before saving but it didn't work.

thank you in advance!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ken Atwell 2012-2-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/29461-xlswrite-precision-problem#answer_37820

在 MATLAB Online 中打开

xlswrite does not provide this option itself.

You could do the rounding in MATLAB before committing to file:

 A=rand(3)
 xlswrite('foo.xlsx', round(A*1e3)/1e3);

This should mostly work, but I suppose there may be cases where an exported value can be ?.???99999999999999 or some such. There may be a better numerical way to do this kind of round, but I don't know what it might be.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Image Analyst 2012-2-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/29461-xlswrite-precision-problem#answer_37835

That's only 1,020,000 elements. Hardly huge at all. Even with double precision (8 bytes per number), your file is only about 8 megabytes, right? That's not even as big as a run of the mill point and shoot camera image. Why do you need to make this tiny file even smaller? What kind of file sizes are you getting from Excel?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rok mr 2012-2-18

the problem was that I used xslwrite('hhh.xls',...) and not a newer extension of excel .xlsx.

In first case if I tried to merge 5 arrays (60000x17) on a separate sheets in one file it was 100MB. But if I use .xlsx the file is 40MB and it's okay.

请先登录，再进行评论。