充满生活的味道！

package cn.itcast.cc.excel.exports;

import java.io.FileOutputStream;

import java.util.Date;

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

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

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.IndexedColors;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.junit.Test;

/**

 * 测试类，每个方法都是独立的。

 * @author Administrator

 *

 */

public class ExportExcel {

       /**

        * 测试WorkBook

        * @throws Exception

        */

       @Test

       public void testCreateExcel() throws Exception{

              // 创建Workbook

              Workbook wb = new HSSFWorkbook();

              FileOutputStream fileOut = new FileOutputStream("C:/workbook.xls");

              // 写出到文件

              wb.write(fileOut);

              fileOut.close();

       }

       /**

        * 测试Sheet

        * @throws Exception

        */

       @Test

       public void testCreateSheet() throws Exception{

              Workbook wb = new HSSFWorkbook();

              FileOutputStream fileOut = new FileOutputStream("C:/workbook.xls");

              // 创建sheet

              Sheet sheet = wb.createSheet("HelloWorld!");

              // 设置第1列宽度，列号以0开始。

              sheet.setColumnWidth(0,10000);        

              wb.write(fileOut);

              fileOut.close();

       }

       /**

        * 测试Cell

        * @throws Exception

        */

       @Test

       public void testCreateCell() throws Exception{

              Workbook wb = new HSSFWorkbook();

              FileOutputStream fileOut = new FileOutputStream("C:/workbook.xls");

              // 创建sheet

              Sheet sheet = wb.createSheet("HelloWorld!");

              // 设置第1列宽度

              sheet.setColumnWidth(0,10000);

              // 创建一行，行号以0开始。

              Row row = sheet.createRow(0);

              // 单元格的样式属性

           CellStyle style = wb.createCellStyle();

           // 底边表格线

           style.setBorderBottom(CellStyle.BORDER_DOUBLE);

           style.setBottomBorderColor(IndexedColors.RED.getIndex());

           style.setDataFormat(wb.getCreationHelper().createDataFormat().getFormat("m/d/yy h:mm"));

              // 创建一个单元格，参数为列号。

           Cell cell = row.createCell(0);

           cell.setCellStyle(style);

           // 向单元格中添加各种类型数据

           cell.setCellValue(new Date());

           row.createCell(1).setCellValue(1.1);

           row.createCell(2).setCellValue("文本型");

           row.createCell(3).setCellValue(true);

           row.createCell(4).setCellType(HSSFCell.CELL_TYPE_ERROR);

           wb.write(fileOut);

              fileOut.close();

       }

}

package cn.itcast.cc.excel.imports;

import java.io.FileInputStream;

import java.io.InputStream;

import java.util.Iterator;

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.ss.usermodel.WorkbookFactory;

import org.junit.Test;

/**

 * 测试类

 * @author Administrator

 *

 */

public class ImportExcel {

       /**

        * 读取excel文件

        * @throws Exception

        */

       @Test

       public void testReadExcel() throws Exception {

              // 读入文件

              InputStream inp = new FileInputStream("C:/workbook.xls");

              Workbook wb = WorkbookFactory.create(inp);

              // 获取Sheet，索引从0开始。

              Sheet sheet = wb.getSheetAt(0);

              // 遍历所有Row

              for(Iterator<Row> items = sheet.rowIterator(); items.hasNext();){

                     Row row = items.next();

                     // 我们本可以使用row.cellIterator()遍历每一个Cell，但我们需要获取具体类型的数据

                     System.out.println(row.getCell(0).getDateCellValue());

                     System.out.println(row.getCell(1).getNumericCellValue());

                     System.out.println(row.getCell(2).getStringCellValue());

                     System.out.println(row.getCell(3).getBooleanCellValue());

                     System.out.println(row.getCell(4).getCellType());

              }

              // 关闭文件

              inp.close();

       }

}