How can I get data from an open Excel file without knowing the file name?

Question

Charlotte McHugh 2017-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349595-how-can-i-get-data-from-an-open-excel-file-without-knowing-the-file-name

评论： Massimo Salese 2022-6-7

I have an unsaved .xlsx file open from another script, and I'm trying to write a Matlab program to extract the data from the file. There is no filename or path, however I am able to access the Active Workbook and corresponding Sheet by using ActiveX. It possible for me to pull the file data from the Workbook or Sheet object?

Here is how I get the workbook and sheet:

    ex = actxGetRunningServer('Excel.Application');
    book =  ex.ActiveWorkbook; 
    sheet = book.Worksheets.Item(1);

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

请先登录，再进行评论。

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

Answer 1

Ankitha Kollegal Arjun 2017-7-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/349595-how-can-i-get-data-from-an-open-excel-file-without-knowing-the-file-name#answer_275292

在 MATLAB Online 中打开

You can add two additional lines to your code as follows:

ex = actxGetRunningServer('Excel.Application');
book =  ex.ActiveWorkbook;
sheet = book.Worksheets.Item(1);
% Below command will read cells A1-B4
cells = sheet.get('Range','A1','B4'); %Specify the range of cells you want to read from the Excel File
data = cells.Value; %'data' will be a cell array containing the excel cell values