溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
這篇文章主要介紹java實(shí)現(xiàn)導(dǎo)出excel文件的方法，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！
實(shí)現(xiàn)方法如下：
1、首先新建一個SpringBoot項(xiàng)目
2、導(dǎo)入依賴–pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.6.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.briup</groupId>
<artifactId>demo3</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<name>demo3</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.6</version>
<exclusions>
<exclusion>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
</exclusion>
<exclusion>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>3、建各種類
新建實(shí)體類
記得添加get/set方法
public class User {
private String username;
private String email;
private String createTime;
private String LastLoginTime;
private String roleName;
private String enable;
public User() {
super();
}
}新建接口Service
import java.util.List;
public interface UserService {
public List<User> findAllUser();
}新建實(shí)現(xiàn)Service接口的Impl
import java.util.List;
public class UserServiceImpl implements UserService {
@Override
public List<User> findAllUser() {
User user = new User();
return null;
}
}新建ExcelUtil工具類
import java.util.List;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelUtil {
public static HSSFWorkbook getHSSFWorkbook(String sheetName,String sheetName1,String sheetName2, String []title, String[] content,String[] app){
// 第一步，創(chuàng)建一個HSSFWorkbook，對應(yīng)一個Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步，在workbook中添加一個sheet,對應(yīng)Excel文件中的sheet
HSSFSheet sheet = wb.createSheet(sheetName);
HSSFSheet sheet1 = wb.createSheet(sheetName1);
HSSFSheet sheet2 = wb.createSheet(sheetName2);
// 第三步，在sheet中添加表頭第0行,注意老版本poi對Excel的行數(shù)列數(shù)有限制
HSSFRow row = sheet.createRow(0);
HSSFRow row1 = sheet1.createRow(0);
HSSFRow row2 = sheet2.createRow(0);
// 第四步，創(chuàng)建單元格樣式，并設(shè)置值表頭 設(shè)置表頭居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 創(chuàng)建一個居中格式
//聲明單元格
HSSFCell cell = null;
//創(chuàng)建標(biāo)題
for(int i=0;i<title.length;i++){
//創(chuàng)建一個單元格
cell = row.createCell(i);
//給單元格賦值
cell.setCellValue(title[i]);
//給單元格設(shè)置樣式
cell.setCellStyle(style);
}
//創(chuàng)建標(biāo)題
for(int i=0;i<title.length;i++){
//創(chuàng)建一個單元格
cell = row1.createCell(i);
//給單元格賦值
cell.setCellValue(title[i]);
//給單元格設(shè)置樣式
cell.setCellStyle(style);
}
//創(chuàng)建內(nèi)容
if (content != null && content.length > 0){
for(int i=0;i<content.length;i++){
row = sheet.createRow(i + 1);
for(int j=0;j<content.length;j++){
//將內(nèi)容按順序賦給對應(yīng)的列對象
row.createCell(j).setCellValue(content[j]);
}
}
}
if (content != null && content.length > 0){
for(int i=0;i<content.length;i++){
row1 = sheet1.createRow(i + 1);
for(int j=0;j<content.length;j++){
//將內(nèi)容按順序賦給對應(yīng)的列對象
row1.createCell(j).setCellValue(content[j]);
}
}
}
if (app != null && app.length > 0){
for(int i=0;i<app.length;i++){
row2 = sheet2.createRow(i + 1);
for(int j=0;j<app.length;j++){
//將內(nèi)容按順序賦給對應(yīng)的列對象
row2.createCell(j).setCellValue(app[j]);
}
}
}
return wb;
}
}新建Controller類
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("/MyTest")
public class HelloController {
@ResponseBody
@RequestMapping("/hello")
public void export(@RequestBody(required = false) User user,String username,HttpServletResponse response) throws Exception {
if (user ==null && !StringUtils.isEmpty(username)){
//GET 請求的參數(shù)
user = new User();
user.setUsername(username);
}
UserService userService = new UserServiceImpl();
//獲取數(shù)據(jù)
List<User> list = userService.findAllUser();
//excel標(biāo)題
String[] title = {"姓名", "郵箱", "創(chuàng)建時間", "最近登錄時間","角色","是否可用"};
//excel文件名
String fileName = System.currentTimeMillis() + ".xls";
//sheet名
String sheetName = "用戶信息";
String sheetName1 = "hello";
String sheetName2 = "xixi";
//沒有數(shù)據(jù)就傳入null吧，Excel工具類有對null判斷
String[] content= {"ali","aaa","ddd","aaa","aaa","aaaa"};
String[] app= {"bbbb","bbbb","bbbb","bbbb","bbbb","bbbb",};
if (list != null && list.size() > 0){
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for (int i = 0; i < list.size(); i++) {
User obj = list.get(i);
content[1] = obj.getUsername();
content[1] = obj.getEmail();
content[2] = obj.getCreateTime() == null ? "" : sdf.format(obj.getCreateTime());
content[3] = obj.getLastLoginTime() == null ? "": sdf.format(obj.getLastLoginTime());
content[4] = obj.getRoleName();
}
}
if (list != null && list.size() > 0){
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for (int i = 0; i < list.size(); i++) {
User obj = list.get(i);
app[1] = obj.getUsername();
app[1] = obj.getEmail();
app[2] = obj.getCreateTime() == null ? "" : sdf.format(obj.getCreateTime());
app[3] = obj.getLastLoginTime() == null ? "": sdf.format(obj.getLastLoginTime());
app[4] = obj.getRoleName();
}
}
//創(chuàng)建HSSFWorkbook
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook(sheetName,sheetName1,sheetName2, title, content,app);
// HSSFWorkbook wb1 = ExcelUtil.getHSSFWorkbook(sheetName1, title, content);
//響應(yīng)到客戶端
try {
fileName = new String(fileName.getBytes(), "UTF-8");
response.setContentType("application/vnd.ms-excel;charset=utf-8");
response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
OutputStream os = response.getOutputStream();
wb.write(os);
os.flush();
os.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}設(shè)置application.properties
server.port=8081
最重要的一定要注意：Application類一定要在最外側(cè)的包中?。?！
4、最后訪問
localhost:8081/MyTest/hello
結(jié)果：
沒有寫前端，可以寫一個html,設(shè)置一個a標(biāo)簽，點(diǎn)擊事件。
以上是java實(shí)現(xiàn)導(dǎo)出excel文件的方法的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對大家有幫助，更多相關(guān)知識，歡迎關(guān)注億速云行業(yè)資訊頻道！
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號
手機(jī)網(wǎng)站二維碼