{"id":3011,"date":"2023-07-17T15:56:12","date_gmt":"2023-07-17T07:56:12","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/?p=3011"},"modified":"2023-07-17T15:56:13","modified_gmt":"2023-07-17T07:56:13","slug":"springboot-%e9%9b%86%e6%88%90-easyexcel-3-x-%e4%bc%98%e9%9b%85%e5%ae%9e%e7%8e%b0-excel-%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/springboot-%e9%9b%86%e6%88%90-easyexcel-3-x-%e4%bc%98%e9%9b%85%e5%ae%9e%e7%8e%b0-excel-%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba\/","title":{"rendered":"SpringBoot \u96c6\u6210 EasyExcel 3.x \u4f18\u96c5\u5b9e\u73b0 Excel \u5bfc\u5165\u5bfc\u51fa"},"content":{"rendered":"
\n
<\/section>\n
<\/section>\n<\/section>\n
\n

\u4ecb\u7ecd<\/h1>\n

EasyExcel \u662f\u4e00\u4e2a\u57fa\u4e8e Java \u7684\u3001\u5feb\u901f\u3001\u7b80\u6d01\u3001\u89e3\u51b3\u5927\u6587\u4ef6\u5185\u5b58\u6ea2\u51fa\u7684 Excel \u5904\u7406\u5de5\u5177\u3002\u5b83\u80fd\u8ba9\u4f60\u5728\u4e0d\u7528\u8003\u8651\u6027\u80fd\u3001\u5185\u5b58\u7684\u7b49\u56e0\u7d20\u7684\u60c5\u51b5\u4e0b\uff0c\u5feb\u901f\u5b8c\u6210 Excel \u7684\u8bfb\u3001\u5199\u7b49\u529f\u80fd\u3002<\/p>\n

EasyExcel\u6587\u6863\u5730\u5740\uff1a<\/p>\n

\n
    \n
  • \n
    https:\/\/easyexcel.opensource.alibaba.com\/<\/section>\n<\/li>\n<\/ul>\n<\/blockquote>\n

    \u5feb\u901f\u5f00\u59cb<\/h1>\n

    \u5f15\u5165\u4f9d\u8d56<\/h3>\n
    <dependency<\/span>><\/span>\n\u00a0\u00a0\u00a0\u00a0<groupId<\/span>><\/span>com.alibaba<\/groupId<\/span>><\/span>\n\u00a0\u00a0\u00a0\u00a0<artifactId<\/span>><\/span>easyexcel<\/artifactId<\/span>><\/span>\n\u00a0\u00a0\u00a0\u00a0<version<\/span>><\/span>3.1.3<\/version<\/span>><\/span>\n<\/dependency<\/span>><\/span>\n<\/code><\/pre>\n
    \u7b80\u5355\u5bfc\u51fa<\/h3>\n
    \u4ee5\u5bfc\u51fa\u7528\u6237\u4fe1\u606f\u4e3a\u4f8b\uff0c\u63a5\u4e0b\u6765\u624b\u628a\u624b\u6559\u5927\u5bb6\u5982\u4f55\u4f7f\u7528EasyExcel\u5b9e\u73b0\u5bfc\u51fa\u529f\u80fd\uff01<\/p>\n
    \u5b9a\u4e49\u5b9e\u4f53\u7c7b<\/h3>\n
    \u5728EasyExcel\u4e2d\uff0c\u4ee5\u9762\u5411\u5bf9\u8c61\u601d\u60f3\u6765\u5b9e\u73b0\u5bfc\u5165\u5bfc\u51fa\uff0c\u65e0\u8bba\u662f\u5bfc\u5165\u6570\u636e\u8fd8\u662f\u5bfc\u51fa\u6570\u636e\u90fd\u53ef\u4ee5\u60f3\u8c61\u6210\u5177\u4f53\u67d0\u4e2a\u5bf9\u8c61\u7684\u96c6\u5408\uff0c\u6240\u4ee5\u4e3a\u4e86\u5b9e\u73b0\u5bfc\u51fa\u7528\u6237\u4fe1\u606f\u529f\u80fd\uff0c\u9996\u5148\u521b\u5efa\u4e00\u4e2a\u7528\u6237\u5bf9\u8c61UserDO\u5b9e\u4f53\u7c7b\uff0c\u7528\u4e8e\u5c01\u88c5\u7528\u6237\u4fe1\u606f\uff1a<\/p>\n
    \/**\n\u00a0*\u00a0\u7528\u6237\u4fe1\u606f\n\u00a0*\n\u00a0*\u00a0@author<\/span>\u00a0william@StarImmortal\n\u00a0*\/<\/span>\n@Data<\/span>\npublic<\/span>\u00a0class<\/span>\u00a0UserDO<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u7528\u6237\u7f16\u53f7\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0Long\u00a0id;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u7528\u6237\u540d\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0String\u00a0username;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelIgnore<\/span>\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0String\u00a0password;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u6635\u79f0\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0String\u00a0nickname;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u751f\u65e5\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0@DateTimeFormat<\/span>(\"yyyy-MM-dd\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0Date\u00a0birthday;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u624b\u673a\u53f7\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0String\u00a0phone;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(\"\u8eab\u9ad8\uff08\u7c73\uff09\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@NumberFormat<\/span>(\"#.##\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(20<\/span>)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0Double\u00a0height;\n\n\u00a0\u00a0\u00a0\u00a0@ExcelProperty<\/span>(value\u00a0=\u00a0\"\u6027\u522b\"<\/span>,\u00a0converter\u00a0=\u00a0GenderConverter.class<\/span>)\n\u00a0\u00a0\u00a0\u00a0@ColumnWidth<\/span>(10)\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0Integer<\/span>\u00a0gender<\/span><\/span>;\n}\n<\/code><\/pre>\n
    \u4e0a\u9762\u4ee3\u7801\u4e2d\u7c7b\u5c5e\u6027\u4e0a\u4f7f\u7528\u4e86EasyExcel\u6838\u5fc3\u6ce8\u89e3\uff1a<\/p>\n
      \n
    • \n
      \n
      @ExcelProperty\uff1a<\/strong> \u6838\u5fc3\u6ce8\u89e3\uff0cvalue\u5c5e\u6027\u53ef\u7528\u6765\u8bbe\u7f6e\u8868\u5934\u540d\u79f0\uff0cconverter\u5c5e\u6027\u53ef\u4ee5\u7528\u6765\u8bbe\u7f6e\u7c7b\u578b\u8f6c\u6362\u5668\uff1b<\/p>\n<\/section>\n<\/li>\n
    • \n
      \n
      @ColumnWidth\uff1a<\/strong> \u7528\u4e8e\u8bbe\u7f6e\u8868\u683c\u5217\u7684\u5bbd\u5ea6\uff1b<\/p>\n<\/section>\n<\/li>\n
    • \n
      \n
      @DateTimeFormat\uff1a<\/strong> \u7528\u4e8e\u8bbe\u7f6e\u65e5\u671f\u8f6c\u6362\u683c\u5f0f\uff1b<\/p>\n<\/section>\n<\/li>\n
    • \n
      \n
      @NumberFormat\uff1a<\/strong> \u7528\u4e8e\u8bbe\u7f6e\u6570\u5b57\u8f6c\u6362\u683c\u5f0f\u3002<\/p>\n<\/section>\n<\/li>\n<\/ul>\n
      \u81ea\u5b9a\u4e49\u8f6c\u6362\u5668<\/strong><\/p>\n
      \u5728EasyExcel\u4e2d\uff0c\u5982\u679c\u60f3\u5b9e\u73b0\u679a\u4e3e\u7c7b\u578b\u5230\u5b57\u7b26\u4e32\u7c7b\u578b\u8f6c\u6362\uff08\u4f8b\u5982gender\u5c5e\u6027\uff1a1 -> \u7537\uff0c2 -> \u5973\uff09\uff0c\u9700\u5b9e\u73b0Converter\u63a5\u53e3\u6765\u81ea\u5b9a\u4e49\u8f6c\u6362\u5668\uff0c\u4e0b\u9762\u4e3a\u81ea\u5b9a\u4e49GenderConverter\u6027\u522b\u8f6c\u6362\u5668\u4ee3\u7801\u5b9e\u73b0\uff1a<\/p>\n
      \/**\n\u00a0*\u00a0Excel\u00a0\u6027\u522b\u8f6c\u6362\u5668\n\u00a0*\n\u00a0*\u00a0@author<\/span>\u00a0william@StarImmortal\n\u00a0*\/<\/span>\npublic<\/span>\u00a0class<\/span>\u00a0GenderConverter<\/span>\u00a0implements<\/span>\u00a0Converter<\/span><Integer<\/span>>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0@Override<\/span>\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0Class<?>\u00a0supportJavaTypeKey()\u00a0{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0Integer.class<\/span><\/span>;\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0@Override<\/span>\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0CellDataTypeEnum\u00a0supportExcelTypeKey<\/span>()<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0CellDataTypeEnum.STRING;\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0@Override<\/span>\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0Integer\u00a0convertToJavaData<\/span>(ReadConverterContext<?>\u00a0context)<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0GenderEnum.convert(context.getReadCellData().getStringValue()).getValue();\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0@Override<\/span>\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0WriteCellData<?>\u00a0convertToExcelData(WriteConverterContext<Integer>\u00a0context)\u00a0{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0new<\/span>\u00a0WriteCellData<>(GenderEnum.convert(context.getValue()).getDescription());\n\u00a0\u00a0\u00a0\u00a0}\n}\n<\/code><\/pre>\n
      \/**\n\u00a0*\u00a0\u6027\u522b\u679a\u4e3e\n\u00a0*\n\u00a0*\u00a0@author<\/span>\u00a0william@StarImmortal\n\u00a0*\/<\/span>\n@Getter<\/span>\n@AllArgsConstructor<\/span>\npublic<\/span>\u00a0enum<\/span>\u00a0GenderEnum\u00a0{\n\n\u00a0\u00a0\u00a0\u00a0\/**\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0\u672a\u77e5\n\u00a0\u00a0\u00a0\u00a0\u00a0*\/<\/span>\n\u00a0\u00a0\u00a0\u00a0UNKNOWN(0<\/span>,\u00a0\"\u672a\u77e5\"<\/span>),\n\n\u00a0\u00a0\u00a0\u00a0\/**\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0\u7537\u6027\n\u00a0\u00a0\u00a0\u00a0\u00a0*\/<\/span>\n\u00a0\u00a0\u00a0\u00a0MALE(1<\/span>,\u00a0\"\u7537\u6027\"<\/span>),\n\n\u00a0\u00a0\u00a0\u00a0\/**\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0\u5973\u6027\n\u00a0\u00a0\u00a0\u00a0\u00a0*\/<\/span>\n\u00a0\u00a0\u00a0\u00a0FEMALE(2<\/span>,\u00a0\"\u5973\u6027\"<\/span>);\n\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0final<\/span>\u00a0Integer\u00a0value;\n\n\u00a0\u00a0\u00a0\u00a0@JsonFormat<\/span>\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0final<\/span>\u00a0String\u00a0description;\n\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0static<\/span>\u00a0GenderEnum\u00a0convert<\/span>(Integer\u00a0value)<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0Stream.of(values())\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.filter(bean\u00a0->\u00a0bean.value.equals(value))\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.findAny()\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.orElse(UNKNOWN);\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0static<\/span>\u00a0GenderEnum\u00a0convert<\/span>(String\u00a0description)<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0Stream.of(values())\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.filter(bean\u00a0->\u00a0bean.description.equals(description))\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.findAny()\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.orElse(UNKNOWN);\n\u00a0\u00a0\u00a0\u00a0}\n}\n<\/code><\/pre>\n
      \u5b9a\u4e49\u63a5\u53e3<\/strong><\/p>\n
      \/**\n\u00a0*\u00a0EasyExcel\u5bfc\u5165\u5bfc\u51fa\n\u00a0*\n\u00a0*\u00a0@author<\/span>\u00a0william@StarImmortal\n\u00a0*\/<\/span>\n@RestController<\/span>\n@RequestMapping<\/span>(\"\/excel\"<\/span>)\npublic<\/span>\u00a0class<\/span>\u00a0ExcelController<\/span>\u00a0<\/span>{\n\n\u00a0\u00a0\u00a0\u00a0@GetMapping<\/span>(\"\/export\/user\"<\/span>)\n\u00a0\u00a0\u00a0\u00a0public<\/span>\u00a0void<\/span>\u00a0exportUserExcel<\/span>(HttpServletResponse\u00a0response)<\/span>\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0try<\/span>\u00a0{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0this<\/span>.setExcelResponseProp(response,\u00a0\"\u7528\u6237\u5217\u8868\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0List<UserDO>\u00a0userList\u00a0=\u00a0this<\/span>.getUserList();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0EasyExcel.write(response.getOutputStream())\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.head(UserDO.class<\/span>)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.excelType<\/span>(ExcelTypeEnum<\/span>.XLSX<\/span>)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.sheet<\/span>(\"\u7528\u6237\u5217\u8868\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.doWrite<\/span>(userList<\/span>)<\/span>;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\u00a0catch<\/span>\u00a0(IOException\u00a0e)\u00a0{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0throw<\/span>\u00a0new<\/span>\u00a0RuntimeException(e);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0\/**\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0\u8bbe\u7f6e\u54cd\u5e94\u7ed3\u679c\n\u00a0\u00a0\u00a0\u00a0\u00a0*\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0@param<\/span>\u00a0response\u00a0\u00a0\u00a0\u00a0\u54cd\u5e94\u7ed3\u679c\u5bf9\u8c61\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0@param<\/span>\u00a0rawFileName\u00a0\u6587\u4ef6\u540d\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0@throws<\/span>\u00a0UnsupportedEncodingException\u00a0\u4e0d\u652f\u6301\u7f16\u7801\u5f02\u5e38\n\u00a0\u00a0\u00a0\u00a0\u00a0*\/<\/span>\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0void<\/span>\u00a0setExcelResponseProp<\/span>(HttpServletResponse\u00a0response,\u00a0String\u00a0rawFileName)<\/span>\u00a0throws<\/span>\u00a0UnsupportedEncodingException\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0response.setContentType(\"application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0response.setCharacterEncoding(\"utf-8\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String\u00a0fileName\u00a0=\u00a0URLEncoder.encode(rawFileName,\u00a0\"UTF-8\"<\/span>).replaceAll(\"\\+\"<\/span>,\u00a0\"%20\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0response.setHeader(\"Content-disposition\"<\/span>,\u00a0\"attachment;filename*=utf-8''\"<\/span>\u00a0+\u00a0fileName\u00a0+\u00a0\".xlsx\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0\/**\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0\u8bfb\u53d6\u7528\u6237\u5217\u8868\u6570\u636e\n\u00a0\u00a0\u00a0\u00a0\u00a0*\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0@return<\/span>\u00a0\u7528\u6237\u5217\u8868\u6570\u636e\n\u00a0\u00a0\u00a0\u00a0\u00a0*\u00a0@throws<\/span>\u00a0IOException\u00a0IO\u5f02\u5e38\n\u00a0\u00a0\u00a0\u00a0\u00a0*\/<\/span>\n\u00a0\u00a0\u00a0\u00a0private<\/span>\u00a0List<UserDO>\u00a0getUserList<\/span>()<\/span>\u00a0throws<\/span>\u00a0IOException\u00a0<\/span>{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ObjectMapper\u00a0objectMapper\u00a0=\u00a0new<\/span>\u00a0ObjectMapper();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ClassPathResource\u00a0classPathResource\u00a0=\u00a0new<\/span>\u00a0ClassPathResource(\"mock\/users.json\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0InputStream\u00a0inputStream\u00a0=\u00a0classPathResource.getInputStream();\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return<\/span>\u00a0objectMapper.readValue(inputStream,\u00a0new<\/span>\u00a0TypeReference<List<UserDO>>()\u00a0{\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0});\n\u00a0\u00a0\u00a0\u00a0}\n}\n<\/code><\/pre>\n
      \u6d4b\u8bd5\u63a5\u53e3<\/strong><\/p>\n
      \u8fd0\u884c\u9879\u76ee\uff0c\u901a\u8fc7 Postman \u6216\u8005 Apifox \u5de5\u5177\u6765\u8fdb\u884c\u63a5\u53e3\u6d4b\u8bd5<\/p>\n
      \n
      \u6ce8\u610f\uff1a\u5728 Apifox \u4e2d\u8bbf\u95ee\u63a5\u53e3\u540e\u65e0\u6cd5\u76f4\u63a5\u4e0b\u8f7d\uff0c\u9700\u8981\u70b9\u51fb\u8fd4\u56de\u7ed3\u679c\u4e2d\u7684\u4e0b\u8f7d\u56fe\u6807\u624d\u884c\uff0c\u70b9\u51fb\u4e4b\u540e\u65b9\u53ef\u5bf9Excel\u6587\u4ef6\u8fdb\u884c\u4fdd\u5b58\u3002<\/p>\n<\/blockquote>\n
      \u63a5\u53e3\u5730\u5740\uff1ahttp:\/\/localhost:8080\/excel\/export\/user<\/code><\/p>\n