Save a data in .xls

2 views (last 30 days)
Sérgio Querido
Sérgio Querido on 10 May 2015
Edited: Sérgio Querido on 10 May 2015
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 Comments
Geoff Hayes
Geoff Hayes on 10 May 2015
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
Sérgio Querido on 10 May 2015
It just change the number of decimal places.

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 10 May 2015
Try getting rid of the 'precision' input, or else use xlswrite() instead of dlmwrite().
  1 Comment
Sérgio Querido
Sérgio Querido on 10 May 2015
Edited: Sérgio Querido on 10 May 2015
Problem solved using of xlswrite().
final code:
filenamewrite1=[filename1,'_timemotion_1',ext]
sheet = 1;
xlRange = 'A1';
xlswrite(filenamewrite1,timemotion1,sheet,xlRange)

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!