package cn.eabax.fory.excelTest;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class testExcel {
/**
* Excel简单操作
* @param args
*/
public static void main(String[] args) {
POIFSFileSystem fs;
try {
// 读取excel模板
fs = new POIFSFileSystem(new FileInputStream("d://test.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
// 取得行
HSSFRow row = sheet.createRow((short) 0);
// 取得列
HSSFCell cell = row.createCell((short) 0);
// 设置单元格值
cell.setCellValue(1);
row.createCell((short) 1).setCellValue(1.2);
//设置类型为String的单元格值需使用HSSFRichTextString
row.createCell((short) 2).setCellValue(new HSSFRichTextString(
"This is a String value test !"));
// 保存为Excel格式文件
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
参考文章:http://poi.apache.org/hssf/quick-guide.html