code:
/**
*
@Description
: 导出excel
*
@param
sheetName
*
@param
columnNames
*
@param
columnDatas
*
@param
response
*
@throws
Exception
*
@return
: OutputStream
*
@author
: leijing
*
@date
: 2016年7月13日 下午5:18:37
*/
public
static
OutputStream exportExcel2007(String
sheetName
,List<String>
columnNames
,List<List<String>>
columnDatas
,HttpServletResponse
response
)
throws
Exception{
String
excelName
=
sheetName
+
".xlsx"
;
OutputStream
out
=
response
.getOutputStream();
renderExportFile(
excelName
,
"application/vnd.ms-excel"
,
response
);
Workbook
wb
=
new
SXSSFWorkbook();
CreationHelper
createHelper
=
wb
.getCreationHelper();
Sheet
sheet
=
wb
.createSheet(
sheetName
);
short
index
= 0;
while
(
index
<
columnNames
.size()) {
sheet
.setColumnWidth(
index
, 6500);
index
++;
}
Row
row
;
Cell
cell
;
row
=
sheet
.createRow(0);
for
(
int
j
= 0;
j
<
columnNames
.size();
j
++){
cell
=
row
.createCell(
j
);
cell
.setCellValue(
createHelper
.createRichTextString(
columnNames
.get(
j
)));
}
for
(
int
i
= 1;
i
<=
columnDatas
.size();
i
++){
row
=
sheet
.createRow(
i
);
List<String>
rowData
=
columnDatas
.get(
i
- 1);
for
(
int
j
= 0;
j
<
rowData
.size();
j
++){
cell
=
row
.createCell(
j
);
String
value
=
rowData
.get(
j
);
cell
.setCellValue(
createHelper
.createRichTextString(
value
));
}
}
wb
.write(
out
);
out
.flush();
return
out
;
}
maven:
<
dependency
>
<
groupId
>
org.apache.poi
</
groupId
>
<
artifactId
>
poi
</
artifactId
>
<
version
>
3.13
</
version
>
</
dependency
>
<
dependency
>
<
groupId
>
org.apache.poi
</
groupId
>
<
artifactId
>
poi-excelant
</
artifactId
>
<
version
>
3.13
</
version
>
</
dependency
>
excel还有其他的jar包
<!-- excel 1 -->
<
dependency
>
<
groupId
>
net.sourceforge.jexcelapi
</
groupId
>
<
artifactId
>
jxl
</
artifactId
>
<
version
>
2.6.12
</
version
>
</
dependency
>