Python 官方文档:入门教程 => 点击学习
1.首先我们先导入poi和文件上传的依赖 <!--POI--> <dependency> <groupId>org.a
1.首先我们先导入poi和文件上传的依赖
<!--POI-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.14-beta1</version>
</dependency>
<!--文件上传依赖-->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<!-- 配置文件上传解析器 -->
<!-- id 的值是固定的-->
<bean id="multipartResolver"
class="org.springframework.WEB.multipart.commons.CommonsMultipartResolver">
<!-- 设置上传文件的最大尺寸为 5MB -->
<property name="maxUploadSize">
<value>5242880</value>
</property>
</bean>
3.创建index.html
<!-- excel文件导出 -->
<p><a href="User/exportExcel.do" rel="external nofollow" >导出</a>
<!-- excel文件导入 -->
<fORM action="User/importExcel.do" method="post" enctype="multipart/form-data">
<input type="file" name="userExcel" />
<input type="submit" value="导入">
</form>
4.创建实体类
public class User {
private Integer id;
private String username;
private String passWord;
}
5.Controller层
@RequestMapping("/exportExcel")
@ResponseBody
public void exportExcel(httpservletRequest request, HttpServletResponse response){
try {
//获取数据源
List<User> userList = service.queryUserAll();
//导出excel
response.setHeader("Content-Disposition","attachment;filename="+new String("用户信息.xls".getBytes(),"ISO-8859-1"));
response.setContentType("application/x-excel;charset=UTF-8");
OutputStream outputStream = response.getOutputStream();
//导出
service.exportExcel(userList,outputStream);
outputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
@RequestMapping("/importExcel")
@ResponseBody
public String importExcel(MultipartFile userExcel, HttpServletRequest request, HttpSession session) throws IOException, InvalidFormatException {
if(userExcel == null){
session.setAttribute("excelName", "未上传文件,上传失败!");
return null;
}
String userExcelFileName = userExcel.getOriginalFilename();
if(!userExcelFileName.matches("^.+\\.(?i)((xls)|(xlsx))$")){
session.setAttribute("excelName", "文件格式不正确!请使用.xls或.xlsx后缀的文档,导入失败!");
return null;
}
//导入
service.importExcel(userExcel);
session.setAttribute("excelName", "导入成功!");
return "redirect:queryUserAll.do";
}
6.运行测试
1.点击导出将数据库的内容以后缀为 .xls的文件下载下来
2. 选择Excel文件点击导入会将文件里的内容导入到数据库中
到此这篇关于SSM框架使用poi导入导出Excel的文章就介绍到这了,更多相关SSM框架导入导出Excel内容请搜索编程网以前的文章或继续浏览下面的相关文章希望大家以后多多支持编程网!
--结束END--
本文标题: SSM框架使用poi导入导出Excel的详细方法
本文链接: https://www.lsjlt.com/news/122524.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0