MATLAB Answers

Exported formulas on excel sheets resulted in text which would not be evaluated automatically

8 views (last 30 days)
michio
michio on 18 Oct 2019
Commented: michio on 28 Oct 2019
According to the past post, simply using xlswrite and writecell to export formula as text (char/string) will result in formulas in Excel.
However executing the following on R2019a, Windows 10.
a={'1','2','=sum(a1,b1)'}
a(2,:)={'4' '5' '=sum(a2,b2)'}
a(3,:)={4, 5 ,'=sum(a3,b3)'}
% xlswrite('Book.xls',a)
writecell(a,'Book.xls')
creates the following.
Do we need any set-up on Excel side or is there anything that can be done from MATLAB side? Using ActiveX is of course an option, but I'm looking for simpler option.

  0 Comments

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 18 Oct 2019
That post does not say that the formulas will be executable once written by xlswrite.
None of the table based operations such as writetable or writecell are able to create executable formulas. You will need to use ActiveX methods.

  6 Comments

Show 3 older comments
michio
michio on 18 Oct 2019
It was indeed for xlswrite, but neither of them works (as in the formulas executable) with writecell.
michio
michio on 28 Oct 2019
Setting 'UseExcel' to true resolves the issue with writecell.
a={'1','2','=sum(a1,b1)'}
a(2,:)={'4' '5' '=sum(a2,b2)'}
a(3,:)={4, 5 ,'=sum(a3,b3)'}
writecell(a,'Book.xls','UseExcel',true)

Sign in to comment.

More Answers (0)

Products


Release

R2019b

Translated by