How to fill excel cell color using MATLAB command, and not by the actxserver method?

Question

vinvino 2018-7-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411623-how-to-fill-excel-cell-color-using-matlab-command-and-not-by-the-actxserver-method

评论： Jan 2018-7-26

I would like to set/fill the excel color using Matlab command, I find out some commands using actxserver but i dont want to use it. So kindly let me know is there any command in Matlab to set excel cell color. Thanks in advance!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2018-7-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411623-how-to-fill-excel-cell-color-using-matlab-command-and-not-by-the-actxserver-method#answer_329948

编辑：Jan 2018-7-23

There is no chance to interact with Excel without using the actxserver. So please explain, why you want to avoid this. Until further notice, I would answer:

No, there is no way.

But it works with ActiveX: https://www.mathworks.com/matlabcentral/answers/3352-how-to-set-excel-cell-color-to-red-from-matlab#answer_4983

See also: https://www.mathworks.com/matlabcentral/answers/137633-change-with-matlab-the-background-color-of-a-cell-in-excel-64-bit#answer_142502

2 个评论
显示无隐藏无

vinvino 2018-7-25

编辑：vinvino 2018-7-25

Yes Jan, Thanks for your answer.. I am using through actxserver only.. i just curious to find is there any way to color by using just 'xlswrite' or similar commands.. Thanks again