import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class book
{
public static void main(String[] args) throws Exception
{
//HSSFWorkbook
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet hssfSheet = wb.createSheet("Excel Template");
Row row = hssfSheet.createRow(0);
Cell cell1 = row.createCell(0);
cell1.setCellType(Cell.CELL_TYPE_STRING);
cell1.setCellValue("HSSFWorkbook");
FileOutputStream out = new FileOutputStream(args[0]+"HSSFWorkbook.xls");
wb.write(out);
out.flush();
out.close();
//
SXSSFWorkbook hwb = new SXSSFWorkbook(1000);
hwb.setCompressTempFiles(true);
SXSSFSheet sheet = (SXSSFSheet) hwb.createSheet("Excel Template");
SXSSFRow rowhead = (SXSSFRow) sheet.createRow(0);
Cell xssfCell = rowhead.createCell(0);
xssfCell.setCellType(Cell.CELL_TYPE_STRING);
xssfCell.setCellValue("SXSSFWorkbook");
FileOutputStream fileOut = new FileOutputStream(args[0]+"SXSSFWorkbook.xlsx");
hwb.write(fileOut);
fileOut.flush();
fileOut.close();
Workbook hwb1 = new XSSFWorkbook();
XSSFSheet xssfsheet = (XSSFSheet) hwb1.createSheet("Excel Template");
Row r = xssfsheet.createRow(0);
Cell ce = r.createCell(0);
ce.setCellType(Cell.CELL_TYPE_STRING);
ce.setCellValue("XSSFWorkbook");
FileOutputStream fileOut1 = new FileOutputStream(args[0]+"XSSFWorkbook.xlsx");
hwb1.write(fileOut1);
fileOut1.flush();
fileOut1.close();
}
}
Demo POI
最新推荐文章于 2021-02-16 04:36:32 发布