写文件
Workbook workbook = new XSSFWorkbook();
Workbook workbook = new XSSFWorkbook(InputStream inputStream);
Workbook workbook = new SXSSFWorkbook();
Sheet sheet = workbook.createSheet(String 表名);
sheet.setColumnWidth(int 列,int 宽);
sheet.addMergedRegion(new CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol);
Row row = sheet.createRow(int 行);
Cell cell = row.createCell(int 列);
cell.setCellValue(String 内容);
CellStyle cellStyle = workbook.createCellStyle();
Font font = workbook.createFont();
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
CellStyle cellStyle = cell.getCellStyle();
cell.setCellStyle(cellStyle);
workbook.write(OutputStream outputStream);
workbook.close();
读文件
Workbook workbook = new XSSFWorkbook(InputStream inputStream);
Sheet sheet = workbook.getSheetAt(String 表名);
sheet.getPhysicalNumberOfRows();
Row row = sheet.getRow(int 行);
row.getPhysicalNumberOfCells();
Cell cell = row.getCell(int 列);
cell.getStringCellValue();
cell.getNumericCellValue();
workbook.close();