java数据导入导出
2019-03-28 19:56:27 17 举报AI智能生成
poi思维导图
作者其他创作
大纲/内容
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
Workbook
new XSSFWorkbook(InputStream)
new HSSFWorkbook(InputStream)
Sheet
workbook.getSheet("sheetName")
Row
row.getLastCellNum()
sheet.getRow(index)
Cell
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
Workbook
收藏
0 条评论
下一页
