Java+JS的Excel文件导出代码示例

Java是使用的SpringBoot框架

pom.xml文件引入Excel操作依赖包poi-ooxml

		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>4.1.2</version>
		</dependency>

controller中的接口代码，

    @GetMapping(value = "/excelFile")
    public ResponseEntity<byte[]> ExportExcelFile(HttpServletResponse response){
   

        byte[] bytes = null;

        try {
   
            String fileName = "TestExport.xlsx";

            XSSFWorkbook wb = new XSSFWorkbook();
            Sheet sh = wb.createSheet();

            // 标题
            List<String> titles = new ArrayList<>();
            titles.add("测试列1");
            titles.add("测试列2");
            titles.add("测试列3")