免费!文本表格不会总结、分析?文本表格可视化!帮你轻松解决困扰,保姆级级教程。【附Coze工作流】

本文涉及的产品
模型训练 PAI-DLC,100CU*H 3个月
交互式建模 PAI-DSW,每月250计算时 3个月
模型在线服务 PAI-EAS,A10/V100等 500元 1个月
简介: 本文介绍了如何利用“扣子”平台创建资源,通过可视化工作流处理并分析文档、表格、PDF等内容,帮助用户快速获取文件核心信息。内容涵盖登录、资源创建、工作流配置及运行操作,适用于多种文件格式,如CSV、Excel、PDF等。

你是否遇到过碰到文档、表格、PDF这种超多内容,但是不会废话太多,没办法一字一行看下去,但是又想知道个大概内容?


福音来了!!!超详细,超详细教程。

一、登录扣子,创建资源

网址:https://www.coze.cn/在首页,选择【工作空间】、【资源库】,




右上角,新建【资源】-【工作流】



然后输入:工作流名称、工作流描述。



第二步,复制粘贴【文件可视化工作流】  

工作流源码在文末。


在工作流界面【粘贴】:会看到如下工作流。


工作流节点解释:

想直接使用的,可以忽略解释,直接到文末拿工作流文件。


1、开始包含file、prompt。文件和提示词。



2、读取文件【read】是一个官方插件。 data就是读取到的内容。


3、处理数据针对读取到的内容,用大模型把数据格式化。


系统提示词如下:


你是一位专业的数据分析师和可视化专家。你的任务是将CSV数据转换为一个美观、专业的HTML分析报告。请遵循以下要求:1. 数据分析职责:- 对输入的CSV数据进行全面分析- 识别关键趋势和模式- 提供有意义的商业洞察- 生成相关统计数据2. 可视化要求:- 使用Chart.js库创建交互式图表- 为不同类型的数据选择最合适的图表类型(折线图、柱状图、饼图等)- 使用协调的配色方案- 确保图表具有清晰的标题和标签3. HTML报告格式:- 使用现代、响应式的设计- 包含醒目的标题和简洁的导航- 分节展示不同维度的分析- 使用Bootstrap样式美化页面4. 输出格式要求:请生成完整的HTML代码,包含:- 必要的CSS样式- Chart.js库引用- 数据可视化JavaScript代码- 分析文本和洞察5. 报告结构:- 执行摘要- 关键指标展示- 详细数据分析- 趋势分析- 建议和结论请确保生成的报告既专业又易于理解,适合向管理层汇报。示例输入:[CSV数据]期望输出:完整的HTML报告代码,包含数据可视化和分析洞察。


4、返回内容生成在线html

也是调用一个插件。叫做【HTML转URL】,这个插件三个参数,

1)一个是key,固定的。

2)password。生成html之后,查看的密码。可以设置为空。

3)html_content。html的文本内容。



三、运行点击【试运行】,上传本地需要分析的文件:目前支持html、xml、doc、docx、txt、pdf、csv、xlsx格式



运行结束后,返回结果如下:



访问返回的网址,输入上面的密码,没有的话直接进入网页了。



总结如下:



Excel源文件如下:



工作流如下:


