有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java使用ApachePOI获取最后一行值

获取java。当我试图获取 使用getLastRowNum()函数在excel工作表中的最后一行

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;   
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Excel{
public static File file;
public static FileInputStream input;
public static FileOutputStream output;
public static HSSFWorkbook book;     
public static HSSFSheet sheet;
public static int value;
public Excel(String path) {


    try {
        file= new File(path);//creating file//
        input=new FileInputStream(file);
        book=new HSSFWorkbook(input);           
        sheet=book.getSheetAt(0);                
        output=new FileOutputStream(file);          
    }
    catch(Exception e) {
        e.getMessage();
    }
        }
public static void readData() {
    int value =sheet.getLastRowNum();//trying to get the last row value//
    System.out.println(value);

}
}

驾驶员等级:

      public class ExcelTest {
      public static void main(String[] args) {
      Excel excel = new Excel("C:/Users/HOME/Desktop/Sample.xlsx");
      Excel.readData();     
}
} 

请在这个问题上提供帮助


共 (0) 个答案