excel 复选框选中

//选中checkbox事件种类
string IncidentType = dtMain.Rows.Count > 0 ? dtMain.Rows[0]["事件种类"].ToString() : "";
var IncidentTypeArray = IncidentType.Split(',');
foreach (var item in sheet.CheckBoxes)
{
Console.WriteLine("复选框名称:"+ item.Name);

for (int i = 0; i < IncidentTypeArray.Count(); i++)
{
if(item.Text== IncidentTypeArray[i])
{
item.CheckedValue = CheckValueType.Checked;
}
}
}

posted @ 2023-07-04 20:10  .net&new  阅读(4)  评论(0编辑  收藏  举报