Read Excel and write output
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
MINATI PATRA
el 13 de En. de 2024
Comentada: MINATI PATRA
el 15 de En. de 2024
R = xlsread('Book1.xlsx') %% Excel sheet (Book1.xlsx) is in 'D' drive
A = 1; B = 2; C = 3;
Nu = A*p1 + B*p2 + C*p3;
I want Matlab to read Excel sheet, columns C, D, and E, then calculate Nu (column F) by the above formula and write the respective values in column F in that excel sheet automatically.
0 comentarios
Respuesta aceptada
Voss
el 13 de En. de 2024
filename = 'Book1.xlsx'; % path to your file, e.g., 'D:\PK79\Book1.xlsx'
% read the file to a table:
T = readtable(filename)
% update the NU column:
A = 1; B = 2; C = 3;
T.NU = A*T.p1 + B*T.p2 + C*T.p3
% write the table back out to file:
writetable(T,filename,'WriteMode','overwritesheet')
% check the result:
T = readtable(filename)
Más respuestas (1)
Image Analyst
el 13 de En. de 2024
What is p1, p2, and p3? You might try
R = xlsread('Book1.xlsx') %% Excel sheet (Book1.xlsx) is in 'D' drive
A = R(:, 1);
B = R(:, 2);
C = R(:, 3);
Nu = A*p1 + B*p2 + C*p3;
3 comentarios
Image Analyst
el 14 de En. de 2024
You accepted Voss's answer so I guess you got it all figured out now.
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!