org.apache.poi.hssf.usermodel.HSSFSheet.createFreezePane()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(5.0k)|赞(0)|评价(0)|浏览(259)

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

HSSFSheet.createFreezePane介绍

[英]Creates a split (freezepane). Any existing freezepane or split pane is overwritten.

If both colSplit and rowSplit are zero then the existing freeze pane is removed
[中]创建拆分(冻结窗格)。任何现有的冻结窗格或拆分窗格都将被覆盖。
如果colSplit和rowSplit均为零,则现有的冻结窗格将被删除

代码示例

代码示例来源:origin: org.apache.poi/poi

/**
 * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.<p>
 * 
 * If both colSplit and rowSplit are zero then the existing freeze pane is removed
 *
 * @param colSplit Horizonatal position of split.
 * @param rowSplit Vertical position of split.
 */
@Override
public void createFreezePane(int colSplit, int rowSplit) {
  createFreezePane(colSplit, rowSplit, colSplit, rowSplit);
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/**
 * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.<p>
 * 
 * If both colSplit and rowSplit are zero then the existing freeze pane is removed
 *
 * @param colSplit Horizonatal position of split.
 * @param rowSplit Vertical position of split.
 */
@Override
public void createFreezePane(int colSplit, int rowSplit) {
  createFreezePane(colSplit, rowSplit, colSplit, rowSplit);
}

代码示例来源:origin: com.haulmont.thirdparty/poi

/**
 * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.
 * <p/>
 * <p>
 * If both colSplit and rowSplit are zero then the existing freeze pane is removed
 * </p>
 *
 * @param colSplit Horizonatal position of split.
 * @param rowSplit Vertical position of split.
 */
public void createFreezePane(int colSplit, int rowSplit) {
  createFreezePane(colSplit, rowSplit, colSplit, rowSplit);
}

代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev

/**
 * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.
 *
 * <p>
 *     If both colSplit and rowSplit are zero then the existing freeze pane is removed
 * </p>
 *
 * @param colSplit      Horizonatal position of split.
 * @param rowSplit      Vertical position of split.
 */
public void createFreezePane(int colSplit, int rowSplit) {
  createFreezePane(colSplit, rowSplit, colSplit, rowSplit);
}

代码示例来源:origin: org.motechproject/motech-bulk-export-import

public Worksheet(HSSFWorkbook workbook, String sheetName, String title, List<String> columnHeaders) {
  sheet = workbook.createSheet(sheetName);
  initializeLayout(title, columnHeaders);
  sheet.createFreezePane(0, currentRowIndex);
}

代码示例来源:origin: org.apache.poi/poi-examples

public static void main(String[] args) throws IOException {
    try (HSSFWorkbook wb = new HSSFWorkbook()) {
      HSSFSheet sheet1 = wb.createSheet("new sheet");
      HSSFSheet sheet2 = wb.createSheet("second sheet");
      HSSFSheet sheet3 = wb.createSheet("third sheet");
      HSSFSheet sheet4 = wb.createSheet("fourth sheet");

      // Freeze just one row
      sheet1.createFreezePane(0, 1, 0, 1);
      // Freeze just one column
      sheet2.createFreezePane(1, 0, 1, 0);
      // Freeze the columns and rows (forget about scrolling position of the lower right quadrant).
      sheet3.createFreezePane(2, 2);
      // Create a split with the lower left side being the active quadrant
      sheet4.createSplitPane(2000, 2000, 0, 0, Sheet.PANE_LOWER_LEFT);

      try (FileOutputStream fileOut = new FileOutputStream("workbook.xls")) {
        wb.write(fileOut);
      }
    }
  }
}

代码示例来源:origin: TomasKypta/android-lang-tool

private Map<String, Integer> exportDefLang(File valueDir) throws IOException, SAXException {
  Map<String, Integer> keys = new HashMap<String, Integer>();
  HSSFWorkbook wb = new HSSFWorkbook();
  HSSFSheet sheet;
  sheet = wb.createSheet(project);
  int rowIndex = 0;
  sheet.createRow(rowIndex++);
  createTilte(wb, sheet);
  addLang2Tilte(wb, sheet, "default");
  sheet.createFreezePane(1, 1);
  FileOutputStream outFile = new FileOutputStream(outExcelFile);
  wb.write(outFile);
  outFile.close();
  for (String fileName : sAllowedFiles) {
    File stringFile = new File(valueDir, fileName);
    if (!stringFile.exists()) {
      continue;
    }
    keys.putAll(exportDefLangToExcel(rowIndex, project, stringFile, getStrings(stringFile), outExcelFile));
  }
  return keys;
}

代码示例来源:origin: stackoverflow.com

style.setFillPattern(CellStyle.FINE_DOTS);
sheet.createFreezePane(0, 1); // Freeze 1st Row   sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)

代码示例来源:origin: stackoverflow.com

style.setFillPattern(CellStyle.SOLID_FOREGROUND);
sheet.createFreezePane(0, 1); // Freeze 1st Row   sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)

代码示例来源:origin: FenixEdu/fenixedu-academic

sheet.createFreezePane(0, 1, 0, 1);
sheet.autoSizeColumn(1, true);
sheet.autoSizeColumn(2, true);

代码示例来源:origin: org.metaeffekt.core/ae-inventory-processor

private void writeArtifacts(Inventory inventory, HSSFWorkbook myWorkBook) {
  HSSFSheet mySheet = myWorkBook.createSheet("Artifact Inventory");
  mySheet.createFreezePane(0, 1);
  mySheet.setDefaultColumnWidth(20);

代码示例来源:origin: org.metaeffekt.core/ae-inventory-processor

private void writeNotices(Inventory inventory, HSSFWorkbook myWorkBook) {
  HSSFSheet mySheet = myWorkBook.createSheet("License Notices");
  mySheet.createFreezePane(0, 1);
  mySheet.setAutoFilter(new CellRangeAddress(0, 65000, 0, 4));
  mySheet.setDefaultColumnWidth(80);

相关文章

微信公众号

最新文章

更多

HSSFSheet类方法