Save a data in .xls

2 次查看（过去 30 天）

Sérgio Querido 2015-5-10

编辑： Sérgio Querido 2015-5-10

I need to save a data in .xls spreadsheet but in the end it doesn't keep the same as you can see in photos.

The code used :

filenamewrite10=[filename1,'_timemotion_2',ext]

dlmwrite(filenamewrite10,timemotion1,'delimiter','\t','precision',4);

how can i fix this?

Geoff Hayes 2015-5-10

Sérgio - what happens if you increase the precision scalar from 4 to something larger? What do you observe in the text file after the increase?

Sérgio Querido 2015-5-10

It just change the number of decimal places.

Image Analyst 2015-5-10

Try getting rid of the 'precision' input, or else use xlswrite() instead of dlmwrite().

Sérgio Querido 2015-5-10

编辑：Sérgio Querido 2015-5-10

Problem solved using of xlswrite().

final code:

filenamewrite1=[filename1,'_timemotion_1',ext]

sheet = 1;

xlRange = 'A1';

xlswrite(filenamewrite1,timemotion1,sheet,xlRange)

MATLAB Language Fundamentals Data Types Characters and Strings

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

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

Translated by