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

2 views (last 30 days)
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'

Accepted Answer

Monisha Nalluru
Monisha Nalluru on 15 Sep 2020
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
Image Analyst
Image Analyst on 21 Sep 2020
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.

Sign in to comment.

More Answers (1)

Image Analyst
Image Analyst on 14 Sep 2020
You can call xlswrite() again to just write 'Req#' to A1
xlswrite(fileName, 'Req #', sheetName, 'A1');




Community Treasure Hunt

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

Start Hunting!