Losing precision when writing to Excel using xlswrite

3 次查看（过去 30 天）

itzhak mal 2019-1-31

评论： Ollie A 2019-1-31

Hi all, I have a matrix on MATLAB with a very percise values, such as: 2 .268073544251674e+03 but when converting to excel it only shows: 2268.1

I used the following command:

xlswrite('MatrixEvoUNSuc',EvoUnsuc)

Is there anyway I could make sure I don't lose that percision?

Thank you!!

Ollie A 2019-1-31

It could be to do with the format of the excel cells. In excel you can increase the number of decimal places displayed.

Otherwise, I tried:

T = table(EvoUnsuc);
writetable(T,'MatrixEvoUNSuc.xls');

which seems to display the number to a higher precision.

madhan ravi 2019-1-31

instead of writing it into one single file why not write in 3 separate files?

Ollie A 2019-1-31

I would try writing the data to a .dat or .txt file instead of .xls.

Reading the data back will be just as easy, and I'm sure the different file format will store all of your data.

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by