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!

 Accepted Answer

Image Analyst
Image Analyst on 17 Feb 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 Comments

My Excel Version is Excel2013,can you tell me how to change my code? Thanks a lot!
Put in the proper OWC. OWC14 or whatever it is.
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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!