org.apache.poi.ss.usermodel.Workbook.setActiveSheet()方法的使用及代码示例

x33g5p2x  于2022-02-02 转载在 其他  
字(1.8k)|赞(0)|评价(0)|浏览(591)

本文整理了Java中org.apache.poi.ss.usermodel.Workbook.setActiveSheet()方法的一些代码示例,展示了Workbook.setActiveSheet()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Workbook.setActiveSheet()方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Workbook
类名称:Workbook
方法名:setActiveSheet

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);

相关文章