Imbed an excel in GUI

I want to know how to imbed an excel in GUI.There's a same question in website: http://www.mathworks.cn/support/solutions/en/data/1-20G1MS/index.html?solution=1-20G1MS Then it tell me to go to another website to download a .m file.The website is: http://www.mathworks.com/matlabcentral/fileexchange/6889
But when I download the file only to find some errors when testing.
The error is:
Error using actxcontrol (line 185) Control creation failed. Invalid ProgID 'OWC11.Spreadsheet.13'
Error in Spreadsheet (line 108) Spreadsheet1 = actxcontrol('OWC11.Spreadsheet.13',[0 0 psn(3:4)]);
I'm eager to know how it can have errors and how to correct the code.The code is tested on Matlab2012b.Thanks!

 Réponse acceptée

Image Analyst
Image Analyst le 17 Fév 2013

0 votes

What version of Excel do you have? Is it OWC11 (Excel 2003)? If not you need to change the version in the code.

3 commentaires

QiQin Zhan
QiQin Zhan le 18 Fév 2013
My Excel Version is Excel2013,can you tell me how to change my code? Thanks a lot!
Image Analyst
Image Analyst le 18 Fév 2013
Put in the proper OWC. OWC14 or whatever it is.
QiQin Zhan
QiQin Zhan le 18 Fév 2013
I have test it,but the problem still exists.The OWC seems to be invalid.The problem is how I can know the proper activeX for Excel2013.

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by