Untitled

 avatar
unknown
java
a year ago
3.0 kB
6
Indexable
public static byte[] generatePaymentReportDownloadExcel(List<PaymentReportDto> paymentReportDtoList) throws IOException {
        try(Workbook workbook = new XSSFWorkbook()){
            Sheet sheet = workbook.createSheet();
            Row headerRow = sheet.createRow(0);
            String[] headers = {"Agent Ref Id","Retailer Phone Number","Amount","Created Ts","Order Item Ids","Order Type","Brand Name","Payment Id","Payment Mode","Payment Status","Payment Type","Quotes Id","Request Date","Response Date","Provider Payment Id","Transaction Id","Transaction Type","Updated Ts","Parent Order Id","Provider Reference Id"};
            for(int i=0;i<headers.length;i++){
                headerRow.createCell(i).setCellValue(headers[i]);
            }
            int rowIndex = 1;

            for(PaymentReportDto paymentReportDto:paymentReportDtoList){
                Row dataRow = sheet.createRow(rowIndex++);
                dataRow.createCell(0).setCellValue(paymentReportDto.getAgentRefId());
                dataRow.createCell(1).setCellValue(paymentReportDto.getRetailerPhoneNumber());
                dataRow.createCell(2).setCellValue(paymentReportDto.getAmount());
                dataRow.createCell(3).setCellValue(paymentReportDto.getCreatedTs());
                dataRow.createCell(4).setCellValue(paymentReportDto.getOrderItemIds());
                dataRow.createCell(5).setCellValue(paymentReportDto.getOrderType());
                dataRow.createCell(6).setCellValue(paymentReportDto.getBrandName());
                dataRow.createCell(7).setCellValue(paymentReportDto.getPaymentId());
                dataRow.createCell(8).setCellValue(paymentReportDto.getPaymentMode());
                dataRow.createCell(9).setCellValue(paymentReportDto.getPaymentStatus());
                dataRow.createCell(10).setCellValue(paymentReportDto.getPaymentType());
                dataRow.createCell(11).setCellValue(paymentReportDto.getQuotesIds());
                dataRow.createCell(12).setCellValue(paymentReportDto.getRequestDate());
                dataRow.createCell(13).setCellValue(paymentReportDto.getResponseDate());
                dataRow.createCell(14).setCellValue(paymentReportDto.getProviderPaymentId());
                dataRow.createCell(15).setCellValue(paymentReportDto.getTransactionId());
                dataRow.createCell(16).setCellValue(paymentReportDto.getPaymentType());
                dataRow.createCell(17).setCellValue(paymentReportDto.getUpdatedTs());
                dataRow.createCell(18).setCellValue(paymentReportDto.getParentOrderId());
                dataRow.createCell(19).setCellValue(paymentReportDto.getProviderReferenceId());
            }
            ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
            workbook.write(outputStream);
            return  outputStream.toByteArray();
        } catch (IOException e){
            e.printStackTrace();
            throw new RuntimeException("Failed to generate Excel file.");
        }
    }
Editor is loading...
Leave a Comment