import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.springframework.web.multipart.MultipartFile;
import java.io.InputStream;
/**
*
* @param file excel文件
* @param sheetAt sheet页索引值
* @param rowIndex 行索引值
* @param index 列索引值 英文字母
* @return
*/
private String getExcelTitle(MultipartFile file, Integer sheetAt, Integer rowIndex, String index) {
InputStream inputStream = null;
try {
log.info("读取表头::");
inputStream = file.getInputStream();
XSSFWorkbook wb = new XSSFWorkbook(inputStream);
XSSFWorkbook test = new XSSFWorkbook();
// XSSFSheet sheet = wb.getSheetAt(0);
// XSSFRow row;
XSSFCell cell;
cell = wb.getSheetAt(sheetAt).getRow(rowIndex).getCell(CellReference.convertColStringToIndex(index));
log.info("读取表头::结果:{“" + cell.getStringCellValue() + "”}");
return cell.getStringCellValue();
} catch (IOException e) {
return "";
} catch (Exception e) {
return "";
}
}
excel.getSheetAt(0).getRow(0).getCell(CellReference.convertColStringToIndex("A")) 指定A单元格第一行数据 索引从0开始
前端上传excel文件,通过poi读取单元格内容
POI版本3.17