spring boot导出Excel报Could not find acceptable representation

最新推荐文章于 2022-11-07 16:35:50 发布

Love丶TG

最新推荐文章于 2022-11-07 16:35:50 发布

阅读量5.7k

点赞数

分类专栏： java web

java web 专栏收录该内容

24 篇文章

订阅专栏

本文介绍了解决在使用Swagger-UI导出Excel时出现的Couldnotfindacceptablerepresentation错误的方法。通过配置FastJsonHttpMessageConverter，解决了前端请求静态资源时的乱码和数据格式问题。

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

当使用swagger-ui导出excel或直接连接导出时后台抛Could not find acceptable representation，由于get请求动态加载数据，前端<a>标签请求，提示静态资源获取错误，以下是我遇到的问题，找到的几篇好的博文，用于记录。

import com.alibaba.fastjson.serializer.SerializerFeature;
import com.alibaba.fastjson.support.config.FastJsonConfig;
import com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.http.HttpMessageConverters;
import org.springframework.context.annotation.Bean;
import org.springframework.http.converter.HttpMessageConverter;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

/**
 * 解决导Excel报 Could not find acceptable representation
 * 参考博文：① https://blog.youkuaiyun.com/qq_28289405/article/details/80939841
 * ② https://blog.youkuaiyun.com/qq_18600061/article/details/80227490
 * Created by Love丶TG on 2018/8/10 16:27.
 */
//@Configuration
public class FastJsonConfiguration implements WebMvcConfigurer {

//    @Bean
//    public HttpMessageConverters fastJsonHttpMessageConverters() {
//        //1.需要定义一个convert转换消息的对象;
//        FastJsonHttpMessageConverter fastJsonHttpMessageConverter = new FastJsonHttpMessageConverter();
//        //2:添加fastJson的配置信息;
//        FastJsonConfig fastJsonConfig = new FastJsonConfig();
//        fastJsonConfig.setSerializerFeatures(SerializerFeature.PrettyFormat);
//        //3处理中文乱码问题
//        List<MediaType> fastMediaTypes = new ArrayList<>();
//        fastMediaTypes.add(MediaType.APPLICATION_JSON_UTF8);
//        //4.在convert中添加配置信息.
//        fastJsonHttpMessageConverter.setSupportedMediaTypes(fastMediaTypes);
//        fastJsonHttpMessageConverter.setFastJsonConfig(fastJsonConfig);
//        HttpMessageConverter<?> converter = fastJsonHttpMessageConverter;
//        return new HttpMessageConverters(converter);
//
//    }

    @Bean
    public FastJsonConfig fastJsonConfig() {
        FastJsonConfig fastJsonConfig = new FastJsonConfig();
        fastJsonConfig.setSerializerFeatures(SerializerFeature.PrettyFormat);
        return fastJsonConfig;
    }

    @Bean
    public HttpMessageConverters fastJsonHttpMessageConverters(
            @Qualifier("fastJsonConfig") FastJsonConfig fastJsonConfig) {
        FastJsonHttpMessageConverter fastConverter = new FastJsonHttpMessageConverter();
        fastConverter.setFastJsonConfig(fastJsonConfig);
        HttpMessageConverter<?> converter = fastConverter;
        return new HttpMessageConverters(converter);
    }

    /**
     * @Description 修改自定义消息转换器
     * @Param converters 消息转换器列表
     **/
//    @Override
//    public void configureMessageConverters(List<HttpMessageConverter<?>> converters) {
//        //调用父类的配置
//        super.configureMessageConverters(converters);
//        //创建fastjson消息转换器
//        FastJsonHttpMessageConverter fastConverter = new FastJsonHttpMessageConverter();
//        //创建配置类
//        FastJsonConfig fastJsonConfig = new FastJsonConfig();
//        //修改配置返回内容的过滤
//        fastJsonConfig.setSerializerFeatures(
//                SerializerFeature.DisableCircularReferenceDetect,
//                SerializerFeature.WriteMapNullValue,
//                SerializerFeature.WriteNullStringAsEmpty
//        );
//        fastConverter.setFastJsonConfig(fastJsonConfig);
//        //将fastJson 添加到视图消息转换器列表内
//        converters.add(fastConverter);
//    }
}