使用poi导出带图片的excel

发布于:2024-10-11 ⋅ 阅读:(77) ⋅ 点赞:(0)

package org.springblade.modules.system.controller;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.export.ExcelExportService;
import cn.hutool.core.codec.Base64;
import cn.hutool.core.io.FileUtil;
import cn.hutool.http.HttpUtil;
import cn.hutool.poi.excel.ExcelUtil;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.servlet.ServletOutputStream;
import jakarta.servlet.http.HttpServletResponse;
import lombok.AllArgsConstructor;
import lombok.extern.java.Log;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.ss.usermodel.;
import org.apache.poi.util.IOUtils;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tenant.annotation.NonDS;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.StringUtil;
import org.springblade.modules.system.pojo.dto.BizAlarmStatisticsDTO;
import org.springblade.modules.system.pojo.entity.BizAlarmStatistics;
import org.springblade.modules.system.pojo.entity.BizInternalBusManagement;
import org.springblade.modules.system.service.BizAlarmStatisticsService;
import org.springframework.web.bind.annotation.
;

import java.io.*;
import java.net.URLEncoder;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

import java.util.List;

/**

  • @author 31845
    */
    @NonDS
    @RestController
    @AllArgsConstructor
    @Tag(name = “报警统计对象功能接口”, description = “报警统计对象功能接口”)
    @Log
    @RequestMapping(“/bizAlarmStatistics”)
    public class BizAlarmStatisticsController extends BladeController {

    private BizAlarmStatisticsService bizAlarmStatisticsService;
    @PostMapping(“/insert”)
    public R insert(@RequestBody BizAlarmStatistics bizInternalBusManagement) {
    try {
    bizAlarmStatisticsService.save(bizInternalBusManagement);
    return R.success(“保存成功!”);
    } catch (Exception e) {
    return R.fail(“保存失败:” + e.getMessage());
    }

    }
    @GetMapping(“/selectpage”)
    public R<IPage> selectpage(BizAlarmStatisticsDTO bizAlarmStatisticsDTO, Query query) {

     try {
         IPage<BizAlarmStatistics> bizAlarmStatisticsIPage = bizAlarmStatisticsService.lambdaQuery()
                 .eq(StringUtil.isNotBlank(bizAlarmStatisticsDTO.getType()),BizAlarmStatistics::getType,bizAlarmStatisticsDTO.getType())
                 .eq(StringUtil.isNotBlank(bizAlarmStatisticsDTO.getDept()),BizAlarmStatistics::getDept,bizAlarmStatisticsDTO.getDept())
                 .eq(StringUtil.isNotBlank(bizAlarmStatisticsDTO.getFleetName()),BizAlarmStatistics::getFleetName,bizAlarmStatisticsDTO.getFleetName())
                 .eq( bizAlarmStatisticsDTO.getIsExternalBus()!=null,BizAlarmStatistics::getIsExterna

网站公告

今日签到

点亮在社区的每一天
去签到