Info

La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.

Format numbers in spreasheet

1 visualización (últimos 30 días)
Sofia Fourkioti
Sofia Fourkioti el 22 de Nov. de 2017
Cerrada: MATLAB Answer Bot el 20 de Ag. de 2021
Hi!I would like to format a spreadsheet because it has wrong values and I can't create the right graph(no commas in some cells,for example the number 657667 intead of 65.7667).I tried to format the excel file first and it showed the correct values. I saved it and I imported the data in matlab ,but once again the wrong values appeared. Any help?
**These data need to get corrected as I have to do some calculations before the graph. For example:
A=1018,637 and B=917,5432 and y=A/B=1.11017. So , the value for y-axis is 1.11017. In fact the value I get is 11017 which is wrong!! **Any help please!!
  1 comentario
Walter Roberson
Walter Roberson el 22 de Nov. de 2017
This may be a difficult problem to deal with, as it deals with whether the decimal separator is comma or period in the file itself.
Is your spreadsheet .xls or .xlsx ? Can you attach a sample of it?

Respuestas (2)

Chayban Ghabech
Chayban Ghabech el 22 de Nov. de 2017
Hello Sofia,
Please upload your excel file.
Or send it via email:
I have faced similar problems before.
Hopefully i can help.

Image Analyst
Image Analyst el 22 de Nov. de 2017
You can create an Excel template, with all the proper formatting and appearance. Then copy it to the file you want for output and call xlswrite() to put the data into the properly formatted file:
copyfile(templateFileName, thisFileName); % Create output file from template.
xlswrite(thisFileName, yourData, sheet, cellReference);

La pregunta está cerrada.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by