Java+Vue导出Excel

已于 2023-08-14 10:20:26 修改
阅读量485 收藏
点赞数
分类专栏： Vue Java 文章标签： java vue.js excel
于 2023-06-06 10:50:35 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44405420/article/details/131063022
版权
Java 同时被 2 个专栏收录
16 篇文章 0 订阅
订阅专栏
Vue
10 篇文章 0 订阅
订阅专栏

Vue

<a id="download" />

async downloadFktz() {
      const res = await riskStandingBookApi.exportFktz(this.queryForm)
      if (res.code === 200) {
        document.getElementById('download').setAttribute('href', 'data:xlsx;base64,' + res.data)
        document.getElementById('download').setAttribute('download', 'a.xlsx')
        document.getElementById('download').click()
        this.$message.success(res.msg)
      } else {
        this.$message.error(res.msg)
      }
    }

Java


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


package com.xxx.xxx.utils;

import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

public class ExcelUtil {
    public static final String OFFICE_EXCEL_2003_POSTFIX = "xls";
    public static final String OFFICE_EXCEL_2010_POSTFIX = "xlsx";
    public static final String EMPTY = "";
    public static final String POINT = ".";
    public static SimpleDateFormat sdf =   new SimpleDateFormat("yyyy/MM/dd");

    public static String getValue(Cell cell){
        if(cell == null){
            return "";
        }
        String cellValue = "";
        int cellType=cell.getCellType();
        switch (cellType) {
            case Cell.CELL_TYPE_NUMERIC: // 数字
                short format = cell.getCellStyle().getDataFormat();
                if (DateUtil.isCellDateFormatted(cell)) {
                    SimpleDateFormat sdf = null;
                    //System.out.println("cell.getCellStyle().getDataFormat()="+cell.getCellStyle().getDataFormat());
                    if (format == 20 || format == 32) {
                        sdf = new SimpleDateFormat("HH:mm");
                    } else if (format == 14 || format == 31 || format == 57 || format == 58) {
                        // 处理自定义日期格式：m月d日(通过判断单元格的格式id解决，id的值是58)
                        sdf = new SimpleDateFormat("yyyy-MM-dd");
                        double value = cell.getNumericCellValue();
                        Date date = DateUtil
                                .getJavaDate(value);
                        cellValue = sdf.format(date);
                    }else {// 日期
                        sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                    }
                    try {
                        cellValue = sdf.format(cell.getDateCellValue());// 日期
                    } catch (Exception e) {
                        try {
                            throw new Exception("exception on get date data !".concat(e.toString()));
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        }
                    }finally{
                        sdf = null;
                    }
                }  else {
                    BigDecimal bd = new BigDecimal(cell.getNumericCellValue()).setScale(8,BigDecimal.ROUND_HALF_UP);
                    cellValue = bd.toPlainString();// 数值 这种用BigDecimal包装再获取plainString，可以防止获取到科学计数值
                }
                break;
            case Cell.CELL_TYPE_STRING: // 字符串
                cellValue = cell.getStringCellValue();
                break;
            case Cell.CELL_TYPE_BOOLEAN: // Boolean
                cellValue = cell.getBooleanCellValue()+"";;
                break;
            case Cell.CELL_TYPE_FORMULA: // 公式
                cellValue = cell.getCellFormula();
                break;
            case Cell.CELL_TYPE_BLANK: // 空值
                cellValue = "";
                break;
            case Cell.CELL_TYPE_ERROR: // 故障
                cellValue = "ERROR VALUE";
                break;
            default:
                cellValue = "UNKNOW VALUE";
                break;
        }
        return cellValue;
    }

    public static Map<String,Integer> getCollIndexNew(Row row){
        Map<String,Integer> map = new HashMap<>();
        for(int i = 0;i<row.getLastCellNum();i++){
            map.put(getValue(row.getCell(i)),i);
        }
        return map;
    }


