本文整理汇总了C#中IWorkbook.CreateName方法的典型用法代码示例。如果您正苦于以下问题：C# IWorkbook.CreateName方法的具体用法？C# IWorkbook.CreateName怎么用？C# IWorkbook.CreateName使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IWorkbook的用法示例。
在下文中一共展示了IWorkbook.CreateName方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateNames
//define named ranges for the inputs and formulas
public static void CreateNames(IWorkbook wb)
{
IName name;
name = wb.CreateName();
name.NameName = ("Interest_Rate");
name.RefersToFormula = ("'Loan Calculator'!$E$5");
name = wb.CreateName();
name.NameName = ("Loan_Amount");
name.RefersToFormula = ("'Loan Calculator'!$E$4");
name = wb.CreateName();
name.NameName = ("Loan_Start");
name.RefersToFormula = ("'Loan Calculator'!$E$7");
name = wb.CreateName();
name.NameName = ("Loan_Years");
name.RefersToFormula = ("'Loan Calculator'!$E$6");
name = wb.CreateName();
name.NameName = ("Number_of_Payments");
name.RefersToFormula = ("'Loan Calculator'!$E$10");
name = wb.CreateName();
name.NameName = ("Monthly_Payment");
name.RefersToFormula = ("-PMT(Interest_Rate/12,Number_of_Payments,Loan_Amount)");
name = wb.CreateName();
name.NameName = ("Total_Cost");
name.RefersToFormula = ("'Loan Calculator'!$E$12");
name = wb.CreateName();
name.NameName = ("Total_Interest");
name.RefersToFormula = ("'Loan Calculator'!$E$11");
name = wb.CreateName();
name.NameName = ("Values_Entered");
name.RefersToFormula = ("IF(ISBLANK(Loan_Start),0,IF(Loan_Amount*Interest_Rate*Loan_Years>0,1,0))");
}示例2: AddListValidations
private static void AddListValidations(WorkbookFormatter wf, IWorkbook wb)
{
String cellStrValue
= "a b c d e f g h i j k l m n o p r s t u v x y z w 0 1 2 3 4 "
+ "a b c d e f g h i j k l m n o p r s t u v x y z w 0 1 2 3 4 "
+ "a b c d e f g h i j k l m n o p r s t u v x y z w 0 1 2 3 4 "
+ "a b c d e f g h i j k l m n o p r s t u v x y z w 0 1 2 3 4 ";
String dataSheetName = "list_data";
// "List" Data Validation type
ISheet fSheet = wf.CreateSheet("Lists");
ISheet dataSheet = wb.CreateSheet(dataSheetName);
wf.CreateDVTypeRow("Explicit lists - list items are explicitly provided");
wf.CreateDVDescriptionRow("Disadvantage - sum of item's length should be less than 255 characters");
wf.CreateHeaderRow();
ValidationAdder va = wf.CreateValidationAdder(null, ValidationType.LIST);
String listValsDescr = "POIFS,HSSF,HWPF,HPSF";
String[] listVals = listValsDescr.Split(",".ToCharArray());
va.AddListValidation(listVals, null, listValsDescr, false, false);
va.AddListValidation(listVals, null, listValsDescr, false, true);
va.AddListValidation(listVals, null, listValsDescr, true, false);
va.AddListValidation(listVals, null, listValsDescr, true, true);
wf.CreateDVTypeRow("Reference lists - list items are taken from others cells");
wf.CreateDVDescriptionRow("Advantage - no restriction regarding the sum of item's length");
wf.CreateHeaderRow();
va = wf.CreateValidationAdder(null, ValidationType.LIST);
String strFormula = "$A$30:$A$39";
va.AddListValidation(null, strFormula, strFormula, false, false);
strFormula = dataSheetName + "!$A$1:$A$10";
va.AddListValidation(null, strFormula, strFormula, false, false);
IName namedRange = wb.CreateName();
namedRange.NameName = (/*setter*/"myName");
namedRange.RefersToFormula = (/*setter*/dataSheetName + "!$A$2:$A$7");
strFormula = "myName";
va.AddListValidation(null, strFormula, strFormula, false, false);
strFormula = "offset(myName, 2, 1, 4, 2)"; // Note about last param '2':
// - Excel expects single row or single column when entered in UI, but process this OK otherwise
va.AddListValidation(null, strFormula, strFormula, false, false);
// add list data on same sheet
for (int i = 0; i < 10; i++)
{
IRow currRow = fSheet.CreateRow(i + 29);
SetCellValue(currRow.CreateCell(0), cellStrValue);
}
// add list data on another sheet
for (int i = 0; i < 10; i++)
{
IRow currRow = dataSheet.CreateRow(i + 0);
SetCellValue(currRow.CreateCell(0), "Data a" + i);
SetCellValue(currRow.CreateCell(1), "Data b" + i);
SetCellValue(currRow.CreateCell(2), "Data c" + i);
}
}