本文整理汇总了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.removeSheetAt方法的典型用法代码示例。如果您正苦于以下问题：Java HSSFWorkbook.removeSheetAt方法的具体用法？Java HSSFWorkbook.removeSheetAt怎么用？Java HSSFWorkbook.removeSheetAt使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.hssf.usermodel.HSSFWorkbook的用法示例。
在下文中一共展示了HSSFWorkbook.removeSheetAt方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: createSheetFromTemplate
import org.apache.poi.hssf.usermodel.HSSFWorkbook; //导入方法依赖的package包/类
private void createSheetFromTemplate(final ProgressMonitor monitor, final HSSFWorkbook workbook, final ERDiagram diagram, final boolean useLogicalNameAsSheetName) throws InterruptedException {
initSheetNameMap(workbook);
int originalSheetNum = workbook.getNumberOfSheets();
int sheetIndexSheetNo = -1;
while (originalSheetNum > 0) {
final String templateSheetName = workbook.getSheetName(0);
final AbstractSheetGenerator sheetGenerator = getSheetGenerator(templateSheetName);
if (sheetGenerator != null) {
sheetGenerator.generate(monitor, workbook, 0, useLogicalNameAsSheetName, sheetNameMap, sheetObjectMap, diagram, loopDefinitionMap);
workbook.removeSheetAt(0);
} else {
if (!isExcludeTarget(templateSheetName)) {
moveSheet(workbook, 0);
final HSSFSheet sheet = workbook.getSheetAt(workbook.getNumberOfSheets() - 1);
sheetObjectMap.put(templateSheetName, new StringObjectModel(templateSheetName));
if (pictureSheetGenerator != null) {
pictureSheetGenerator.setImage(workbook, sheet);
}
if (sheetIndexSheetGenerator.getTemplateSheetName().equals(templateSheetName)) {
sheetIndexSheetNo = workbook.getNumberOfSheets() - originalSheetNum;
String name = sheetIndexSheetGenerator.getSheetName();
name = AbstractSheetGenerator.decideSheetName(name, sheetNameMap);
monitor.subTaskWithCounter(name);
workbook.setSheetName(workbook.getNumberOfSheets() - 1, name);
} else {
monitor.subTaskWithCounter(sheet.getSheetName());
}
} else {
monitor.subTaskWithCounter("Removing template sheet");
workbook.removeSheetAt(0);
}
monitor.worked(1);
}
originalSheetNum--;
}
if (sheetIndexSheetNo != -1) {
sheetIndexSheetGenerator.generate(monitor, workbook, sheetIndexSheetNo, useLogicalNameAsSheetName, sheetNameMap, sheetObjectMap, diagram, loopDefinitionMap);
}
}
示例2: createSheetFromTemplate
import org.apache.poi.hssf.usermodel.HSSFWorkbook; //导入方法依赖的package包/类
private void createSheetFromTemplate(ProgressMonitor monitor,
HSSFWorkbook workbook, ERDiagram diagram,
boolean useLogicalNameAsSheetName) throws InterruptedException {
this.initSheetNameMap(workbook);
int originalSheetNum = workbook.getNumberOfSheets();
int sheetIndexSheetNo = -1;
while (originalSheetNum > 0) {
String templateSheetName = workbook.getSheetName(0);
AbstractSheetGenerator sheetGenerator = this
.getSheetGenerator(templateSheetName);
if (sheetGenerator != null) {
sheetGenerator.generate(monitor, workbook, 0,
useLogicalNameAsSheetName, this.sheetNameMap,
this.sheetObjectMap, diagram, loopDefinitionMap);
workbook.removeSheetAt(0);
} else {
if (!isExcludeTarget(templateSheetName)) {
moveSheet(workbook, 0);
HSSFSheet sheet = workbook.getSheetAt(workbook
.getNumberOfSheets() - 1);
this.sheetObjectMap.put(templateSheetName,
new StringObjectModel(templateSheetName));
if (this.pictureSheetGenerator != null) {
this.pictureSheetGenerator.setImage(workbook, sheet);
}
if (this.sheetIndexSheetGenerator.getTemplateSheetName()
.equals(templateSheetName)) {
sheetIndexSheetNo = workbook.getNumberOfSheets()
- originalSheetNum;
String name = this.sheetIndexSheetGenerator
.getSheetName();
name = AbstractSheetGenerator.decideSheetName(name,
sheetNameMap);
monitor.subTaskWithCounter(name);
workbook.setSheetName(workbook.getNumberOfSheets() - 1,
name);
} else {
monitor.subTaskWithCounter(sheet.getSheetName());
}
} else {
monitor.subTaskWithCounter("Removing template sheet");
workbook.removeSheetAt(0);
}
monitor.worked(1);
}
originalSheetNum--;
}
if (sheetIndexSheetNo != -1) {
this.sheetIndexSheetGenerator.generate(monitor, workbook,
sheetIndexSheetNo, useLogicalNameAsSheetName,
this.sheetNameMap, this.sheetObjectMap, diagram,
loopDefinitionMap);
}
}
示例3: moveSheet
import org.apache.poi.hssf.usermodel.HSSFWorkbook; //导入方法依赖的package包/类
public static HSSFSheet moveSheet(final HSSFWorkbook workbook, final int sheetNo) {
final HSSFSheet oldSheet = workbook.getSheetAt(sheetNo);
final String sheetName = oldSheet.getSheetName();
final HSSFSheet newSheet = workbook.cloneSheet(sheetNo);
final int newSheetNo = workbook.getSheetIndex(newSheet);
workbook.removeSheetAt(sheetNo);
workbook.setSheetName(newSheetNo - 1, sheetName);
return newSheet;
}
示例4: moveSheet
import org.apache.poi.hssf.usermodel.HSSFWorkbook; //导入方法依赖的package包/类
public static HSSFSheet moveSheet(HSSFWorkbook workbook, int sheetNo) {
HSSFSheet oldSheet = workbook.getSheetAt(sheetNo);
String sheetName = oldSheet.getSheetName();
HSSFSheet newSheet = workbook.cloneSheet(sheetNo);
int newSheetNo = workbook.getSheetIndex(newSheet);
workbook.removeSheetAt(sheetNo);
workbook.setSheetName(newSheetNo - 1, sheetName);
return newSheet;
}