The implementation method is as follows:

(Video tutorial recommendation: java course)

1. First create a new SpringBoot project

2. Import dependencies –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. Create various classes

New entity class

Remember to add get/set methods

public class User {
	
	private String username;
	private String email;
	private String createTime;
	private String LastLoginTime;
	private String roleName;
	private String enable;
	public User() {
		super();
	}
}

Create a new interface Service

import java.util.List;

public interface UserService {
	public List<User> findAllUser();
}

Create a new Impl that implements the Service interface

import java.util.List;

public class UserServiceImpl implements UserService {
	@Override
	public List<User> findAllUser() {
		User user = new User();
		return null;
	}

}

Create a new ExcelUtil tool class

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)建一個(gè)HSSFWorkbook，對(duì)應(yīng)一個(gè)Excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
 
        // 第二步，在workbook中添加一個(gè)sheet,對(duì)應(yīng)Excel文件中的sheet
        HSSFSheet sheet = wb.createSheet(sheetName);
        HSSFSheet sheet1 = wb.createSheet(sheetName1);
        HSSFSheet sheet2 = wb.createSheet(sheetName2);
 
        // 第三步，在sheet中添加表頭第0行,注意老版本poi對(duì)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)建一個(gè)居中格式
 
        //聲明單元格
        HSSFCell cell = null;
 
        //創(chuàng)建標(biāo)題
        for(int i=0;i<title.length;i++){
            //創(chuàng)建一個(gè)單元格
            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)建一個(gè)單元格
            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)容按順序賦給對(duì)應(yīng)的列對(duì)象
                    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)容按順序賦給對(duì)應(yīng)的列對(duì)象
                    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)容按順序賦給對(duì)應(yīng)的列對(duì)象
                    row2.createCell(j).setCellValue(app[j]);
                }
            }
        }
        return wb;
    }
}

Create a new Controller class

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 請(qǐng)求的參數(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)建時(shí)間", "最近登錄時(shí)間","角色","是否可用"};
 
        //excel文件名
        String fileName = System.currentTimeMillis() + ".xls";
 
        //sheet名
        String sheetName = "用戶信息";
        String sheetName1 = "hello";
        String sheetName2 = "xixi";
 
        //沒有數(shù)據(jù)就傳入null吧，Excel工具類有對(duì)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();
        }
    }
}

Set application .properties
server.port=8081
The most important thing to note is: the Application class must be in the outermost package! ! !

4. The last visit to

localhost:8081/MyTest/hello

resulted:

did not write the front end, You can write an html, set an a tag, and click the event.

Related recommendations:Getting started with java

The above is the detailed content of Java implements exporting excel files. For more information, please follow other related articles on the PHP Chinese website!