POI读取EXCEL

Question

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

Answer 1

一个操作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();
    }
}