using xlswrite to edit excel, how to remove the 'content-selection' when I open it.

1 次查看（过去 30 天）

Leo Zhai 2020-9-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/592093-using-xlswrite-to-edit-excel-how-to-remove-the-content-selection-when-i-open-it

评论： Image Analyst 2020-9-21

When I use xlswrite to edti an excel. then I open it, it will shows the edited part as bellow 'now: selection status'(with a gray box).But I want it to be as 'expected: no-selection status'

2 个评论
显示无隐藏无

Monisha Nalluru 2020-9-14

Can you tell the use case for above request.

Leo Zhai 2020-9-21

I want 'write content to Excel, but not indicate the part I write'. Currently, the gray-selection shows it.

请先登录，再进行评论。

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

采纳的回答

Monisha Nalluru 2020-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/592093-using-xlswrite-to-edit-excel-how-to-remove-the-content-selection-when-i-open-it#answer_494845

It is not recommed to use xlswrite(). Instead try to use writetable, writecell, writematrix.

The option of not selecting is not present with xlswrite().

But you can try to use UseExcel=false with above writefunctions

3 个评论
显示 1更早的评论隐藏 1更早的评论

Leo Zhai 2020-9-21

Thanks, M.N

I am using R2013b, only 'writetable' is available, but not 'writecell' nor 'writematrx', But 'UseExcel' is not available either in R2013b.
In R2019b, 'writetable' could sovle my issue, even not using 'UseExcel'.

I am now using the way in 2013b of, thanks to @Image Analyst. while it will slow down a bit of my program.

Image Analyst 2020-9-21

ExcelDemo.m

Yes, with old versions of MATLAB, they did not leave the Excel running as an ActiveX server so each time you called it, it has to launch Excel all over again. The way around that is to use ActiveX the whole way though. I'm attaching an example.

请先登录，再进行评论。