{"type":"coze-workflow-clipboard-data","source":{"workflowId":"7540543768387141641","flowMode":0,"spaceId":"7539798710352789546","isDouyin":false,"host":"www.coze.cn"},"json":{"nodes":[{"id":"100001","type":"1","meta":{"position":{"x":-620.8737301483595,"y":-14.000018310546864}},"data":{"nodeMeta":{"description":"工作流的起始节点,用于设定启动工作流需要的信息","icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-Start-v2.jpg","subTitle":"","title":"开始"},"outputs":[{"type":"string","assistType":1,"name":"file","required":false},{"type":"string","name":"prompt","required":true}],"trigger_parameters":[]},"_temp":{"bounds":{"x":-800.8737301483595,"y":-14.000018310546864,"width":360,"height":85.6},"externalData":{"icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-Start-v2.jpg","description":"工作流的起始节点,用于设定启动工作流需要的信息","title":"开始","mainColor":"#5C62FF"}}},{"id":"900001","type":"2","meta":{"position":{"x":1259.3195255936669,"y":84.59998168945313}},"data":{"nodeMeta":{"description":"工作流的最终节点,用于返回工作流运行后的结果信息","icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-End-v2.jpg","subTitle":"","title":"结束"},"inputs":{"terminatePlan":"returnVariables","inputParameters":[{"name":"output","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"101105","name":"html_url"},"rawMeta":{"type":1}}}}]}},"_temp":{"bounds":{"x":1079.3195255936669,"y":84.59998168945313,"width":360,"height":111.6},"externalData":{"icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-End-v2.jpg","description":"工作流的最终节点,用于返回工作流运行后的结果信息","title":"结束","mainColor":"#5C62FF"}}},{"id":"122341","type":"4","meta":{"position":{"x":-148.87373014835958,"y":-27.000018310546864}},"data":{"nodeMeta":{"description":"读取文档内容,目前支持html、xml、doc、docx、txt、pdf、csv、xlsx格式","icon":"https://p3-flow-product-sign.byteimg.com/tos-cn-i-13w3uml6bg/b7145cb1c10d4ed49c883b49c2248437~tplv-13w3uml6bg-resize:128:128.image?rk3s=2e2596fd&x-expires=1745796168&x-signature=AJymOxVpgTgMgjiR7weKVNqQs9o%3D","subtitle":"文件读取:read","title":"read"},"inputs":{"apiParam":[{"input":{"type":"string","value":{"content":"7405805158996934683","rawMeta":{"type":1},"type":"literal"}},"name":"apiID"},{"input":{"type":"string","value":{"content":"read","rawMeta":{"type":1},"type":"literal"}},"name":"apiName"},{"input":{"type":"string","value":{"content":"7405805158996918299","rawMeta":{"type":1},"type":"literal"}},"name":"pluginID"},{"input":{"type":"string","value":{"content":"文件读取","rawMeta":{"type":1},"type":"literal"}},"name":"pluginName"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"pluginVersion"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"tips"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"outDocLink"}],"inputDefs":[{"description":"文档链接,不支持ip形式的资源链接,建议将ip形式资源链接转换为域名形式使用","input":{},"name":"url","required":true,"type":"string"}],"inputParameters":[{"name":"url","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"100001","name":"file"},"rawMeta":{"type":1}}}}],"settingOnError":{"processType":1,"timeoutMs":180000,"retryTimes":0}},"outputs":[{"type":"float","name":"code","required":false},{"type":"string","name":"data","required":false},{"type":"string","name":"log_id","required":false},{"type":"string","name":"msg","required":false}]},"_temp":{"bounds":{"x":-328.8737301483596,"y":-27.000018310546864,"width":360,"height":111.6},"externalData":{"icon":"https://lf6-appstore-sign.oceancloudapi.com/ocean-cloud-tos/plugin_icon/143398405153839_1723539857486970289_UwtnDxyU3d.jpg?lk3s=cd508e2b&x-expires=1758272751&x-signature=dJO6zTPXfO3k2XhQ3h31orDBuJA%3D","apiName":"read","pluginID":"7405805158996918299","pluginProductStatus":1,"pluginProductUnlistType":0,"pluginType":1,"spaceID":"7315016311652941851","inputs":[{"description":"文档链接,不支持ip形式的资源链接,建议将ip形式资源链接转换为域名形式使用","input":{},"name":"url","required":true,"type":"string"}],"outputs":[{"input":{},"name":"data","required":false,"type":"string"},{"input":{},"name":"log_id","required":false,"type":"string"},{"input":{},"name":"msg","required":false,"type":"string"},{"input":{},"name":"code","required":false,"type":"float"}],"updateTime":1755680654,"channel_id":2,"latestVersionTs":"0","latestVersionName":"","versionName":"","description":"读取文档内容,目前支持html、xml、doc、docx、txt、pdf、csv、xlsx格式","title":"read","mainColor":"#CA61FF"}}},{"id":"145182","type":"3","meta":{"position":{"x":294.9916806869062,"y":-40.57059187978909}},"data":{"nodeMeta":{"description":"调用大语言模型,使用变量和提示词生成回复","icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-LLM-v2.jpg","subTitle":"大模型","title":"大模型"},"inputs":{"inputParameters":[{"name":"input","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"122341","name":"data"},"rawMeta":{"type":1}}}},{"name":"prompt","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"100001","name":"prompt"},"rawMeta":{"type":1}}}}],"llmParam":[{"name":"generationDiversity","input":{"type":"string","value":{"type":"literal","content":"default_val","rawMeta":{"type":1}}}},{"name":"temperature","input":{"type":"float","value":{"type":"literal","content":"0.8","rawMeta":{"type":4}}}},{"name":"maxTokens","input":{"type":"integer","value":{"type":"literal","content":"16384","rawMeta":{"type":2}}}},{"name":"responseFormat","input":{"type":"integer","value":{"type":"literal","content":"2","rawMeta":{"type":2}}}},{"name":"modleName","input":{"type":"string","value":{"type":"literal","content":"DeepSeek-V3-0324","rawMeta":{"type":1}}}},{"name":"modelType","input":{"type":"integer","value":{"type":"literal","content":"1742989917","rawMeta":{"type":2}}}},{"name":"prompt","input":{"type":"string","value":{"type":"literal","content":"重点要求:{{prompt}}\n数据:\n{{input}}\n","rawMeta":{"type":1}}}},{"name":"enableChatHistory","input":{"type":"boolean","value":{"type":"literal","content":false,"rawMeta":{"type":3}}}},{"name":"chatHistoryRound","input":{"type":"integer","value":{"type":"literal","content":"3","rawMeta":{"type":2}}}},{"name":"systemPrompt","input":{"type":"string","value":{"type":"literal","content":"你是一位专业的数据分析师和可视化专家。你的任务是将CSV数据转换为一个美观、专业的HTML分析报告。请遵循以下要求:\n\n1. 数据分析职责:\n- 对输入的CSV数据进行全面分析\n- 识别关键趋势和模式\n- 提供有意义的商业洞察\n- 生成相关统计数据\n\n2. 可视化要求:\n- 使用Chart.js库创建交互式图表\n- 为不同类型的数据选择最合适的图表类型(折线图、柱状图、饼图等)\n- 使用协调的配色方案\n- 确保图表具有清晰的标题和标签\n\n3. HTML报告格式:\n- 使用现代、响应式的设计\n- 包含醒目的标题和简洁的导航\n- 分节展示不同维度的分析\n- 使用Bootstrap样式美化页面\n\n4. 输出格式要求:\n请生成完整的HTML代码,包含:\n- 必要的CSS样式\n- Chart.js库引用\n- 数据可视化JavaScript代码\n- 分析文本和洞察\n\n5. 报告结构:\n- 执行摘要\n- 关键指标展示\n- 详细数据分析\n- 趋势分析\n- 建议和结论\n\n请确保生成的报告既专业又易于理解,适合向管理层汇报。\n\n示例输入:\n[CSV数据]\n\n期望输出:\n除了html代码之外,不返回任何多余的内容。开头不需要```html ,结尾不需要```。完整的HTML报告代码,包含数据可视化和分析洞察。","rawMeta":{"type":1}}}},{"name":"stableSystemPrompt","input":{"type":"string","value":{"type":"literal","content":"","rawMeta":{"type":1}}}},{"name":"canContinue","input":{"type":"boolean","value":{"type":"literal","content":false,"rawMeta":{"type":3}}}},{"name":"loopPromptVersion","input":{"type":"string","value":{"type":"literal","content":"","rawMeta":{"type":1}}}},{"name":"loopPromptName","input":{"type":"string","value":{"type":"literal","content":"","rawMeta":{"type":1}}}},{"name":"loopPromptId","input":{"type":"string","value":{"type":"literal","content":"","rawMeta":{"type":1}}}}],"fcParamVar":{"knowledgeFCParam":{}},"settingOnError":{"switch":false,"processType":1,"timeoutMs":600000,"retryTimes":0}},"outputs":[{"type":"string","name":"output","required":false}],"version":"3"},"_temp":{"bounds":{"x":114.9916806869062,"y":-40.57059187978909,"width":360,"height":163.6},"externalData":{"icon":"https://lf3-static.bytednsdoc.com/obj/eden-cn/dvsmryvd_avi_dvsm/ljhwZthlaukjlkulzlp/icon/icon-LLM-v2.jpg","description":"调用大语言模型,使用变量和提示词生成回复","title":"大模型","mainColor":"#5C62FF","skills":[]}}},{"id":"195257","type":"4","meta":{"position":{"x":763.467591939572,"y":201.06208399904267}},"data":{"nodeMeta":{"description":"该插件可以将Html代码转换成PDF,并返回PDF的url供用户下载。","icon":"https://p9-flow-product-sign.byteimg.com/tos-cn-i-13w3uml6bg/473b760432e34c9c95ed38bfeb2af5ec~tplv-13w3uml6bg-resize:128:128.image?rk3s=2e2596fd&x-expires=1758262690&x-signature=9x47yKXZmRlP80kpQiIYhzoRtsg%3D","subtitle":"HtmlToPDF:HtmlCode2PDF_ZH","title":"HtmlCode2PDF_ZH"},"inputs":{"apiParam":[{"input":{"type":"string","value":{"content":"7484166531245686819","rawMeta":{"type":1},"type":"literal"}},"name":"apiID"},{"input":{"type":"string","value":{"content":"HtmlCode2PDF_ZH","rawMeta":{"type":1},"type":"literal"}},"name":"apiName"},{"input":{"type":"string","value":{"content":"7482579778537685055","rawMeta":{"type":1},"type":"literal"}},"name":"pluginID"},{"input":{"type":"string","value":{"content":"HtmlToPDF","rawMeta":{"type":1},"type":"literal"}},"name":"pluginName"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"pluginVersion"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"tips"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"outDocLink"}],"inputParameters":[{"name":"Html_code","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"145182","name":"output"},"rawMeta":{"type":1}}}}],"settingOnError":{"processType":1,"timeoutMs":180000,"retryTimes":0}},"outputs":[{"type":"string","name":"PDF_URL","required":false}]},"_temp":{"bounds":{"x":583.467591939572,"y":201.06208399904267,"width":360,"height":135.6},"externalData":{"icon":"https://lf6-appstore-sign.oceancloudapi.com/ocean-cloud-tos/plugin_icon/3024096363550179_1742174235428810199_BpuguP3viX.png?lk3s=cd508e2b&x-expires=1758272751&x-signature=eCP9p5NmU0DYG4n%2FM5kJv6HeXhA%3D","apiName":"HtmlCode2PDF_ZH","pluginID":"7482579778537685055","pluginProductStatus":1,"pluginProductUnlistType":0,"pluginType":1,"spaceID":"7450317224810348578","inputs":[{"description":"Html_code","input":{},"name":"Html_code","required":true,"type":"string"}],"outputs":[{"input":{},"name":"PDF_URL","required":false,"type":"string"}],"updateTime":1754383631,"channel_id":2,"latestVersionTs":"0","latestVersionName":"","versionName":"","description":"htmlcode转pdf,增加对中文字体的支持","title":"HtmlCode2PDF_ZH","mainColor":"#CA61FF"}}},{"id":"101105","type":"4","meta":{"position":{"x":778.613878106009,"y":445.64971002348295}},"data":{"nodeMeta":{"description":"通过html生成url链接功能","icon":"https://p9-flow-product-sign.byteimg.com/tos-cn-i-13w3uml6bg/adbd1d91fb2146e7a94569b5a1f7fde1~tplv-13w3uml6bg-resize:128:128.image?rk3s=2e2596fd&x-expires=1758262690&x-signature=gwyCr%2BqCxeCkRSHgvCIuc3VBGnE%3D","subtitle":"HTML转URL:html_url","title":"html_url"},"inputs":{"apiParam":[{"input":{"type":"string","value":{"content":"7500387122717818919","rawMeta":{"type":1},"type":"literal"}},"name":"apiID"},{"input":{"type":"string","value":{"content":"html_url","rawMeta":{"type":1},"type":"literal"}},"name":"apiName"},{"input":{"type":"string","value":{"content":"7500387122717802535","rawMeta":{"type":1},"type":"literal"}},"name":"pluginID"},{"input":{"type":"string","value":{"content":"HTML转URL","rawMeta":{"type":1},"type":"literal"}},"name":"pluginName"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"pluginVersion"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"tips"},{"input":{"type":"string","value":{"content":"","rawMeta":{"type":1},"type":"literal"}},"name":"outDocLink"}],"inputParameters":[{"name":"html_content","input":{"type":"string","value":{"type":"ref","content":{"source":"block-output","blockID":"145182","name":"output"},"rawMeta":{"type":1}}}},{"name":"key","input":{"type":"string","value":{"type":"literal","content":"aitansuoxia11567==","rawMeta":{"type":1}}}},{"name":"password","input":{"type":"string","value":{"type":"literal","content":"123456","rawMeta":{"type":1}}}}],"settingOnError":{"processType":1,"timeoutMs":180000,"retryTimes":0}},"outputs":[{"type":"string","name":"html_url","required":false,"description":"链接地址"}]},"_temp":{"bounds":{"x":598.613878106009,"y":445.64971002348295,"width":360,"height":135.6},"externalData":{"icon":"https://lf3-appstore-sign.oceancloudapi.com/ocean-cloud-tos/plugin_icon/732710725768116_1746293259803439006_OIRJGvJfGW.jpg?lk3s=cd508e2b&x-expires=1758272751&x-signature=yhD0ocJW66i2mzhEsLZHjA0T9Ww%3D","apiName":"html_url","pluginID":"7500387122717802535","pluginProductStatus":1,"pluginProductUnlistType":0,"pluginType":1,"spaceID":"7480814822259687439","inputs":[{"description":"html内容","input":{},"name":"html_content","required":true,"type":"string"},{"description":"密钥:aitansuoxia11567==,不定期更新。","input":{},"name":"key","required":true,"type":"string"},{"description":"页面访问密码,不设置为空","input":{},"name":"password","required":false,"type":"string"}],"outputs":[{"description":"链接地址","input":{},"name":"html_url","required":false,"type":"string"}],"updateTime":1755678645,"channel_id":2,"latestVersionTs":"0","latestVersionName":"","versionName":"","description":"html代码转化为在线浏览页面,有效期3个月。","title":"html_url","mainColor":"#CA61FF"}}}],"edges":[{"sourceNodeID":"100001","targetNodeID":"122341"},{"sourceNodeID":"101105","targetNodeID":"900001"},{"sourceNodeID":"122341","targetNodeID":"145182"},{"sourceNodeID":"145182","targetNodeID":"101105"}]},"bounds":{"x":-800.8737301483595,"y":-40.57059187978909,"width":2240.1932557420264,"height":621.820301903272}}


散会!!!

目录
相关文章
|
1月前
|
编解码 文字识别 自然语言处理
腾讯混元生图模型升级2.1版本:支持写字、2k分辨率,开源!
腾讯混元生图模型升级2.1版本:支持写字、2k分辨率,开源!
245 14
|
1月前
|
算法 测试技术 决策智能
美团开源发布 LongCat-Flash-Chat:专为高效智能体任务设计,推理速度超100 tokens/s
9月1日,美团正式发布 LongCat-Flash-Chat,并同步开源。LongCat-Flash 采用创新性混合专家模型(Mixture-of-Experts, MoE)架构,总参数 560 B,激活参数 18.6B~31.3B(平均 27B),实现了计算效率与性能的双重优化。
162 1
|
1月前
|
人工智能 自然语言处理 前端开发
魔搭社区模型速递(8.30-9.06)
🙋魔搭ModelScope本期社区进展:3361个模型,313个数据集,73个创新应用, 8篇内容
268 1
|
1月前
|
人工智能 并行计算 语音技术
魔搭社区模型速递(8.23-8.30)
🙋魔搭ModelScope本期社区进展:📟4924个模型,📁357个数据集,🎨99个创新应用,📄 9篇内容:
245 3
|
1月前
|
人工智能 数据可视化 定位技术
不会编程也能体验的 AI 魔法,外滩大会代码原生地等你解锁
不会编程也能体验的 AI 魔法,外滩大会代码原生地等你解锁
337 39
|
1月前
|
机器学习/深度学习 人工智能 自然语言处理
B站开源IndexTTS2,用极致表现力颠覆听觉体验
在语音合成技术不断演进的背景下,早期版本的IndexTTS虽然在多场景应用中展现出良好的表现,但在情感表达的细腻度与时长控制的精准性方面仍存在提升空间。为了解决这些问题,并进一步推动零样本语音合成在实际场景中的落地能力,B站语音团队对模型架构与训练策略进行了深度优化,推出了全新一代语音合成模型——IndexTTS2 。
1514 62
|
1月前
|
自然语言处理 开发者
拿下30个第1名的腾讯混元翻译模型,开源!
腾讯混元又带来一个在国际机器翻译比赛拿下30个第1名的翻译模型Hunyuan-MT-7B,它总参数量仅7B,支持33个语种、5种民汉语言/方言互译,是一个能力全面的轻量级翻译模型。
339 0