本文整理了Java中org.apache.poi.ss.usermodel.Workbook.setActiveSheet()
方法的一些代码示例,展示了Workbook.setActiveSheet()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Workbook.setActiveSheet()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Workbook
类名称:Workbook
方法名:setActiveSheet
[英]Convenience method to set the active sheet. The active sheet is is the sheet which is currently displayed when the workbook is viewed in Excel. 'Selected' sheet(s) is a distinct concept.
[中]设置活动工作表的便捷方法。“活动工作表是在Excel中查看工作簿时当前显示的工作表。”“选定”工作表是一个独特的概念。
代码示例来源:origin: pentaho/pentaho-kettle
data.wb.setActiveSheet( existingActiveSheetIndex );
data.wb.setSelectedTab( existingActiveSheetIndex );
appendingToSheet = false;
data.wb.setActiveSheet( sheetIndex );
data.wb.setSelectedTab( sheetIndex );
代码示例来源:origin: cn.minsin/mutils-excel
public ExcelFunctions sheet(int sheetnum, String name) {
try {
sheet = workbook.getSheetAt(sheetnum);
} catch (Exception e) {
sheet = workbook.createSheet(name);
workbook.setActiveSheet(sheetnum);
}
return this;
}
代码示例来源:origin: cn.minsin/mutils-excel
public ExcelFunctions sheet(int sheetnum) {
try {
sheet = workbook.getSheetAt(sheetnum);
} catch (Exception e) {
sheet = workbook.createSheet();
workbook.setActiveSheet(sheetnum);
}
return this;
}
代码示例来源:origin: org.apache.poi/poi-examples
public static void main(String[]args) throws IOException {
try (Workbook wb = new XSSFWorkbook()) { //or new HSSFWorkbook();
wb.createSheet("row sheet");
wb.createSheet("another sheet");
Sheet sheet3 = wb.createSheet(" sheet 3 ");
sheet3.setSelected(true);
wb.setActiveSheet(2);
// Create various cells and rows for spreadsheet.
try (FileOutputStream fileOut = new FileOutputStream("selectedSheet.xlsx")) {
wb.write(fileOut);
}
}
}
代码示例来源:origin: girtel/Net2Plan
workbook.setActiveSheet(workbook.getActiveSheetIndex() + 1);
内容来源于网络,如有侵权,请联系作者删除!