java数据导入导出
2019-03-28 19:56:27 17 举报AI智能生成
poi思维导图
作者其他创作
大纲/内容
Workbook<br>
HSSFWorkBook<br>
.xls<br>
XSSFWorkBook
.xlsx
Sheet<br>
HSSFSheet<br>
XSSFSheet
workbook.createSheet("sheetName")<br>
Row<br>
HSSFRow
XSSFROW
sheet.createRow(index)
Cell
HSSFCell
XSSFCell
row.createCell(index)
cell.setCellValue(Object)<br>
CellType(Enum)
_NONE
BLANK<br>
STRING
NUMERIC
ERROR
BOOLEAN<br>
FORMULA
Import<br>
Workbook<br>
new XSSFWorkbook(InputStream)<br>
new HSSFWorkbook(InputStream)<br>
Sheet<br>
workbook.getSheet("sheetName")<br>
Row<br>
row.getLastCellNum()<br>
sheet.getRow(index)<br>
Cell<br>
row.getCell(index)
cell.getCellTypeEnum()
CellType
Get Value<br>
cell.getStringCellValue()<br>
cell.getNumericCellValue()
cell.getBooleanValue()
cell.getErrorCellValue()
cell.getCellFormula()
output<br>
filename
header
setContentType<br>
URLConnection
guessContentTypeFromName
Content-Disposition<br>
ContentLength<br>
Workbook<br>
收藏
0 条评论
下一页
