新建一个Excel文件,在单元格(A1)内进行“数据有效性”设置,(jxl.jar)在Java程序中读取该文件,代码如下:
public static void main(String[] args) throws BiffException, FileNotFoundException, IOException {
Workbook workbook = Workbook.getWorkbook(new FileInputStream("C:/book1.xls"));
Sheet sheet = workbook.getSheet(0);
System.out.println("Total Rows:" + sheet.getRows());
}
报个异常:(如下)
Warning: Cell at A1 not present - adding a blank
Warning: Some cells exceeded the specified bounds. Resizing sheet dimensions from 0x0 to 1x1
java.lang.NullPointerException
at jxl.read.biff.SheetReader.addCell(SheetReader.java:275)
at jxl.read.biff.SheetReader.handleOutOfBoundsCells(SheetReader.java:1667)
at jxl.read.biff.SheetReader.read(SheetReader.java:1053)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:657)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:251)
at tests.Jxl_Excel.main(Jxl_Excel.java:25) //这行是 Sheet sheet = workbook.getSheet(0);
Exception in thread "main"
请帮忙,在线等!!!谢谢,谢谢!!
public static void main(String[] args) throws BiffException, FileNotFoundException, IOException {
Workbook workbook = Workbook.getWorkbook(new FileInputStream("C:/book1.xls"));
Sheet sheet = workbook.getSheet(0);
System.out.println("Total Rows:" + sheet.getRows());
}
报个异常:(如下)
Warning: Cell at A1 not present - adding a blank
Warning: Some cells exceeded the specified bounds. Resizing sheet dimensions from 0x0 to 1x1
java.lang.NullPointerException
at jxl.read.biff.SheetReader.addCell(SheetReader.java:275)
at jxl.read.biff.SheetReader.handleOutOfBoundsCells(SheetReader.java:1667)
at jxl.read.biff.SheetReader.read(SheetReader.java:1053)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:657)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:251)
at tests.Jxl_Excel.main(Jxl_Excel.java:25) //这行是 Sheet sheet = workbook.getSheet(0);
Exception in thread "main"
请帮忙,在线等!!!谢谢,谢谢!!
我的行InputStream is = new FileInputStream(filePath);
jxl.Workbook wb = Workbook.getWorkbook(is);//转换警告,暂无定论
Sheet rs = wb.getSheet(0);//默认为第一Sheet
int rows = rs.getRows();
int cols = rs.getColumns();