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

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

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

HSSFSheet.setAutoFilter介绍

暂无

代码示例

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

  1. import org.apache.poi.hssf.usermodel.HSSFSheet;
  2. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  3. import org.apache.poi.ss.util.CellRangeAddress;
  4. public class Test {
  5. public static void main(String[] args) {
  6. HSSFWorkbook workbook = new HSSFWorkbook();
  7. HSSFSheet sheet = workbook.createSheet();
  8. sheet.setAutoFilter(new CellRangeAddress(0, 1, 0,1));
  9. }
  10. }

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

  1. import java.io.*;
  2. import org.apache.poi.hssf.usermodel.*;
  3. import org.apache.poi.ss.util.*;
  4. public class Autofilter {
  5. public static void main(String[] args) throws Exception {
  6. HSSFWorkbook wb = new HSSFWorkbook();
  7. HSSFSheet sheet = wb.createSheet();
  8. sheet.createRow(3).createCell(0).setCellValue("Protocol Number");
  9. sheet.createRow(4).createCell(0).setCellValue("DEMONNUMBER1");
  10. sheet.createRow(5).createCell(0).setCellValue("DEMONNUMBER2");
  11. sheet.createRow(6).setZeroHeight(true);
  12. sheet.createRow(7).createCell(0).setCellValue("Average");
  13. sheet.setAutoFilter(CellRangeAddress.valueOf("A4:B4"));
  14. FileOutputStream fos = new FileOutputStream("autofilter.xls");
  15. wb.write(fos);
  16. fos.close();
  17. }
  18. }

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

  1. mySheet.setAutoFilter(new CellRangeAddress(0, 65000, 0, numCol - 1));

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

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

相关文章

HSSFSheet类方法