创建复选框到范围而不在VSTO应用程序中循环（C＃）... [英] Create checkboxes to range without looping in VSTO application(C#)...

问题描述

我需要在使用data弹出工作表后创建复选框。示例我已经用20行填充了工作表，然后我必须创建复选框对于那20行，截至目前我正在创建通过用户范围
循环的复选框并逐个创建，因为屏幕闪烁，如果数据很大，则需要花费大量时间来创建复选框和屏幕闪烁。我想一次性将所有复选框添加到使用的范围是否有任何方式
这样做，因为我们将数据验证添加到范围。请尽快回复我，因为它非常紧急。

I have an requirement to create the checkboxes after popultaing the sheet with data.Example I have populated the sheet with 20 rows then I have to create the checkbox for those 20 rows,as of now I am creating the checkboxing looping through the userrange and creating one by one because of that the screen is flickering and if the data is huge then it is taking so much of time to create the checkboxes and the screen is flickering.I want to add all the checkboxes to the used range at one go is there any way to do it as we add data validation to a range.Please reply me as soon as possible because its very urgent.

提前致谢。

谢谢，

Meenakshi Nagpal

Meenakshi Nagpal

N.Meenakshi

N.Meenakshi

推荐答案

你好N. Meenakshi，

Hi N.Meenaks

感谢您在MSDN论坛上发帖。

thanks for posting in the MSDN Forum.

根据我的经验，我们必须浏览所有数据行。我将让一些专家参与您的主题，看看他们是否可以帮助您。可能会有一些时间延迟，请耐心等待。

It's based on my experience that we must go through all of the rows of the data. And I will involve some experts into your thread to see whether they can help you. There might be some time delay, appreciate for your patience.

有 美好的一天，

Have  a good day,

Tom

这篇关于创建复选框到范围而不在VSTO应用程序中循环（C＃）...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！