你是否遇到过碰到文档、表格、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}}
散会!!!