Save a data in .xls

2 vues (au cours des 30 derniers jours)
Sérgio Querido
Sérgio Querido le 10 Mai 2015
Modifié(e) : Sérgio Querido le 10 Mai 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 commentaires
Geoff Hayes
Geoff Hayes le 10 Mai 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 le 10 Mai 2015
It just change the number of decimal places.

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Text Files dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by