jakarta的poi项目提供了一组操纵windows文档的java api,如下几个类提供了操作excel文件的方便的途径:hssfworkbook、hssfsheet、hssfrow、hssfcell,分别代表了excel电子表格中的book、sheet、行和单元格。
你可以在下面地址下载到最新的poi工具包:
http://jakarta.apache.org/poi/index.html
下面的代码创建一个excel文件test.xls,并在第一行的第一格中写入一条消息:
import org.apache.poi.hssf.usermodel.*;
import java.io.fileoutputstream;
// code run against the jakarta-poi-1.5.0-final-20020506.jar.
public class poitest {
static public void main(string[] args) throws exception {
fileoutputstream fos = new fileoutputstream("d:/test.xls");
hssfworkbook wb = new hssfworkbook();
hssfsheet s = wb.createsheet();
wb.setsheetname(0, "first sheet");
hssfrow row = s.createrow(0);
hssfcell cell = row.createcell(0);
cell.setcellvalue("hello! this message is generated from poi.");
wb.write(fos);
fos.close();
}
}
读取excel文件时,首先生存一个poifsfilesystem对象,由poifsfilesystem对象构造一个hssfworkbook,该hssfworkbook对象就代表了excel文档。下面代码读取上面生成的excel文件写入的消息字串:
poifsfilesystem fs = null;
hssfworkbook wb = null;
try {
fs = new poifsfilesystem(new fileinputstream("d:/test.xls"));
wb = new hssfworkbook(fs);
} catch (ioexception e) {
e.printstacktrace();
}
hssfsheet sheet = wb.getsheetat(0);
hssfrow row = sheet.getrow(0);
hssfcell cell = row.getcell((short) 0);
string msg = cell.getstringcellvalue();
闽公网安备 35060202000074号