Matlab - Excel activex interface to pass data on opened instance

15 次查看（过去 30 天）
Konstantinos Sofos
Konstantinos Sofos 2016-12-20
评论： Greg 2017-1-19
Hi Community,
I have the following problem. I try to pass data from MATLAB Workspace to an opened Excel instance. Using the following script i manage to pass the data but i do not want to use in general the actxGetRunningServer, as the user can have other Excel instances opened.
Excel = actxGetRunningServer('Excel.Application');
ExcelWorkbook = Excel .Workbooks.Item(1);
ExcelSheet = ExcelWorkbook .ActiveSheet;
a = rand(5,1);
ExcelSheet.Range('A1:A5').Value = a;
ExcelWorkbook.Save
Excel.Quit
I tried then with:
% open the file
Excel = actxserver('Excel.Application');
try
ExcelWorkbook = Excel.workbooks.Open(fullfile(pwd, 'test.xlsx'));
catch ME
Excel.Quit
error('Failed.');
end
% Get the handle of the active Workbook
Sheets = get(get(Excel, 'ActiveWorkBook'), 'Sheets');
for iSheet = 1:Sheets.Count
SheetsName{iSheet,1} = Sheets.Item(iSheet).Name ;
end
[~,idx] = ismember('Cockpit',SheetsName);
Activate(Sheets.Item(idx));
a = rand(5,1);
Select(Range(Excel, 'A1:A5'));
set(Excel.selection, 'Value', num2cell(a));
ExcelWorkbook.Save
ExcelWorkbook.Close(false);
Excel.Quit
and in this case does not pass the data, instead ask to save another instance. I would appreciate a feedback. Thanks in advance!
  1 个评论
Greg
Greg 2017-1-19
Your object access is completely inconsistent. It might be accurate, but it's extremely difficult to sort out what you're trying to do. You pull out a workbook handle, then you work on the activeworkbook.
My guess is change the last 3 lines to be:
Excel.ActiveWorkBook.Save;
Excel.ActiveWorkBook.Close(false);
Excel.Quit;

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by