基于Apache POI 向xlsx写入数据
来源:互联网 发布:有什么好用的水乳 知乎 编辑:程序博客网 时间:2024/06/05 12:49
【0】写在前面
- 0.1) these codes are from 基于Apache POI 的向xlsx写入数据
- 0.2) this idea is from http://cwind.iteye.com/blog/2187670 , adding some comments for easy understanding proves to be my work.
package com.cwind.poi; import java.io.FileOutputStream;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.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;/** * @author Billy Chen */public class SimpleDatasheetWriter { private static final String[] titles = { "姓名", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday"}; //sample data to fill the sheet. private static final String[][] data = { {"AngelaBaby", "跑了", "跑了", "跑了", "跑了", "跑了"}, {"邓超", "跑了", "跑了", "没跑", "跑了", "跑了" }, {"王祖蓝", "没跑", "没跑", "没跑", "跑了", "跑了" }, {"王宝强", "跑了", "跑了", "跑了", "跑了", "跑了" }, {"郑恺", "跑了", "跑了", "跑了", "跑了", "跑了" } }; public static void main(String[] args) throws Exception { Workbook wb;
//创建工作簿
if(args.length > 0 && args[0].equals("-xls")) wb = new HSSFWorkbook(); else wb = new XSSFWorkbook();
//创建名为 Running Man 的纸张
Sheet sheet = wb.createSheet("Running Man");
//创建行坐标为0的行(为什么管它叫坐标,不把它叫做行,呵呵)
Row headerRow = sheet.createRow(0);
//设置行高
headerRow.setHeightInPoints(12.75f); for (int i = 0; i < titles.length; i++) {
//创建行坐标为0的单元格,且其列坐标为i;
Cell cell = headerRow.createCell(i);
//设置单元格的value
cell.setCellValue(titles[i]); } Row row; Cell cell; int rownum = 1; for (int i = 0; i < data.length; i++, rownum++) {
//创建行坐标为rownum 的行
row = sheet.createRow(rownum); if(data[i] == null) continue; for (int j = 0; j < data[i].length; j++) {
// 为行创建单元格;
cell = row.createCell(j);
// 设置单元格的value
cell.setCellValue(data[i][j]); } } System.out.println("Default column width: " + sheet.getRow(0).getLastCellNum()); System.out.println("Default column width: " + sheet.getRow(0).getPhysicalNumberOfCells());
// Write the output to a file
String file = "E:/bench-cluster/temp-resource/RunningMan.xlsx"; if(wb instanceof XSSFWorkbook) file += "x"; FileOutputStream out = new FileOutputStream(file); wb.write(out); out.close();// BufferedWriter bw = new BufferedWriter(new FileWriter(file)); }}
0 0
- 基于Apache POI 向xlsx写入数据
- 基于Apache POI 从xlsx读出数据
- POI使用案例02---向excel中写入数据
- Apache POI TXT转成EXCEL(XLSX)
- Apache POI EXCEL(XLSX)转成JSON
- poi写入读取excel 2007版xlsx 97版xls
- poi写入读取excel 2007版xlsx 97版xls
- selenium Excel数据驱动测试(基于 TestNG Apache POI)
- Apache POI 读写 Excel file (.xls or .xlsx)
- POI向EXCEL写入图片(转)
- poi读取数据写入excel
- 使用Apache POI创建Excel,并从数据库中读取数据写入到Excel文件中
- 使用Apache POI读取Excel文件,将读取的数据转换成json写入文本文件
- Apache POI 读取、写入Excel文件教程
- 【Apache POI】Java写入Excel文件
- JavaEE POI读取 Excel中的数据,(Excel2003(xls), Excel2007(xlsx))
- java使用poi读取excel数据(xlsx)
- java 基于poi 写入excel 合并单元格
- uva 11538 - Chess Queen 先分步还是先分类? 计数问题
- hdu 3078 Network (LCA转RMQ)
- iOS一行代码搞定网络请求(AFNetWorking结合ReactiveCocoa)(3)
- JavaScript学习笔记2-附录(转自w3cschool)
- 过去是行不通的3
- 基于Apache POI 向xlsx写入数据
- 弹窗实验
- CSS选择器优先级
- jquery获取ip地址
- noip2003 麦森数 (数论,高精乘单精)
- python中range函数的使用
- 预测的原理及其实战(2)
- Regularization Exercise
- 每周前端知识整理(15.08.23)