MATLAB Answers

Change with Matlab the background color of a cell in Excel - 64-bit

20 views (last 30 days)
Tal on 26 Jun 2014
Commented: Tal on 27 Jun 2014
Hey guys : )
I would like to change the background color and font color of a cell in my spreadsheet in Excel. How to figure out the commands for that can be found here.
Now I wonder, because it uses ActiveX, whether it is possible to use this commands with a 64-bit version of Excel installed. (Regarding to this it won't work, will it?)
In case it doesn't - is there a solution how to modify a cell via Matlab in Excel if Excel is a 64-bit version?
Many thanks in advance! Tal

Answers (1)

Image Analyst
Image Analyst on 26 Jun 2014
Yes it is. I use ActiveX with 64 bit MATLAB all the time. No special changes are needed. Attached are some Excel ActiveX utilities.
Tal on 27 Jun 2014
Sadly I don't have right now a Excel 64-bit version for trying but I thought so because Excel 64-bit doesn't support ActiveX controls library, ComCtl & Third-party ActiveX controls and add-ins.
Thanks : )

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!