Write a number and value to the same cell in excel?
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Jess
am 21 Mär. 2014
Kommentiert: Jess
am 21 Mär. 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')
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 21 Mär. 2014
Bearbeitet: Azzi Abdelmalek
am 21 Mär. 2014
EDIT
n = 1.25 % user desired value
A = {sprintf('%d gram \n',n)}
xlswrite('MP_D.xls',A)
3 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!