POI写数据到Excel

通过一个简单的例子，演示POI如何向Excel文件中写入数据。

package my.excel;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
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 Administrator
 * 2013年03月02日
 */
public class FirstWriteExcel {
	
	public static void main(String[] args) {
		try {
			// 工作簿
			Workbook wb = new XSSFWorkbook();
			
			CreationHelper createHelper = wb.getCreationHelper();
			
			Sheet sheet = wb.createSheet("表格名称");

			// 创建行
			Row row = sheet.createRow((short) 0);
			
			// 创建单元格，方法1
			Cell cell = row.createCell(0);
			cell.setCellValue(1);
			
			// 直接创建单元格，方法2
			row.createCell(1).setCellValue(3.14);
			row.createCell(2).setCellValue(createHelper.createRichTextString("大家好，欢迎学习POI"));
			row.createCell(3).setCellValue(true);

			// 写入文件
//			FileOutputStream fileOut = new FileOutputStream("document/FirstWriteExcel.xls");
			FileOutputStream fileOut = new FileOutputStream("document/FirstWriteExcel.xlsx");
			wb.write(fileOut);
			fileOut.close();
			
			System.out.println("写入成功，运行结束！");
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}

 运行结果：