Borrar filtros
Borrar filtros

Write a number and value to the same cell in excel?

5 visualizaciones (últimos 30 días)
Jess
Jess el 21 de Mzo. de 2014
Comentada: Jess el 21 de Mzo. de 2014
This may be an obvious question, but is it possible to write a phrase to an excel spreadsheet such as "XXX grams" where XXX is a value from the program? I've tried used fprintf and sprintf commands to generate this but they only print the quoted portion to the command window. When I go to open the excel file, it prints and entirely wrong number. For example if i'm trying to print "1.25 grams", it will print 1 or some outrageous number such as 14 or 16.
Should I just give up and assume that matlab can't actually do this, or am I doing something wrong?
n = 1.25 % user desired value
A1 = fprintf('%f gram \n',n)
A2 = sprintf('%d gram \n',n)
xlswrite('MP_D.xls',A1,'M_Data','B2')

Respuesta aceptada

Azzi Abdelmalek
Azzi Abdelmalek el 21 de Mzo. de 2014
Editada: Azzi Abdelmalek el 21 de Mzo. de 2014
EDIT
n = 1.25 % user desired value
A = {sprintf('%d gram \n',n)}
xlswrite('MP_D.xls',A)
  3 comentarios
Azzi Abdelmalek
Azzi Abdelmalek el 21 de Mzo. de 2014
Look at edted answer
Jess
Jess el 21 de Mzo. de 2014
Thank you!! Eventually I'll master these brackets... :)

Iniciar sesión para comentar.

Más respuestas (0)

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by