java利用poi导出excel_java利用poi导出excel

package zy.demo.test;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.usermodel.HSSFRichTextString;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFDataFormat;

import org.apache.poi.hssf.util.Region;

import org.hibernate.mapping.Array;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.FileInputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

public class ToExcel {

public static String xlsFile = "d:/test.xls"; // 产生的Excel文件的名称

// 设置cell编码解决中文高位字节截断

@SuppressWarnings("deprecation")

public static void main(String[] agrs) throws IOException {

HSSFWorkbook workbook = new HSSFWorkbook(); // 产生工作簿对象

HSSFSheet sheet = workbook.createSheet("工作表对象"); // 产生工作表对象

// 设置第一个工作表的名称为firstSheet

// 为了工作表能支持中文，设置字符编码为UTF_16

workbook.setSheetName(0, "firstSheet");

// 产生一行，再加8行

HSSFRow row = sheet.createRow((short) 0);

HSSFRow row1 = sheet.createRow((short) 1);

// 设置每一列的宽度

sheet.setColumnWidth((short) 0, (short) 4000);

sheet.setColumnWidth((short) 1, (short) 4000);

sheet.setColumnWidth((short) 2, (short) 4000);

sheet.setColumnWidth((short) 3, (short) 4000);

sheet.setColumnWidth((short) 4, (short) 4000);

sheet.setColumnWidth((short) 5, (short) 4000);

sheet.setColumnWidth((short) 6, (short) 5000);

sheet.setColumnWidth((short) 7, (short) 5000);

sheet.setColumnWidth((short) 8, (short) 5000);

// 产生列

HSSFCell cell1 = row1.createCell((short) 0);

// 设置单元格内容为字符串型

cell1.setCellType(HSSFCell.CELL_TYPE_STRING);

// 为了能在单元格中写入中文，设置字符编码为UTF_16。.....

// 往第一个单元格中写入信息

cell1.setCellValue("第二行");

String[] head = { "行号", "头1", "头2", "头3", "头4", "头5", "头6", "头7", "头8" };

for (int i = 0; i < head.length; i++) {

HSSFCell cell = row.createCell((short) i);

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setCellValue(head[i]);

}

ArrayList list = new ArrayList();

list.add("1");

list.add("2");

list.add("3");

list.add("4");

for(int i=0;i

//创建行

HSSFRow row2 = sheet.createRow((short)(i+2));

//创建列

HSSFCell cell = row2.createCell((short)0);

cell.setCellValue(list.get(0));

}

FileOutputStream fOut = new FileOutputStream(xlsFile);

;

try {

fOut = new FileOutputStream(xlsFile);

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

workbook.write(fOut);

fOut.flush();

System.out.println("文件生成...");

// 以下语句读取生成的Excel文件内容

FileInputStream fIn = new FileInputStream(xlsFile);

HSSFWorkbook readWorkBook = new HSSFWorkbook(fIn);

HSSFSheet readSheet = readWorkBook.getSheet("firstSheet");

HSSFRow readRow = readSheet.getRow(0);

HSSFCell readCell = readRow.getCell((short) 0);

HSSFCell readCell1 = readRow.getCell((short) 1);

System.out.println("第一个单元是：" + readCell.getStringCellValue());

System.out.println(readCell1.getStringCellValue());

}

}

1

顶

0

踩

分享到：

2013-11-06 20:35

浏览 1008

评论