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

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

本文整理了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

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddress;

public class Test {

  public static void main(String[] args)  {

    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet();
    sheet.setAutoFilter(new CellRangeAddress(0, 1, 0,1));
  }
}

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

import java.io.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.util.*;

public class Autofilter {
  public static void main(String[] args) throws Exception {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    sheet.createRow(3).createCell(0).setCellValue("Protocol Number");
    sheet.createRow(4).createCell(0).setCellValue("DEMONNUMBER1");
    sheet.createRow(5).createCell(0).setCellValue("DEMONNUMBER2");
    sheet.createRow(6).setZeroHeight(true);
    sheet.createRow(7).createCell(0).setCellValue("Average");
    sheet.setAutoFilter(CellRangeAddress.valueOf("A4:B4"));
    FileOutputStream fos = new FileOutputStream("autofilter.xls");
    wb.write(fos);
    fos.close();
  }
}

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

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

代码示例来源: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类方法