java poi 的excel的导出
来源:互联网 发布:阿卡波糖 减肥 知乎 编辑:程序博客网 时间:2024/05/16 14:52
1.在pom.xml添加maven路径
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
2.jsp页面中
js方法
function exportdata()
{
//拼接发送链接
$( "#exportIframe" ).attr( "src","<%=basePath%>" +"messagetemplate/get");
}
html代码
<iframe id="exportIframe" style="border:0px;width:0px;height:0px;" src=""></iframe>
java代码
@RequestMapping( "/get" )
public void do_get(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
{
List<MessageTemplate> records = messageTemplateModel.queryAllRecord();
String[] titles = {"ID", "Code", "Content", "Name", "OutCode"};
Workbook wb;
wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("Business Plan");
Row headerRow = sheet.createRow(0);
for (int i = 0; i < titles.length; i++)
{
Cell cell = headerRow.createCell(i);
cell.setCellValue(titles[i]);
}
sheet.createFreezePane(0, 1);
Row row;
Cell cell;
int rownum = 1;
String[][] data ;
data = new String[records.size()][5];
for( int a = 0; a < records.size(); a++ )
{
MessageTemplate messageTemplateDomain = records.get(a);
data[a][0] = String.valueOf( messageTemplateDomain.getId() ) ;
data[a][1] = messageTemplateDomain.getCode() ;
data[a][2] = messageTemplateDomain.getContent() ;
data[a][3] = messageTemplateDomain.getName() ;
data[a][4] = messageTemplateDomain.getOutCode() ;
}
for (int i = 0; i < data.length; i++, rownum++)
{
row = sheet.createRow(rownum);
if(data[i] == null) continue;
for (int j = 0; j < data[i].length; j++)
{
cell = row.createCell(j);
cell.setCellValue(data[i][j]);
}
}
String docsPath = request.getSession().getServletContext().getRealPath("docs");
String fileName = "export2007中文_" + System.currentTimeMillis() + ".xls";
String filePath = "C:\\Users\\admin\\Desktop\\"+ fileName;
FileOutputStream out = new FileOutputStream( filePath );
wb.write(out);
out.close();
download(filePath, response);
wb.close();
}
private void download(String path, HttpServletResponse response)
{
try
{
// path是指欲下载的文件的路径。
File file = new File(path);
// 取得文件名。
String filename = file.getName();
// 以流的形式下载文件。
InputStream fis = new BufferedInputStream(new FileInputStream(path));
byte[] buffer = new byte[fis.available()];
fis.read(buffer);
fis.close();
// 清空response
response.reset();
// 设置response的Header
response.addHeader("Content-Disposition", "attachment;filename="
+ new String(filename.getBytes(),"ISO-8859-1"));
response.addHeader("Content-Length", "" + file.length());
OutputStream toClient = new BufferedOutputStream(
response.getOutputStream());
response.setContentType("application/vnd.ms-excel;charset=gb2312");
toClient.write(buffer);
toClient.flush();
toClient.close();
}
catch (IOException ex)
{
ex.printStackTrace();
}
}
- java的excel导出[poi]
- java poi 的excel的导出
- POI的excel导出
- java导出excel,简单的excel样式编写,poi导出
- java poi 实现Excel的批量导出
- java poi组件Excel的导入导出
- java poi实现excel的导出
- java中excel的导出 poi
- Java之POI的excel导入导出
- java poi 导出带下拉的excel
- Java 使用POI 实现Excel 的导出
- SpingMVC+poi的Excel导出
- POI导出excel的解决方案
- POI实现Excel的导出
- POI导出excel的整个过程
- POI Excel文件的导出
- Java POI的导出
- Java 使用POI 导出 百万级别的数据量的 Excel
- 35. Search Insert Position
- redis源码分析(一)复习redis命令、持久化方案、主从同步原来、配置
- MyEclipse8.5 Java代码破解
- JAVA 对象引用&对象赋值
- 【Solr in Action】eclipse+java+solrj环境下实现solr客户端数据上传
- java poi 的excel的导出
- 一些测试工具
- 贝塞尔曲线弹性绳模拟伸长和收缩
- SQL ORDER BY(排序)
- 利用小技巧用于跟踪函数的进出过程
- Algorithm之路十九:Remove Nth Node From End of List
- 20171220记录我的程序猿工作。。。
- 按住鼠标左键直接拖动页面-竖向滚动
- python连接mysql 数据库