POI读取EXCEL

[kong2010]

如何用POI读取一个不知行数、不知列数的EXCEL表。

[kong2010]

顶。
用POI可以用sheet.rowIterator();取得行数，但怎么取得列数呢？

[richard1295]

一个操作excel的例子，看对你有帮助否
package excel;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

public class ReadWriteWorkbook
{
public static void main(String[] args)
throws IOException
{
POIFSFileSystem fs =
new POIFSFileSystem(new FileInputStream("d:\\foo.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
wb.removeSheetAt(2);
HSSFSheet sheet = wb.getSheetAt(0);
sheet.setColumnWidth((short)200,(short)500);

HSSFRow row = sheet.getRow(2);
if (row == null)
row = sheet.createRow(2);
HSSFCell cell = row.getCell((short)3);
if (cell == null)
cell = row.createCell((short)3);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue("asafasfsafasfsfaas test");



// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("d:\\ffoo.xls");
wb.write(fileOut);
fileOut.close();
}
}