Write in an opened excel file using MATLAB

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';

[John D'Errico]

Just use a spreadsheet. You don't really want to use MATLAB, and you are still thinking how to solve your problem as if it was a spreadsheet.

[Max]

I want to use an matlab script to do this

[Walter Roberson]

Do we understand correctly that you want to use a matlab script to inject formulas into the excel spreadsheet and tell excel to execute the formulas?

[Max]

Yes but no exactly , my script generat a value and i would like to inject it into excel but in specific location

[Walter Roberson]

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.

[Max]

I have but I could not get to work while the file is open

Answer 1

[Walter Roberson]

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.