Discussion:
actxserver excel application using iMac
(too old to reply)
Edward Flórez
2017-06-09 21:29:03 UTC
Permalink
Dear MatLab Users,
I read different posts about actxserver excel application.
Actually I have implemented this procedure some weeks ago with good results.
Nowadays, I am using MatLab at my iMac because it has better features than my regular PC (more RAM memory, better processor, and so on).
Today I tried to export some data from MatLab to Excel using actxserver:

****Part of the code****
hExcel = actxserver('Excel.Application');
hExcel.Visible=1;
hWorkbook = hExcel.Workbooks.Open(filename);
hWorksheet = hWorkbook.Sheets.Item(1);
hWorkbook.Save
hWorkbook.Close
hExcel.Quit
delete(hExcel)

But unexpected I got an error message:
Error using actxserver (line 90)
Server creation failed. Invalid ProgID 'Excel.Application'.
Error in GLCM_ALL (line 41)
hExcel = actxserver('Excel.Application');

However, when I ran the code on my regular PC (OS Windows) I did not have any problem.
Does anyone have some idea about that issue?
How could I do to use actxserver in MatLab (2017a) using my iMac (OS X El Capitan)?

Thank you in advance.
Edward F.
Loukas Lagoudis
2021-07-22 10:30:27 UTC
Permalink
Post by Edward Flórez
Dear MatLab Users,
I read different posts about actxserver excel application.
Actually I have implemented this procedure some weeks ago with good results.
Nowadays, I am using MatLab at my iMac because it has better features than my regular PC (more RAM memory, better processor, and so on).
****Part of the code****
hExcel = actxserver('Excel.Application');
hExcel.Visible=1;
hWorkbook = hExcel.Workbooks.Open(filename);
hWorksheet = hWorkbook.Sheets.Item(1);
hWorkbook.Save
hWorkbook.Close
hExcel.Quit
delete(hExcel)
Error using actxserver (line 90)
Server creation failed. Invalid ProgID 'Excel.Application'.
Error in GLCM_ALL (line 41)
hExcel = actxserver('Excel.Application');
However, when I ran the code on my regular PC (OS Windows) I did not have any problem.
Does anyone have some idea about that issue?
How could I do to use actxserver in MatLab (2017a) using my iMac (OS X El Capitan)?
Thank you in advance.
Edward F.
Does any one short this issue? I am facing the same issues

Loading...