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

x33g5p2x  于2022-01-29 转载在 其他  
字(3.9k)|赞(0)|评价(0)|浏览(217)

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

Sheet.getHeader介绍

[英]Gets the user model for the default document header.

Note that XSSF offers more kinds of document headers than HSSF does
[中]获取默认文档标题的用户模型。
请注意,XSSF提供的文档标题种类比HSSF更多

代码示例

代码示例来源:origin: looly/hutool

/**
 * 设置Excel页眉或页脚
 * 
 * @param text 页脚的文本
 * @param align 对齐方式枚举 {@link Align}
 * @param isFooter 是否为页脚,false表示页眉,true表示页脚
 * @return this
 * @since 4.1.0
 */
public ExcelWriter setHeaderOrFooter(String text, Align align, boolean isFooter) {
  final HeaderFooter headerFooter = isFooter ? this.sheet.getFooter() : this.sheet.getHeader();
  switch (align) {
  case LEFT:
    headerFooter.setLeft(text);
    break;
  case RIGHT:
    headerFooter.setRight(text);
    break;
  case CENTER:
    headerFooter.setCenter(text);
    break;
  default:
    break;
  }
  return this;
}

代码示例来源:origin: looly/hutool

/**
 * 设置Excel页眉或页脚
 * 
 * @param text 页脚的文本
 * @param align 对齐方式枚举 {@link Align}
 * @param isFooter 是否为页脚,false表示页眉,true表示页脚
 * @return this
 * @since 4.1.0
 */
public ExcelWriter setHeaderOrFooter(String text, Align align, boolean isFooter) {
  final HeaderFooter headerFooter = isFooter ? this.sheet.getFooter() : this.sheet.getHeader();
  switch (align) {
  case LEFT:
    headerFooter.setLeft(text);
    break;
  case RIGHT:
    headerFooter.setRight(text);
    break;
  case CENTER:
    headerFooter.setCenter(text);
    break;
  default:
    break;
  }
  return this;
}

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

InputStream inp = null;
   try {
     inp = new FileInputStream("E:/sample_poi.xls");
     Workbook wb = WorkbookFactory.create(inp);
     Sheet sheet = wb.getSheetAt(0);
     Header header = sheet.getHeader();
     int rowsCount = sheet.getLastRowNum();
     System.out.println("Total Number of Rows: " + (rowsCount + 1));
     for (int i = 0; i <= rowsCount; i++) {
       Row row = sheet.getRow(i);
       int colCounts = row.getLastCellNum();
       System.out.println("Total Number of Cols: " + colCounts);
       for (int j = 0; j < colCounts; j++) {
         Cell cell = row.getCell(j);
         System.out.println("[" + i + "," + j + "]=" + cell.getStringCellValue());
       }
     }
   } catch (Exception ex) {
     java.util.logging.Logger.getLogger(FieldController.class.getName()).log(Level.SEVERE, null, ex);
   } finally {
     try {
       inp.close();
     } catch (IOException ex) {
       java.util.logging.Logger.getLogger(FieldController.class.getName()).log(Level.SEVERE, null, ex);
     }
   }

代码示例来源:origin: SheetJS/jxls

public static void copyPageSetup(Sheet destSheet, Sheet srcSheet) {
  Header header = srcSheet.getHeader();
  Footer footer = srcSheet.getFooter();
  if (footer != null) {
    destSheet.getFooter().setLeft(footer.getLeft());
    destSheet.getFooter().setCenter(footer.getCenter());
    destSheet.getFooter().setRight(footer.getRight());
  }
  if (header != null) {
    destSheet.getHeader().setLeft(header.getLeft());
    destSheet.getHeader().setCenter(header.getCenter());
    destSheet.getHeader().setRight(header.getRight());
  }
}

代码示例来源:origin: net.sf.jxls/jxls-core

public static void copyPageSetup(Sheet destSheet, Sheet srcSheet) {
  Header header = srcSheet.getHeader();
  Footer footer = srcSheet.getFooter();
  if (footer != null) {
    destSheet.getFooter().setLeft(footer.getLeft());
    destSheet.getFooter().setCenter(footer.getCenter());
    destSheet.getFooter().setRight(footer.getRight());
  }
  if (header != null) {
    destSheet.getHeader().setLeft(header.getLeft());
    destSheet.getHeader().setCenter(header.getCenter());
    destSheet.getHeader().setRight(header.getRight());
  }
}

代码示例来源:origin: cn.hutool/hutool-all

/**
 * 设置Excel页眉或页脚
 * 
 * @param text 页脚的文本
 * @param align 对齐方式枚举 {@link Align}
 * @param isFooter 是否为页脚,false表示页眉,true表示页脚
 * @return this
 * @since 4.1.0
 */
public ExcelWriter setHeaderOrFooter(String text, Align align, boolean isFooter) {
  final HeaderFooter headerFooter = isFooter ? this.sheet.getFooter() : this.sheet.getHeader();
  switch (align) {
  case LEFT:
    headerFooter.setLeft(text);
    break;
  case RIGHT:
    headerFooter.setRight(text);
    break;
  case CENTER:
    headerFooter.setCenter(text);
    break;
  default:
    break;
  }
  return this;
}

代码示例来源:origin: pentaho/pentaho-reporting

sheet.getHeader().setLeft( pageHeaderLeft );
sheet.getHeader().setCenter( pageHeaderCenter );
sheet.getHeader().setRight( pageHeaderRight );

相关文章

微信公众号

最新文章

更多