    public static XSSFCellStyle getStyle(XSSFWorkbook workbook, short boldWeight, short fontHeight, short fontColor, short alignment,
                                         short verticalAlignment, short borderBottom, short borderLeft, short borderRight, short borderTop, String dataFormat,
                                         boolean warpText, short fillPattern, XSSFColor xssfColor){
        try {
            Font font = workbook.createFont();
            font.setFontHeightInPoints(fontHeight);
            font.setFontName("黑体");
            font.setColor(fontColor);

            XSSFCellStyle style = workbook.createCellStyle();
            style.setAlignment(alignment);
            style.setVerticalAlignment(verticalAlignment);
            style.setFont(font); // 调用字体样式对象
            style.setWrapText(false);
            if(borderBottom != 0) {
                style.setBorderBottom(borderBottom);
                style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderLeft != 0) {
                style.setBorderLeft(borderLeft);
                style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderRight != 0) {
                style.setBorderRight(borderRight);
                style.setRightBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderTop != 0) {
                style.setBorderTop(borderTop);
                style.setTopBorderColor(IndexedColors.BLACK.getIndex());
            }
            style.setWrapText(warpText);
            if(fillPattern != 0) {
                style.setFillPattern(fillPattern);
            }
            if(xssfColor != null) {
                style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
                style.setFillForegroundColor(xssfColor);
            }
            if(StringUtils.isNotBlank(dataFormat)) {
                DataFormat df = workbook.createDataFormat();
                style.setDataFormat(df.getFormat(dataFormat));
            }
            return style;
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
    }


    public static XSSFCellStyle getStyle(XSSFWorkbook workbook,short boldWeight,short fontHeight,short fontColor,short alignment,
                                         short verticalAlignment,short borderBottom,short borderLeft,short borderRight,short borderTop,String dataFormat,
                                         boolean warpText,short fillPattern,short fillForegroundColor){
        try {
            Font font = workbook.createFont();
            font.setFontHeightInPoints(fontHeight);
            font.setFontName("黑体");
            font.setColor(fontColor);
            XSSFCellStyle style = workbook.createCellStyle();
            style.setAlignment(alignment);
            style.setVerticalAlignment(verticalAlignment);
            style.setFont(font); // 调用字体样式对象
            style.setWrapText(false);
            if(borderBottom != 0) {
                style.setBorderBottom(borderBottom);
                style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderLeft != 0) {
                style.setBorderLeft(borderLeft);
                style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderRight != 0) {
                style.setBorderRight(borderRight);
                style.setRightBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderTop != 0) {
                style.setBorderTop(borderTop);
                style.setTopBorderColor(IndexedColors.BLACK.getIndex());
            }
            style.setWrapText(warpText);
            if(fillPattern != 0) {
                style.setFillPattern(fillPattern);
            }
            if(fillForegroundColor != 0) {
                style.setFillForegroundColor(fillForegroundColor);
            }
            if(StringUtils.isNotBlank(dataFormat)) {
                DataFormat df = workbook.createDataFormat();
                style.setDataFormat(df.getFormat(dataFormat));
            }
            return style;
        }catch (Exception e){
            return null;
        }
    }

    public static CellStyle getStyle(Workbook workbook,short boldWeight,short fontHeight,short fontColor,short alignment,
                                     short verticalAlignment,short borderBottom,short borderLeft,short borderRight,short borderTop,String dataFormat,
                                     boolean warpText,short fillPattern,short fillForegroundColor){
        try {
            Font font = workbook.createFont();
            font.setFontHeightInPoints(fontHeight);
            font.setFontName("黑体");
            font.setColor(fontColor);
            font.setBoldweight(boldWeight);//0.8
            CellStyle style = workbook.createCellStyle();
            style.setAlignment(alignment);
            style.setVerticalAlignment(verticalAlignment);
            style.setFont(font); // 调用字体样式对象
            style.setWrapText(false);
            if(borderBottom != 0) {
                style.setBorderBottom(borderBottom);
                style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderLeft != 0) {
                style.setBorderLeft(borderLeft);
                style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderRight != 0) {
                style.setBorderRight(borderRight);
                style.setRightBorderColor(IndexedColors.BLACK.getIndex());
            }
            if(borderTop != 0) {
                style.setBorderTop(borderTop);
                style.setTopBorderColor(IndexedColors.BLACK.getIndex());
            }
            style.setWrapText(warpText);
            if(fillPattern != 0) {
                style.setFillPattern(fillPattern);
            }
            if(fillForegroundColor != 0) {
                style.setFillForegroundColor(fillForegroundColor);
            }
            if(StringUtils.isNotBlank(dataFormat)) {
                DataFormat df = workbook.createDataFormat();
                style.setDataFormat(df.getFormat(dataFormat));
            }
            return style;
        }catch (Exception e){
            return null;
        }
    }


    /**
     * 获得path的后缀名
     * @param path
     * @return
     */
    public static String getPostfix(String path){
        if(path==null || EMPTY.equals(path.trim())){
            return EMPTY;
        }
        if(path.contains(POINT)){
            return path.substring(path.lastIndexOf(POINT)+1,path.length());
        }
        return EMPTY;
    }
    /**
     * 单元格格式
     * @param
     * @return
     */
    @SuppressWarnings({ "static-access", "deprecation" })
//    public static String getHValue(HSSFCell hssfCell){
//        if (hssfCell.getCellType() == hssfCell.CELL_TYPE_BOOLEAN) {
//            return String.valueOf(hssfCell.getBooleanCellValue());
//        } else if (hssfCell.getCellType() == hssfCell.CELL_TYPE_NUMERIC) {
//            String cellValue = "";
//            if(HSSFDateUtil.isCellDateFormatted(hssfCell)){
//                Date date = HSSFDateUtil.getJavaDate(hssfCell.getNumericCellValue());
//                cellValue = sdf.format(date);
//            }else{
//                DecimalFormat df = new DecimalFormat("#.########");
//                cellValue = df.format(hssfCell.getNumericCellValue());
//                String strArr = cellValue.substring(cellValue.lastIndexOf(POINT)+1,cellValue.length());
//                if(strArr.equals("00")){
//                    cellValue = cellValue.substring(0, cellValue.lastIndexOf(POINT));
//                }
//            }
//            return cellValue;
//        } else {
//            hssfCell.setCellType(CellType.STRING);
//            return String.valueOf(hssfCell.getStringCellValue());
//        }
//    }
    /**
     * 单元格格式
     * @param xssfCell
     * @return
     */
//    public static String getXValue(Cell xssfCell){
//        if (xssfCell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
//            return String.valueOf(xssfCell.getBooleanCellValue());
//        } else if (xssfCell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
//            String cellValue = "";
//            if(XSSFDateUtil.isCellDateFormatted(xssfCell)){
//                Date date = XSSFDateUtil.getJavaDate(xssfCell.getNumericCellValue());
//                cellValue = sdf.format(date);
//            }else{
//                DecimalFormat df = new DecimalFormat("#.########");
//                cellValue = df.format(xssfCell.getNumericCellValue());
//                String strArr = cellValue.substring(cellValue.lastIndexOf(POINT)+1,cellValue.length());
//                if(strArr.equals("00")){
//                    cellValue = cellValue.substring(0, cellValue.lastIndexOf(POINT));
//                }
//            }
//            return cellValue;
//        } else {
//            xssfCell.setCellType(CellType.STRING);
//            return String.valueOf(xssfCell.getStringCellValue());
//        }
//    }
    /**
     * 自定义xssf日期工具类
     *
     */
    static class XSSFDateUtil extends DateUtil {
        protected static int absoluteDay(Calendar cal, boolean use1904windowing) {
            return DateUtil.absoluteDay(cal, use1904windowing);
        }
    }
}



