Java 读取Excel文件时报错。
Java 读取Excel文件时报错。
Unable to read entire header; -1 bytes read; expected 512 bytes
具体代码方法如下:
InputStream file = request.getInputStream();
POIFSFileSystem myFileSystem = new POIFSFileSystem(file);
HSSFWorkbook wb = new HSSFWorkbook(myFileSystem);//创建HSSFWorkbook实例,
HSSFSheet sheet = wb.getSheetAt(0);//第一个工作表
int rowSize=sheet.getLastRowNum();
for(int i=0;i<rowSize;i++)
{
String id = ((jxl.Sheet) sheet).getCell(0, i).getContents().trim();
String name = ((jxl.Sheet) sheet).getCell(1, i).getContents().trim();
String sex = ((jxl.Sheet) sheet).getCell(2, i).getContents().trim();
String org = ((jxl.Sheet) sheet).getCell(3, i).getContents().trim();
String mark = ((jxl.Sheet) sheet).getCell(4, i).getContents().trim();
String slay = ((jxl.Sheet) sheet).getCell(5, i).getContents().trim();
String date = ((jxl.Sheet) sheet).getCell(6, i).getContents().trim();
Object[] args = null;
int[] argTypes = null;
args = new Object[]{
id,
name,
sex,
org,
mark,
slay,
date
};
argTypes = new int[]{Types.BIGINT,Types.VARCHAR,Types.VARCHAR,Types.VARCHAR,Types.VARCHAR,Types.VARCHAR,Types.DATE};
recService.insertExcel(args, argTypes);
}
JSONObject result = new JSONObject();