Turn all excel sheet background to white

2 次查看（过去 30 天）
Emily
Emily 2022-9-6
回答： dpb 2022-9-7
I'm trying to turn all the excel background color into white.
WB.Worksheets.Item().Range().Interior.ColorIndex=2;
I'm not sure what to put in for both () to have it look for all the areas with datas.
How to set excel cell color to red from Matlab? - MATLAB Answers - MATLAB Central (mathworks.com)
  1 个评论
dpb
dpb 2022-9-7
I don't recall what it's called OTOMH, but there's a property (or method?) that does return the used range in the workbook -- search for the Excel VBA doc for some phrase similar and you'll likely get a link the the MSDN VBA doc's that you can crib from the example code.

请先登录，再进行评论。

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

回答（1 个）

dpb
dpb 2022-9-7

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by