Save a data in .xls

Question

0 个投票

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?

2 个评论
显示无隐藏无

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.

Answer 1

Image Analyst 2015-5-10

0 个投票

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)