how to link an excel file containing inputs and output columns with Matlab
12 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have an excel file in which some coulmns have data entered by user and some columns are output using some formula. I dont want to apply these formulae again in Matlab rather i want to link my excel file to matlab so that any change in the input will be directly changed in the Matlab. The columns in excel showing formula shall be read as formula by the Matlab. If anyone knows about it please share
0 Kommentare
Antworten (2)
dpb
am 25 Aug. 2021
The builtin functions in MATLAB to read/write Excel files read only the data content from cells, not the formulas contained in cells. To do the latter will require using the ActiveX and writing the VBA equivalent. This is more of an Excel VBA syntax issue than MATLAB.
0 Kommentare
Walter Roberson
am 26 Aug. 2021
The post https://www.mathworks.com/matlabcentral/answers/91569-will-it-be-possible-to-use-xlswrite-to-write-formulas-to-the-excel-sheet-which-would-be-calculated-a#answer_100920 from years ago appears to claim that you can write formulas using xlswrite().
I cannot demonstrate here using xlswrite() as it is not supported on this online system. But you can see that for using writecell() instead, it does not work... and it gets odd for .xls files (but does not get odd for xlsx files)
filename = [tempname() '.xls'];
cleanMe = onCleanup(@() delete(filename));
a={'1','2','=sum(a1,b1)'};
a(2,:)={'4' '5' '=sum(a2,b2)'};
a(3,:)={4, 5 ,'=sum(a3,b3)'}
writecell(a,filename)
t = readtable(filename, 'readvariablenames', false)
c = readcell(filename)
[P,Q,R] = xlsread(filename)
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!