java直接获取上传文件中的内容(无需保存文件的情况下)
public void importTemplate(MultipartFile file) throws Exception {
InputStream inputStream = file.getInputStream();
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
XSSFSheet sheetOne = workbook.getSheetAt(0);
int rowOneIndex = 1;
while (sheetOne.getRow(rowOneIndex) != null) {
XSSFRow row = sheetOne.getRow(rowOneIndex);
try {
String cell=row.getCell(0).getStringCellValue();
String cell2=row.getCell(1).getStringCellValue();
String cell3=row.getCell(1).getStringCellValue();
...............
} catch (Exception e) {
e.printStackTrace();
}
rowOneIndex++;
}
}