	@RequestMapping(value = "/exportFktz",method = RequestMethod.POST)
	@ResponseBody
	public RestResponse<String> exportFktz(@RequestBody TrsRiskStandingBookSearchDto model){
		try {
			String result = trsRiskStandingBookService.exportFktz(model);
			return new RestResponse<String>(RestResponse.SUCCESS_CODE,"导出成功", result);
		} catch (Exception e) {
			e.printStackTrace();
			return new RestResponse<String>(RestResponse.FAILURE_CODE,"导出失败" + e.getMessage(),null);
		}
	}

    @Override
    public String exportFktz(TrsRiskStandingBookSearchDto dto) {
        //查询用户拥有权限的项目
        long userId = StpUtil.getLoginIdAsLong();
        List<TrsBasicsProjectModel> basicsProjectModelList = trsBasicsProjectMapper.queryUserProject(userId);
        LambdaQueryWrapper<TrsRiskStandingBookModel> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.in(CollUtil.isNotEmpty(dto.getProjectIds()), TrsRiskStandingBookModel::getProjectId, dto.getProjectIds());
        queryWrapper.in(!CollectionUtils.isEmpty(basicsProjectModelList), TrsRiskStandingBookModel::getProjectId
                , basicsProjectModelList.stream().map(BaseModel::getId).collect(Collectors.toList()));
        queryWrapper.in(CollUtil.isNotEmpty(dto.getStrategyIds()), TrsRiskStandingBookModel::getStrategyId, dto.getStrategyIds());
        queryWrapper.ge(StringUtils.isNotBlank(dto.getBeginDate()), TrsRiskStandingBookModel::getDate, dto.getBeginDate());
        queryWrapper.le(StringUtils.isNotBlank(dto.getEndDate()), TrsRiskStandingBookModel::getDate, dto.getEndDate());
        List<TrsRiskStandingBookModel> modelList = trsRiskStandingBookMapper.selectList(queryWrapper);
        modelList = modelList.stream().sorted(Comparator.comparing(TrsRiskStandingBookModel::getDate).reversed()).collect(Collectors.toList());
        for (TrsRiskStandingBookModel bookModel : modelList) {
            translateFktz(bookModel);
        }
        if (!CollectionUtils.isEmpty(modelList)) {
            XSSFWorkbook workbook = new XSSFWorkbook();
            Sheet sheet = workbook.createSheet("a");
            sheet.setDefaultColumnWidth(15);
            int rowNum = 0;
            Row row0 = sheet.createRow(rowNum++);
            Cell cell0_0 = row0.createCell(0);
            cell0_0.setCellValue("1");
            cell0_0.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_1 = row0.createCell(1);
            cell0_1.setCellValue("2");
            cell0_1.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_2 = row0.createCell(2);
            cell0_2.setCellValue("3");
            cell0_2.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_3 = row0.createCell(3);
            cell0_3.setCellValue("4");
            cell0_3.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_4 = row0.createCell(4);
            cell0_4.setCellValue("5");
            cell0_4.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));

