POI 导出Demo TestExcelPOI.java
来源:互联网 发布:2017淘宝生意差 编辑:程序博客网 时间:2024/05/21 14:08
package com.text;
import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
public class TestExcelPOI {
public static void main(String[] args) {
String newFileName = "d:\\test_performance.xls";
int rows = 10;
int cols = 5;
Date time = new Date();
Workbook book = null;
Sheet sheet = null;
BufferedOutputStream out = null;
try {
// 缓存128在内存
book = new SXSSFWorkbook(128);
sheet = book.createSheet("OQC抽检");
exportToExcel(book, sheet, rows, cols);
out = new BufferedOutputStream(new FileOutputStream(newFileName));
book.write(out);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (out != null) {
try {
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
System.out.println(new Date().getTime() - time.getTime());
}
public static void exportToExcel(Workbook book, Sheet sheet, int row,
int col) throws Exception {
for (int i = 0; i < row; i++) {
Row sheetRow = sheet.createRow(i);
for (int j = 0; j < col; j++) {
Cell cell = sheetRow.createCell(j);
String value = i + "_" + j;
if (j == 2) {
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd");
value = sdf1.format(new Date());
}
cell.setCellValue(value);
}
}
}
}
- POI 导出Demo TestExcelPOI.java
- java poi 导出excel经典demo
- java 通过Apache poi导出excel代码demo实例
- java poi 导出excel
- POI,java导出execl
- Java POI导出excel
- Java POI 导出Excel
- java poi 导出excel
- java POI导出Excel
- JAVA POI 导出excel
- Java POI的导出
- JAVA POI 导出excel
- java poi导出excel
- Java POI 导出EXCEL
- Java POI导出Excel
- 利用poi数据导出到excel demo
- JAVA POI 读EXCEL DEMO
- java poi 读取Excel demo
- DIV圆角
- Socket I/O Models
- 休眠(Hibernate)和睡眠(Sleep)的区别
- 快速理解 Phoenix : SQL on HBASE
- iOS 粒子系统
- POI 导出Demo TestExcelPOI.java
- 新Java运动:设计驱动开发实践1需求分析
- mini2440学习笔记
- The Select Model
- 图片的轮番效果
- 10项即将到来并可能改变世界的技术
- 成员初始化表的作用 实例解析
- 在while循环中,break,continue,return有什么区别?
- 围棋入门(完整版)