Write in an opened excel file using MATLAB

Max
2022 5 21
1 个回答
更新时间：2022 6 1
2 次查看（30 天）

0 个投票

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 个评论
显示 4更早的评论 隐藏 4更早的评论

John D'Errico
John D'Errico 2022-5-22
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
Max 2022-5-22
I want to use an matlab script to do this
Walter Roberson
Walter Roberson 2022-5-22
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
Max 2022-5-31
Yes but no exactly , my script generat a value and i would like to inject it into excel but in specific location
Walter Roberson
Walter Roberson 2022-5-31
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
Max 2022-6-1
I have but I could not get to work while the file is open

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Walter Roberson
Walter Roberson 2022-5-23

0 个投票

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.

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

提问:

Max
Max
2022-5-21

评论：

Max
Max
2022-6-1

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by