1. 导入导出插件手册

低代码实现快速excel、word数据的导入导出功能,基于apache的poi与docx4j进行二次开发,提供了excel、word的导入导出功能。通常用于列表数据展示页的导入导出

[!tip] 目前只支持docx xlsx文件的导入导出

2. 效果展示

配置说明:defaults是一些必要参数的默认值,用户需根据自己实际情况自行配置,如progress_status改为终审通过,content_style根据在自定义字典中的模板类型数据值做相应调整,在这之前要确保栏目已经绑定模板。

[!tip] 配置好后需要在对应的业务页面中使用导入,导出组件完整导入导出的功能

2.1. word导入导出

Alt text

Alt text

Alt text

导出配置

SELECT content_title as docFileName, content_details as docFileContent  FROM `cms_content` WHERE id in ({});

导入配置

[{"table":"cms_content","id":"snow","columns":{"docFileName":"content_title","docFileContent":"CONTENT_DETAILS","categoryId":"category_id"},"defaults":{"del":"0","content_display":"0","progress_status":"草稿"}}]

配置项介绍具体查看表单下的提示

[!tip] 导入默认对create_date(当前时间)、content_datetime(当前时间)、content_type('')做了处理

2.2. excel导入导出

Alt text

Alt text

导出配置

SELECT content_title as '标题',content_author as '作者', create_date as '发布时间',category_id as '所属栏目' FROM `cms_content` WHERE id in ({});

[!tip] 通过查询指定需要展示在excel中的字段

导入配置

[{"table":"cms_content","id":"snow","columns":{"标题":"CONTENT_TITLE","作者":"CONTENT_AUTHOR","所属栏目":"category_id"},"defaults":{"del":"0","content_display":"0","progress_status":"草稿"}}]

Copyright © mingsoft.net 2012-2022 all right reserved,powered by Gitbook该文件修订时间: 2025-04-30 18:08:44

results matching ""

    No results matching ""

    results matching ""

      No results matching ""