错误：丢失了非最佳输出Excel（XLSX）
我在使用 Design Automation 导出 Excel 时遇到问题。我目前不知道如何解决这个问题，所以你的团队可以看看。这是 workitemsId ： fa60d42304e6434c85fe973026db7f68
[04/06/2022 04:19:36] Start upload phase.
[04/06/2022 04:19:36] Error: Non-optional output [report.xlsx] is missing.
[04/06/2022 04:19:36] Error: An unexpected error happened during phase Publishing of job.
[04/06/2022 04:19:36] Job finished with result FailedMissingOutput
这是
{
"id": "TestingActivity03",
"commandLine": [
"$(engine.path)\\\\revitcoreconsole.exe /i \"$(args[rvtFile].path)\" /l JPN /al \"$(appbundles[DemoTest02].path)\""
],
"parameters": {
"rvtFile": {
"zip": false,
"ondemand": false,
"verb": "get",
"description": "Input Revit model",
"required": true,
"localName": "$(rvtFile)"
},
"params": {
"zip": false,
"ondemand": false,
"verb": "get",
"description": "params",
"required": true,
"localName": "params.json"
},
"report": {
"zip": false,
"ondemand": false,
"verb": "put",
"description": "reports",
"required": true,
"localName": "report.xlsx"
}
},
"engine": "Autodesk.Revit+2022",
"appbundles": [
"tanpv.DemoTest02+test"
],
"description": "Add CBB from Revit file." }
我将文件 revit 放入 Bucket 中的活动。 谢谢回复！
I have an issue about exporting Excel using Design Automation. I currently don't know how to fix this, so your team can take a look. Here is workitemsId : fa60d42304e6434c85fe973026db7f68
[04/06/2022 04:19:36] Start upload phase.
[04/06/2022 04:19:36] Error: Non-optional output [report.xlsx] is missing.
[04/06/2022 04:19:36] Error: An unexpected error happened during phase Publishing of job.
[04/06/2022 04:19:36] Job finished with result FailedMissingOutput
And here is Actities
{
"id": "TestingActivity03",
"commandLine": [
"$(engine.path)\\\\revitcoreconsole.exe /i \"$(args[rvtFile].path)\" /l JPN /al \"$(appbundles[DemoTest02].path)\""
],
"parameters": {
"rvtFile": {
"zip": false,
"ondemand": false,
"verb": "get",
"description": "Input Revit model",
"required": true,
"localName": "$(rvtFile)"
},
"params": {
"zip": false,
"ondemand": false,
"verb": "get",
"description": "params",
"required": true,
"localName": "params.json"
},
"report": {
"zip": false,
"ondemand": false,
"verb": "put",
"description": "reports",
"required": true,
"localName": "report.xlsx"
}
},
"engine": "Autodesk.Revit+2022",
"appbundles": [
"tanpv.DemoTest02+test"
],
"description": "Add CBB from Revit file." }
I put in file revit into Bucket.
Thanks for reply!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当指定了活动中的输出参数，但 appbundle 无法生成具有该本地名称的文件时，就会发生这种情况。在您的情况下，您使用本地名称
report.xlsx指定了输出参数report。我检查了工作项 IDfa60d42304e6434c85fe973026db7f68的日志，没有找到任何关于为什么您的代码没有生成此文件的线索。也许您可以在代码中使用
Console.WriteLine()添加一些调试日志，并在日志文件中亲自查看。关于如何在设计自动化中使用excel，您可以参考我们的博客设计自动化-Revit参数导出与导出使用 Excel 导入示例并查看代码示例。
This happens when an output parameter in an activity is specified, but the appbundle fails to generate the file with that local name. In your case you specified an output parameter
reportwith local namereport.xlsx. I checked the logs for the workitem idfa60d42304e6434c85fe973026db7f68did not find any clue as to why your code did not generate this file.Maybe you could add some debug logs using
Console.WriteLine()in your code and see for yourselves in the log file.For how use excel in design automation, you may refer our blog Design Automation - Revit Parameters Export & Import sample with Excel and see code samples.