Reference an excel workbook that's already open

Question

0 个投票

Trying to reference a workbook that's already open rather than opening a new one. I can use activeX to connect to the existing server:

XLex = actxGetRunningServer('Excel.Application');

But having trouble referencing the workbook,tried a few different syntax, eg with 'Book3.xlsx'.

xlFILE = XLex.Workbooks.get('Workbooks','Book3.xlsx');

Or

XLex = get(XLex.Excel.ActiveWorkbook,'Workbooks', 'Book3.xlsx');

Neither of which will work! Thanks,

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Al Dente 2015-5-27

0 个投票

actually

XLex.ActiveWorkbook

would give you a handle to the currently active workbook

you can even

XLex.ActiveWorkbook.Name

to see it's name. If more are open you can

for i = 1:XLex.Workbooks.Count
 disp(XLex.Workbooks.Item(i).Name)
 % XLex.Workbooks.Item(i) is a handle to the i-th item
end

Brad Brown 2015-6-1

This has helped, thanks amr!