poi

1.创建工作薄

Workbook wb = new XSSFWorkbook();

2.创建工作表

Sheet sheet = wb.createSheet();

3.创建行

Row row = sheet.createRow(哪一行);

4.创建单元格

Cell cell = row.createCell(哪一列);

cell.setCellValue("yazuo");

cell.setCellStyle(styles);

5.其他常用操作

创建样式

CellStyle style = wb.createCellStyle();

给样式添加数据格式

style.setDataFormat(wb.getCreationHelper().createDataFormat().getFormat("yyyy-MM-dd HH:mm:ss"))

创建字体

Font font = wb.createFont();

合并单元格

sheet.addMergedRegion(new CellRangeAddress(开始行,结束行,开始列,结束列));

设置列宽

sheet.creatColumnWidth(哪一列,列宽);

6.从网站下载生成的excel

response.setContentType("application/vnd.ms-excel;charset=UTF-8");

response.setHeader("Content-Disposition","p_w_upload;filename=conference.xlsx");

response.setHeader("Cache-Control","no-cache");

wb.write(response.getOutputStream());

response.getOutputStream().flush();

7.conference.xlsx 的上传

页面中

<form action="manager/conference/import.crean" method="post" enctype="multipart/form-data">

<input type="file" name="importExcel">

<input type="submit">

</form>

oa-servlet.xml中

<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">

<property name="maxUploadSize">

<value>15248566</value>

</property>

</bean>

在conferenceController 中

将 HttpServletRequest request 转为 MultipartHttpServletRequest

MultipartHttpServletRequest multipartRequest=(MultipartHttpServletRequest) request;

MultipartFile file= MultipartRequest.getFile("importExcel");

InputStream input=file.getInputStream();

Workbook wb=new XSSFWorkbook(input);

Sheet sheet=wb.getSheetAt(0);