本文整理匯總了C#中NPOI.XSSF.UserModel.XSSFWorkbook.GetBuiltInName方法的典型用法代碼示例。如果您正苦於以下問題：C# XSSFWorkbook.GetBuiltInName方法的具體用法？C# XSSFWorkbook.GetBuiltInName怎麽用？C# XSSFWorkbook.GetBuiltInName使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類NPOI.XSSF.UserModel.XSSFWorkbook的用法示例。
在下文中一共展示了XSSFWorkbook.GetBuiltInName方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: TestSetAutoFilter
public void TestSetAutoFilter()
{
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = (XSSFSheet)wb.CreateSheet("new sheet");
sheet.SetAutoFilter(CellRangeAddress.ValueOf("A1:D100"));
Assert.AreEqual("A1:D100", sheet.GetCTWorksheet()[email protected]);
// auto-filter must be registered in workboook.xml, see Bugzilla 50315
XSSFName nm = wb.GetBuiltInName(XSSFName.BUILTIN_FILTER_DB, 0);
Assert.IsNotNull(nm);
Assert.AreEqual(0u, nm.GetCTName().localSheetId);
Assert.AreEqual(true, nm.GetCTName().hidden);
Assert.AreEqual("_xlnm._FilterDatabase", nm.GetCTName().name);
Assert.AreEqual("'new sheet'!$A$1:$D$100", nm.GetCTName().Value);
}示例2: bug55723b
public void bug55723b()
{
XSSFWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
// stored with a special name
Assert.IsNull(wb.GetBuiltInName(XSSFName.BUILTIN_FILTER_DB, 0));
CellRangeAddress range = CellRangeAddress.ValueOf("A:B");
IAutoFilter filter = sheet.SetAutoFilter(range);
Assert.IsNotNull(filter);
// stored with a special name
XSSFName name = wb.GetBuiltInName(XSSFName.BUILTIN_FILTER_DB, 0);
Assert.IsNotNull(name);
Assert.AreEqual("Sheet0!$A:$B", name.RefersToFormula);
range = CellRangeAddress.ValueOf("B:C");
filter = sheet.SetAutoFilter(range);
Assert.IsNotNull(filter);
// stored with a special name
name = wb.GetBuiltInName(XSSFName.BUILTIN_FILTER_DB, 0);
Assert.IsNotNull(name);
Assert.AreEqual("Sheet0!$B:$C", name.RefersToFormula);
}