本文整理匯總了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;
}