java导出excel工具类

本文介绍了一个用于将Java应用程序中的数据导出为Excel文件的实用工具类。该工具类能够生成包含特定商品信息的Excel表格,并支持自定义表头及列宽等功能。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

ExcelUtil.java

 

package com.mingwen.common.utils;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.mingwen.product.entity.taobao.ShopGoodsBean;

public class ExcelUtil {

    public static void createExcel(HttpServletRequest request, HttpServletResponse response, List<ShopGoodsBean> list,
            String fileName, List<String> title) {
        try {
            // 创建Excel的工作书册 Workbook,对应到一个excel文档
            HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFCellStyle style = workbook.createCellStyle();
            // 生成一个字体
            HSSFFont font = workbook.createFont();
            // 字体增粗
            // font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            font.setFontHeightInPoints((short) 11);
            style.setFont(font);
            // 创建Excel的工作sheet,对应到一个excel文档的tab
            HSSFSheet sheet = workbook.createSheet("sheet1");
            // 创建Excel的sheet的一行 (表头)
            HSSFRow row = sheet.createRow(0);
            // 表头内容填充
            for (int i = 0; i < title.size(); i++) {
                // 设置excel每列宽度
                sheet.setColumnWidth(i, 5000);
                HSSFCell cell = row.createCell(i);
                cell.setCellValue(title.get(i));
                cell.setCellStyle(style);
            }
            // 创建内容行
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setWrapText(true);// 自动换行
            cellStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00"));
            for (int j = 0; j < list.size(); j++) {
                try {
                    HSSFRow contentRow = sheet.createRow(j + 1);
                    for (int k = 0; k < title.size(); k++) {
                        HSSFCell cell = contentRow.createCell(k);
                        switch (k) {
                        case 0:

                            cell.setCellValue(list.get(j).getShopName());
                            break;
                        case 1:
                            cell.setCellValue(list.get(j).getNumberId());
                            break;
                        case 2:
                            cell.setCellValue(list.get(j).getTitle());

                            break;
                        case 3:

                            cell.setCellValue(list.get(j).getIsbn());

                            break;
                        case 4:

                            cell.setCellValue(list.get(j).getAuthor());

                            break;
                        case 5:
                            cell.setCellValue(list.get(j).getPublishDate());
                            break;
                        case 6:

                            cell.setCellValue(list.get(j).getDataFrom());

                            break;
                        case 7:

                            cell.setCellValue(list.get(j).getGoodState());

                            break;
                        case 8:

                            cell.setCellValue(list.get(j).getOuterId());

                            break;
                        case 9:

                            cell.setCellValue(list.get(j).getSkuId());

                            break;
                        case 10:

                            cell.setCellValue(list.get(j).getTemplate());

                            break;
                        case 11:

                            cell.setCellValue(list.get(j).getTemplateName());

                            break;
                        case 12:

                            cell.setCellValue(list.get(j).getStock());

                            break;
                        case 13:

                            cell.setCellValue(list.get(j).getCid());

                            break;
                        case 14:

                            cell.setCellValue(list.get(j).getPress());

                            break;
                        case 15:

                            cell.setCellValue(list.get(j).getSellingPrice());

                            break;
                        default:
                            break;
                        }
                        cell.setCellStyle(cellStyle);
                    }
                } catch (Exception e) {
                    continue;
                }
            }

            ByteArrayOutputStream os = new ByteArrayOutputStream();
            try {
                workbook.write(os);
            } catch (IOException e) {
                e.printStackTrace();
            }
            byte[] content = os.toByteArray();
            InputStream is = new ByteArrayInputStream(content);
            // 设置response参数,可以打开下载页面
            response.reset();
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            response.setHeader("Content-Disposition",
                    "attachment;filename=" + new String((fileName + ".xls").getBytes("gb2312"), "iso-8859-1"));
            ServletOutputStream out = response.getOutputStream();
            BufferedInputStream bis = null;
            BufferedOutputStream bos = null;
            try {
                bis = new BufferedInputStream(is);
                bos = new BufferedOutputStream(out);
                byte[] buff = new byte[2048];
                int bytesRead;
                // Simple read/write loop.
                while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
                    bos.write(buff, 0, bytesRead);
                }
            } catch (final IOException e) {
                throw e;
            } finally {
                if (bis != null)
                    bis.close();
                if (bos != null)
                    bos.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值