110,536
社区成员
发帖
与我相关
我的任务
分享
bool flag=true;
string s_name = "EXCEL";
Process[] ps = Process.GetProcesses();
foreach (Process p in ps)
{
if (p.ProcessName == s_name)
{
flag=false;
//使用进程p,处理单元格
}
}
if(flag)
{
//启用EXCEL处理单元格,处理完成后退出进程
}
private void button1_Click(object sender, RibbonControlEventArgs e)
{
Workbook wbook = Globals.ThisAddIn.Application.ActiveWorkbook; //当前活动workbook
Worksheet worksheet = (Worksheet)wbook.ActiveSheet; //当前活动sheet
int iColCount = worksheet.UsedRange.Rows.Count;
SheetOptions sheet1thread = new SheetOptions(worksheet, iColCount);
Thread othread1 = new Thread(new ThreadStart(sheet1thread.SheetToDataTable));
//wbook.ReadOnlyRecommended;
//worksheet.Protect("aaaaa");
//[code=csharp][code=csharp]
[/code]worksheet.EnableSelection= XlEnableSelection.xlNoSelection;
othread1.Start();
}[/code]
怎样在把worksheet传进去后锁住不让主线程操作,注释的方法都试过了解决不了