String fileToBeRead = "文件路径";
//读取文件
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
HSSFSheet sheet = workbook.getSheetAt(0);
int rowNum = sheet.getPhysicalNumberOfRows();
HSSFRow row ;
int cellNum;
for(int i=0;i<rowNum;i++){
row = sheet.getRow(i);
cellNum = row.getPhysicalNumberOfCells();
for(int j=0;i<cellNum;j++){
System.out.println(row.getCell(j).getStringCellValue());
}
}
Excel中我把所有的值的类型都设成了文本类型,可是只能读出第一行的第一列的值
日志信息中有一句
"application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJacksonHttpMessageConverter@1dc11af]