Write in an opened excel file using MATLAB
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I would like to search for a specific number like (5444 ) in column B and insert a number like (300) next to it in column C using matlab script while the file is opend , thanks
date B C
05/20/2022 5444 ?
05/22/2022 5445 ?
FileName = 'C:\\\\Desktop\test.xlsx';
6 comentarios
Walter Roberson
el 31 de Mayo de 2022
Have you considered using xlswrite1() that I linked to? It opens a connection to excel and leaves it open for efficiency, and can write by range specification.
Respuestas (1)
Walter Roberson
el 23 de Mayo de 2022
You can put together the reading logic from https://www.mathworks.com/matlabcentral/fileexchange/22365-function-for-faster-data-transfer-matlab-excel and the writing logic from https://www.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1
In particular the reading logic
Select(Range(Excel,sprintf('%s',range)));
DataRange = get(Excel,'Selection');
and then
rawData = DataRange.Value;
to fetch the data from Excel.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!