            Cell cell0_5 = row0.createCell(5);
            cell0_5.setCellValue("6");
            cell0_5.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));

            Cell cell0_6 = row0.createCell(6);
            cell0_6.setCellValue("7");
            cell0_6.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));


            Cell cell0_7 = row0.createCell(7);
            cell0_7.setCellValue("8");
            cell0_7.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_8 = row0.createCell(8);
            cell0_8.setCellValue("9");
            cell0_8.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));
            Cell cell0_9 = row0.createCell(9);
            cell0_9.setCellValue("10");
            cell0_9.setCellStyle(ExcelUtil.getStyle(workbook, Font.BOLDWEIGHT_BOLD, (short) 10, HSSFColor.BLACK.index, HSSFCellStyle.ALIGN_CENTER, HSSFCellStyle.VERTICAL_CENTER, (short) 0, (short) 0, (short) 0, (short) 0, "", false, (short) 0, null));

            for (TrsRiskStandingBookModel bookModel : modelList) {
                Row row = sheet.createRow(rowNum++);
                row.createCell(0).setCellValue(bookModel.getDate());
                row.createCell(1).setCellValue(bookModel.getProjectName());
                row.createCell(2).setCellValue(bookModel.getStrategyType());
                row.createCell(3).setCellValue(bookModel.getStrategyName());
                row.createCell(4).setCellValue(null == bookModel.getPosition()
                        ? null : bookModel.getPosition().setScale(2, BigDecimal.ROUND_HALF_UP).toString());

                if (StringUtils.isNotBlank(dto.getMoneyUnit()) && "万元".equals(dto.getMoneyUnit())) {
                    row.createCell(5).setCellValue(null == bookModel.getClyk()
                            ? null : bookModel.getClyk().divide(new BigDecimal("10000"),2,BigDecimal.ROUND_HALF_UP).toString());
                    row.createCell(6).setCellValue(null == bookModel.getClykdrzl()
                            ? null : bookModel.getClykdrzl().divide(new BigDecimal("10000"),2, BigDecimal.ROUND_HALF_UP).toString());
                }else {
                    row.createCell(5).setCellValue(null == bookModel.getClyk()
                            ? null : bookModel.getClyk().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
                    row.createCell(6).setCellValue(null == bookModel.getClykdrzl()
                            ? null : bookModel.getClykdrzl().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
                }

                row.createCell(7).setCellValue(null == bookModel.getExposure()
                        ? null : bookModel.getExposure().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
                row.createCell(8).setCellValue(null == bookModel.getHedgingRate()
                        ? null : bookModel.getHedgingRate().setScale(2, BigDecimal.ROUND_HALF_UP).toString());
                row.createCell(9).setCellValue(bookModel.getRemark());
            }
            String fileTempPath = System.getProperty("user.dir") + File.separator + "tempExcel";
            Date now = new Date();
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            try {
                File f = new File(fileTempPath);
                if (!f.exists()) {//如果文件夹不存在
                    f.mkdir();//创建文件夹
                }
                FileOutputStream fos = new FileOutputStream(fileTempPath + File.separator + sdf.format(now) + "a.xlsx");
                workbook.write(fos);
                fos.flush();
                fos.close();
                File file = new File(fileTempPath + File.separator + sdf.format(now) + "a.xlsx");
                FileInputStream inputFile = new FileInputStream(file);
                byte[] buffer = new byte[(int) file.length()];
                inputFile.read(buffer);
                inputFile.close();
                return new BASE64Encoder().encode(buffer);
            } catch (Exception e) {
                throw new RuntimeException("生成Excel异常", e);
            }
        }
        return null;
    }
沐某人
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
excel的导出和导入(前端vue后端java中间件axios)
qq_54536434的博客
06-05 2153
导入使用Xlsx实现。导出使用easyExcel实现。
VUE+java实现：Excel导出功能前后端代码
zhu_tian_huan的博客
05-19 1011
VUE+java实现Excel导出
Excel Java POI导入导出示例
09-14
Excel Java导入导出，示例代码，修改下就可以作为自己的工具类。使用的是POI Jar包，压缩包里包含有用到的 POI Jar包。
java_poi实现excel导入导出
09-01
java_poi实现excel导入导出功能，有详细的注解
Java+VUE 导出Excel
hellotutu的博客
04-26 2470
Java导出Excel（复制代码，粘贴即用）
Vue element ui结合java后台导出Excel(二进制文件流)
杨振洲的博客
07-10 2321
Vue结合后台详解导入导出Excel问题 今天讲讲 前台Vue配合后台(java)导出Excel 后台返回的数据是 二进制文件流 如何将此变为 弹框下载 当时开发呢,我们后台是java 有控件 可以直接将数据导出并生成Excel文件,但是前后台传输是不可能直接传输文件的,是以二进制文件流进行传输的,此时呢就会遇到一个问题,因为是后台,必然会涉及到权限,权限就涉及到token,token传输就会出现限制问题,所以我会列出三种方法 我的是Vue项目~~ 1.不需要token的方法 <template&g
Vue+JAVA POI 实现Excel导入导出规则怪谈
weixin_41902457的博客
03-01 2395
Vue+JAVA POI 实现Excel导入导出
Java用POI导出Excel表格中的数据
weixin_45581692的博客
08-11 1247
poi操作Excel 主要通过HSSF,XSSF两种方式。 HSSF只能解析.xls格式的excel文件，XSSF支持.xls与.xlsx两种格式。 功能： 传递一个Excel文件，拿到里面所有的数据，返回我猜是这个工具把第一行当成 表头了，而我传入的文件没有表头，里面都是数据，而我的需求是表里面是数字导出来就要是数字。这种方式有个不好的地方：第一行数据导出来都是字符串类型的。所以这种方式不满足我现在的需求，如果有表头就可以这样写。Excel中的数据是什么类型，就返回什么类型的数据。说下我之前导出的方式。.
【保姆级】Java后端查询数据库结果导出xlsx文件+打印xlsx表格
小样yx的博客
03-01 3344
Java实现生成xlsx文件，并调用打印机打印
Vue中如何进行数据导出与Excel导出？
程序猿徐师兄的博客
06-12 7834
本文介绍了Vue中两种常用的数据导出和Excel导出方式。第一种方式是使用第三方库xlsx，它是一个纯JavaScript的库，可以在浏览器中直接使用，不需要安装任何插件。第二种方式是使用后端API，借助后端API生成Excel文件，并将文件以二进制形式返回给前端。两种方式各有优缺点，具体使用时需要根据具体情况选择。同时，在实际使用过程中，我们还需要注意一些细节问题，比如Excel文件的格式、数据的安全性等。最后，如果您需要在Vue中进行数据导出和Excel导出，希望本文能对您有所帮助。
基于Spring Boot+Vue.js的后台管理系统源码.zip
05-01
基于Spring Boot+Vue.js的后台管理系统,权限管理，字典，配置，定时任务，短信，邮件，根据excel模板导出，cms内容管理，手机端h5。 基于Spring Boot+Vue.js的后台管理系统,权限管理，字典，配置，定时任务，短信，...
Spring Boot中实现列表数据导出为Excel文件
最新发布
02-22
本文将详细介绍在Spring Boot框架中如何将列表数据导出为Excel文件。我们将通过Apache POI库来实现这一功能，并解释其背后的原理、提供完整的流程和步骤，以及带有详细注释的代码示例。最终，读者将能够轻松地将自己...
Java+vue前后端分离智慧云智能教育平台源码
06-14
试题管理：支持excel模板导入试题、支持使用富文本编辑试题及插入数学公式，同时还支持上传试题教学视频 试卷管理：支持将试卷导出成word文档、html页面进行打印、支持富文本图片导出到word 试卷批改功能：支持教师...
java导出Excel文件.pdf
10-30
java导出Excel文件代码：从导入依赖、yml文件配置、前台vue、js代码、controller、service实现都有了
Java使用POI结合VUE实现导出数据到Excel表格
在下令狐的博客
07-17 1567
Java结合VUE实现导出数据到Excel表格,同时解决了单元格合并，导致单元格样式不生效问题 页面预览： 1.前台展示页面 2.导出的Excel 3.Java后台中传入的参数 代码实现 1.VUE代码： <template> <el-table :data="tableData" border style="width: 100%"> <el-table-column fixed prop="date.
vue+Java 实现前后端Excel导出
Stubborn_angle的博客
01-07 2614
vue+Java 实现前后端Excel导出
Java和Vue导出Excel表格
xmh594603296的博客
11-19 7954
本文主要是记录一下最近写前后台导出excel花费的一些心得。 前台: 通过一个同步的请求,同步等待数据,拿到数据以后,构建blob( new Blob)下载excel 后台:利用java pio读取Excel,配合java反射,写了一个万能的excel导出模板,只要设置表头一个数组,和你的数据模型(可能会有潜在bug,但是目前使用正常) 主要是为了大家以后避免一些坑,拿来即用     ...
vue+Java实现前端下载文件（excel导出）
热门推荐
qq_34940644的博客
05-28 1万+
1.后端 后端方法的放回值类型和接收参数 后端以流的形式返回到前端 // 设置生成的Excel的文件名，并以中文进行编码 String codedFileName = "****表"; System.err.println("codedFileName: " + codedFileName); response.setHeader("Content-Disposition", "attachmen...
前端Vue+后端java，根据模板导出Excel
weixin_43895856的博客
12-12 1084
前端Vue+后端java，根据模板导出Excel
springboot+vue 导出excel
10-12
可以使用Apache POI库来实现在Spring Boot和Vue中导出Excel。具体步骤如下： 1. 在后端使用POI库创建Excel文件并填充数据。 2. 将Excel文件转换为字节数组。 3. 在前端使用axios发送POST请求，将字节数组作为响应体...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值