필터 지우기
필터 지우기

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

조회 수: 5 (최근 30일)
Jess
Jess 2014년 3월 21일
댓글: Jess 2014년 3월 21일
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')

채택된 답변

Azzi Abdelmalek
Azzi Abdelmalek 2014년 3월 21일
편집: Azzi Abdelmalek 2014년 3월 21일
EDIT
n = 1.25 % user desired value
A = {sprintf('%d gram \n',n)}
xlswrite('MP_D.xls',A)
  댓글 수: 3
Azzi Abdelmalek
Azzi Abdelmalek 2014년 3월 21일
Look at edted answer
Jess
Jess 2014년 3월 21일
Thank you!! Eventually I'll master these brackets... :)

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by