Matlab and excel issues, active x server crash
3 ビュー (過去 30 日間)
古いコメントを表示
I am trying to write a program that will read blocks of data from an excel file, and then write them to another excel file. For some reason I cannot get xlswrite command to do what I am trying to do because of error issues. I decided to try to run an active x server and see if this could fix my problem. I am not very familiar with active x but i have been doing alot of research and I dont know what my issue is. For some reason when i try to run the code:
Excel = actxcontrol ('Excel. Application');
i get the error:
Control creation failed. Invalid ProgID 'Excel.Application'
I am running on matlab2008b and excel 2003
0 件のコメント
回答 (1 件)
Mark Whirdy
2013 年 2 月 20 日
編集済み: Mark Whirdy
2013 年 2 月 23 日
PLEASE PRESS [ACCEPT] IF THIS SOLVES YOUR ISSUE, THANKS
....
1) ACTXSERVER
For programmatic manipulation of an excel instance, the launch command is
Excel = actxserver('Excel.Application');
2) ACTXCONTROL
actxcontrol.m is for inserting a activex spreadsheet interface into a figure as per the below snippet. To see which version of the activex spreadsheet you have on your machine type "actxcontrollist" and scan downuntil you see a mention of a spreadsheet
f = figure;
actxcontrol('OWC11.Spreadsheet.11',[20,20,510,380],f);
---------------------------------------------
You are mixing the two up by typing
Excel = actxcontrol ('Excel. Application');
3 件のコメント
Mark Whirdy
2013 年 2 月 22 日
編集済み: Mark Whirdy
2013 年 2 月 23 日
Hi Tyler, but above you wrote that "Excel = actxcontrol ('Excel. Application');" causes the error.
Note that I have written "actxserver" but you have above written "actxcontrol" - they are not the same thing. The error you are receiving is due to erroneous calling of actxCONTROL.
Above I was trying to explain the difference between the two.
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!