xg

许鹏程

2023-05-26 2476c4f7acc1a3a9087227660e32ef42157a46b6

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
package com.product.org.admin.util;
 
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
 
import javax.servlet.http.HttpServletResponse;
 
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
 
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.exception.BaseException;
 
/**
 * 写入EXCEL数据
* Copyright  LX-BASE
* @Title: LX-BASE-
* @Project: WriteInExcelUtil
* @Date:  2020-10-09 11:00   
* @Author: 杜洪波
* @Description:
 */
public class WriteInExcelUtil {
    
    public static void testWrite(HttpServletResponse response,FieldSetEntity fse) throws IOException, BaseException{
        
        String[] error=getErrorInfo(fse);
        
        
        String fileName = "企业信息.xls";
        response.setContentType("application/octet-stream");
        response.setHeader("name", fileName);
        response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
        response.setHeader("Pragma", "public");
        response.setDateHeader("Expires", 0);
        response.setHeader("Content-disposition","attachment; filename=\"" + URLEncoder.encode(fileName, "UTF-8") + "\"");
        
        //创建工作簿
        Workbook wb = new HSSFWorkbook();
        //创建 Sheet页
        Sheet sheetA = wb.createSheet("error");
 
        //生成行数
        for (int i = 0; i <= error.length; i++) {
            
            //创建行
            Row row = sheetA.createRow(i);
            //第一行数据(EXCEL位置,    错误数据,    错误信息)
            if (i==0) {
                for (int j = 0; j < 3; j++) {
                    Cell cell = row.createCell(j);
                    if (j==0) {
                        cell.setCellValue("position");
                    }else if(j==1) {
                        cell.setCellValue("errorData");
                    }else {
                        cell.setCellValue("errorInfo");
                    }
                }
            }else {    //其他行错误信息
                String []errors=error[i-1].split("<error>");
                
                for (int j = 0; j < 3; j++) {
                    Cell cell = row.createCell(j);
                    if (j==0) {
                        cell.setCellValue(errors[0]);
                    }else if(j==1){
                        cell.setCellValue(errors[1]);
                    } else {
                        cell.setCellValue(errors[2]);
                    }
                }
            }
        }
        
        //路径需要存在
        OutputStream fos = response.getOutputStream();
        wb.write(fos);
        fos.close();
        wb.close();
    }
    
    public static String[] getErrorInfo(FieldSetEntity fse) throws BaseException {
        
        Object [] fields=fse.getFields();
        String [] error=new String[fields.length];
        
        for (int i = 0; i < fields.length; i++) {
            String field=fields[i].toString();
            error[i]=fse.getString(field);
        }
        
        return error;
    }
}