java文件未作为输入传递
在将.xlsb
文件传递给方法时,我得到了NullPointerException
。似乎未选择文件,但该文件存在于该文件夹中。请告知
public class readxlsb {
public static void main(String[] args) throws Exception {
try {
String fileName1 ="C:\\abc\\TULDUBINV_EX_10768148_1.xlsb";
com.smartxls.WorkBook wb = new com.smartxls.WorkBook();
System.out.println(wb);
wb.readXLSB(fileName1);
System.out.println(wb);
} catch (Exception e) {
e.printStackTrace();
}
}
}
API的构造函数具有以下方法:
public void readXLSB(String filename) throws Exception {
this.a.q(filename);
}
public void readXLSB(InputStream in) throws Exception {
this.a.d(in);
}
public void readXLSB(InputStream in, String pass) throws Exception {
this.a.a(in, pass);
}
# 1 楼答案
为什么不使用jxl呢。工作手册,它更容易和全面。我曾与jxl合作,并高度依赖它。使用like-
Workbook workBook = Workbook.getWorkbook(new File("C:\\abc\\TULDUBINV_EX_10768148_1.xlsb")); Sheet sheet = workBook.getSheet(0);