java - Apache POI 中读取 Excel 的问题

Question

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.lang.Iterable;

public class ReadExcel {
public static String fileToBeRead = "C:/Documents and Settings/Developer/Desktop/Anand   exmps/Anand.xls";
public static void main(String argv[]) {
try {
    HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
    HSSFSheet sheet = workbook.getSheetAt(0);
    //HSSFRow row = sheet.getRow(0);
    //HSSFCell cell = row.getCell((short) 0);
    for (Row row : sheet) {
    for (Cell cell : row) {
        System.out.println("THE TOP LEFT CELL–> "+ cell.getRichStringCellValue());
    }
}

} catch (Exception e) {
    System.out.println("!! Bang !! xlRead() : " + e);
}   

}

}

编译上述程序时出现如下错误。一定是什么原因？请修复。我是 Java 的初学者。

 ReadExcel.java:16: cannot find symbol
 symbol  : class Row
 location: class ReadExcel
            for (Row row : sheet) {
                 ^
 ReadExcel.java:17: cannot find symbol
 symbol  : class Cell
 location: class ReadExcel
            for (Cell cell : row) {

Answer 1

您忘记导入 Row 和 Cell 类。

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;

---

资源:

• HSSFSheet.getRow(int) returns a Row
• Row iterates on Cell