Exported formulas on excel sheets resulted in text which would not be evaluated automatically
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
michio
am 18 Okt. 2019
Kommentiert: Alex Calder
am 2 Nov. 2022
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 18 Okt. 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.
7 Kommentare
Alex Calder
am 2 Nov. 2022
So do I understand correctly, that there is no solution for environments without Excel installed? I have a managed Linux environment that uses Open Office, rather than Excel.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!