之前学习了怎么从excel中读取数据,今天我们再学习一下如何向excel中写入数据,老样子,先从简单的入手。先向一个单元格中写入数据。具体如下 :
package com.xg.test;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class PoiTest3 {
/*
*创建一个excel表
*/
public static void write(OutputStream os) throws IOException{
//初始化一个workbook
HSSFWorkbook workbook=new HSSFWorkbook();
//创建一个表
HSSFSheet sheet=workbook.createSheet("第一个sheet");
//创建一行
HSSFRow row=sheet.createRow(0);
//创建一个单元格
HSSFCell cell=row.createCell(0);
cell.setCellValue("Hello 大西瓜");
workbook.write(os);
}
public static void main(String[] args) {
OutputStream oStream=null;
try {
oStream=new FileOutputStream(new File("c:/dxg.xls"));
write(oStream);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(oStream!=null){
oStream.close();
}
} catch (Exception e2) {
// TODO: handle exception
}
}
}
}