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