Clear Filters
Clear Filters

Imbed an excel in GUI

1 view (last 30 days)
QiQin Zhan
QiQin Zhan on 17 Feb 2013
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
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
Image Analyst
Image Analyst on 18 Feb 2013
Put in the proper OWC. OWC14 or whatever it is.
QiQin Zhan
QiQin Zhan on 18 Feb 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.

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!