SpreadsheetGear范围浏览器在Windows应用程序中的使用

简短的回答 :关闭范围资源管理器后,将文本框的Text属性设置为RangeExplorer构造函数中使用的范围内某个单元格的NumberFormat属性。

textbox1.Text = worksheet.Cells["A1"].NumberFormat;

更长的答案 :您可以像下面的代码一样设置范围资源管理器。

// Select a range of cells.
workbookView.ActiveWorksheet.Cells["A1:C3"].Select();

// Get the active workbook set.
SpreadsheetGear.IWorkbookSet workbookSet = workbookView.ActiveWorkbookSet;

// Create the Range Explorer which operates on the current range selection.
SpreadsheetGear.Windows.Forms.RangeExplorer explorer 
  = new SpreadsheetGear.Windows.Forms.RangeExplorer(workbookSet);

// Set up some FormClosed event handler.
explorer.FormClosed 
  += new System.Windows.Forms.FormClosedEventHandler(rangeExplorer_FormClosed);

// Display the Range Explorer to the user.
explorer.Show(workbookView);

在FormClosed事件处理程序中,可以获取RangeExplorer构造函数中使用的范围内任何位置的NumberFormat。如果您的文本框名为textbox1,它将如下所示。

private void rangeExplorer_FormClosed(object sender, System.Windows.Forms.FormClosedEventArgs e)
{
    workbookView.GetLock();
    try
    {
      SpreadsheetGear.IWorksheet worksheet = workbookView.ActiveWorksheet;
      textbox1.Text = worksheet.Cells["A1"].NumberFormat;
    }
    finally
    {
      workbookView.ReleaseLock();
    }
}