本文整理汇总了C#中IWorkbook.GetSheetName方法的典型用法代码示例。如果您正苦于以下问题：C# IWorkbook.GetSheetName方法的具体用法？C# IWorkbook.GetSheetName怎么用？C# IWorkbook.GetSheetName使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IWorkbook的用法示例。
在下文中一共展示了IWorkbook.GetSheetName方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ProcessSheets
protected override void ProcessSheets(IWorkbook workbook, int mainSheetIndex)
{
ExtractSheet(MainSheet, workbook, "Domains", "Tabs");
for (var i = 0; i < workbook.NumberOfSheets; i++)
{
if (i == mainSheetIndex)
continue;
ExtractSheet(workbook.GetSheetName(i), workbook, "eISSN", "Text");
}
}示例2: LinkExternalWorkbook
public int LinkExternalWorkbook(String name, IWorkbook externalWorkbook)
{
int extBookIndex = GetExternalWorkbookIndex(name);
if (extBookIndex != -1)
{
// Already linked!
return extBookIndex;
}
// Create a new SupBookRecord
String[] sheetNames = new String[externalWorkbook.NumberOfSheets];
for (int sn = 0; sn < sheetNames.Length; sn++)
{
sheetNames[sn] = externalWorkbook.GetSheetName(sn);
}
//\000 is octal digit in java, but c# think it is a '\0' and two zero.
String url = "\0" + name;
ExternalBookBlock block = new ExternalBookBlock(url, sheetNames);
// Add it into the list + records
extBookIndex = ExtendExternalBookBlocks(block);
// add the created SupBookRecord before ExternSheetRecord
int idx = FindFirstRecordLocBySid(ExternSheetRecord.sid);
if (idx == -1)
{
idx = _workbookRecordList.Count;
}
_workbookRecordList.Add(idx, block.GetExternalBookRecord());
// Setup links for the sheets
for (int sn = 0; sn < sheetNames.Length; sn++)
{
_externSheetRecord.AddRef(extBookIndex, sn, sn);
}
// Report where it went
return extBookIndex;
}示例3: RemoveAllSheetsBut
private static void RemoveAllSheetsBut(int sheetIndex, IWorkbook wb)
{
int sheetNb = wb.NumberOfSheets;
// Move this sheet at the first position
wb.SetSheetOrder(wb.GetSheetName(sheetIndex), 0);
for (int sn = sheetNb - 1; sn > 0; sn--)
{
wb.RemoveSheetAt(sn);
}
}示例4: RemoveAllSheetsBut
// public void Test57165b(){
// IWorkbook wb = new XSSFWorkbook();
// try {
// wb.CreateSheet("New Sheet 1");
// wb.CreateSheet("New Sheet 2");
// } finally {
// wb.Close();
// }
// }
private static void RemoveAllSheetsBut(int sheetIndex, IWorkbook wb)
{
int sheetNb = wb.NumberOfSheets;
// Move this sheet at the first position
wb.SetSheetOrder(wb.GetSheetName(sheetIndex), 0);
// Must make this sheet active (otherwise, for XLSX, Excel might protest that active sheet no longer exists)
// I think POI should automatically handle this case when deleting sheets...
// wb.SetActiveSheet(0);
for (int sn = sheetNb - 1; sn > 0; sn--)
{
wb.RemoveSheetAt(sn);
}
}