C＃Excel检查单元格在VSTO中包含一个名称(C# Excel Check cell contains a name in VSTO)

 我试图检查单元格是否包含名称或是否为命名范围，如果没有，我将指定一个名称。 这是我的代码： 
 
if (cell.Name.Name == null) 
{ 
    Globals.ThisWorkbook.Names.Add("Temp", cell);
}
else
{
    // Move on
}
 
 但是，上面的代码将抛出COMException 。 相反，我试图通过这样做来绕过它： 
 
try
{
    if (cell.Name.Name == null) { }
}
catch (COMException)
{
    Globals.ThisWorkbook.Names.Add("Temp", cell);
}
 
 第二个代码片段有效，但我的电子表格受到严重影响。 操作从约80毫秒到1700毫秒。 这可能看起来不多，但我正在循环范围选择。 
 
 错误消息是： 
 
System.Runtime.InteropServices.COMException was unhandled by user code
  HResult=-2146827284
  Message=Exception from HRESULT: 0x800A03EC
  Source=""
  ErrorCode=-2146827284
  StackTrace:
       at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
       at Microsoft.Office.Interop.Excel.Range.get_Name()
       at ExcelTemplate1.Sheet1.button2_Click(Object sender, EventArgs e) in c:\Users\User\Desktop\ExcelTemplate1\ExcelTemplate1\Sheet1.cs:line 116
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  InnerException: 
 
 问题是，有没有更好的方法来检查单元命名范围？ 

I am trying to check if a cell contains name or is a named range, if not, I will assign a name. Here is my code: 
 
if (cell.Name.Name == null) 
{ 
    Globals.ThisWorkbook.Names.Add("Temp", cell);
}
else
{
    // Move on
}
 
However, the above code will throw a COMException. Instead, I tried to get around it by doing this: 
 
try
{
    if (cell.Name.Name == null) { }
}
catch (COMException)
{
    Globals.ThisWorkbook.Names.Add("Temp", cell);
}
 
The second code snippet worked but my spreadsheet is taking a serious performance hit. The operation went from ~80 ms to 1700 ms. This may not seem much but I am looping over a range selection. 
 
The error message was: 
 
System.Runtime.InteropServices.COMException was unhandled by user code
  HResult=-2146827284
  Message=Exception from HRESULT: 0x800A03EC
  Source=""
  ErrorCode=-2146827284
  StackTrace:
       at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
       at Microsoft.Office.Interop.Excel.Range.get_Name()
       at ExcelTemplate1.Sheet1.button2_Click(Object sender, EventArgs e) in c:\Users\User\Desktop\ExcelTemplate1\ExcelTemplate1\Sheet1.cs:line 116
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  InnerException: 
 
Question is, is there a better way to check for cell named range?