使用IronPython导出Spotfire可视化至PowerPoint报错及环境咨询

问题背景 #

我找到一个声称能将Spotfire可视化内容导出到PowerPoint的IronPython脚本，但运行时出现找不到程序集的错误。

原脚本代码 #

import clr
import spotfire
clr.AddReference("System.IO")
clr.AddReference("Spotfire.Dxp.Application.Visuals")
from System.IO import *
from Spotfire.Dxp.Application.Visuals import VisualContent
from System.Drawing import Bitmap, Graphics, Rectangle, Point
clr.AddReference("Microsoft.Office.Interop.PowerPoint")
import Microsoft.Office.Interop.PowerPoint as PowerPoint

powerpoint = PowerPoint.ApplicationClass()
powerpoint.Visible = True
pres=powerpoint.Presentations.Add()
slideCounter = 1

for visual in Document.ActivePageReference.Visuals:
    #print visual.Title

    #export graphic to temp file
    vc = visual.As[VisualContent]()
    bm = Bitmap(2000, 1200)
    g = Graphics.FromImage(bm)
    r = Rectangle(Point(0,0), bm.Size)
    vc.Render(g, r)
    file = Path.GetTempFileName()
    bm.Save(file)

    #pp setup
    slide=pres.Slides.Add(slideCounter, PowerPoint.PpSlideLayout.ppLayoutTitleOnly)
    slideCounter = slideCounter+1
    slide.Shapes.AddPicture((file), False, True, 30, 60, 650, 400)
    title=slide.Shapes.Title
    txt=slide.Shapes.AddTextBox(1,10,500,500,100)
    title.Top=0.1
    obj=slide.Shapes.Title.TextFrame.TextRange
    obj.Font.Size=24

报错信息 #

File "c:\Users\matti\Desktop\Spotifre\Spotfire\Untitled-2.py", line 4, in <module>
    clr.AddReference("Spotfire.Dxp.Application.Visuals")
System.IO.FileNotFoundException: Could not load file or assembly 'Spotfire.Dxp.Application.Visuals' o una delle relative dipendenze. The system cannot find the file specified.
Nome file: 'Spotfire.Dxp.Application.Visuals'
   in System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
   in System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
   in System.Reflection.Assembly.Load(AssemblyName assemblyRef)
   in Python.Runtime.AssemblyManager.LoadAssembly(AssemblyName name)
   in Python.Runtime.CLRModule.AddReference(String name)

原因分析 #

是的，你在VS Code中用普通Python运行脚本是错误的。普通Python无法识别Spotfire.Dxp.Application.Visuals这类.NET程序集，也不能直接调用Spotfire的API，因为该脚本是专门为IronPython编写的——IronPython是运行在.NET平台上的Python实现，能直接与.NET组件交互。

IronPython环境配置与下载步骤 #

• 下载IronPython
  选择与你的Spotfire版本兼容的.NET框架版本（比如Spotfire常用.NET 4.x，对应选IronPython 2.7或3.4版本），完成完整安装，确保包含所有.NET交互相关组件。

• VS Code中配置IronPython环境

  1. 打开VS Code，安装Python扩展；
  2. 按下Ctrl+Shift+P（Windows/Linux）或Cmd+Shift+P（Mac），输入Python: Select Interpreter；
  3. 在列表中找到已安装的IronPython解释器（通常路径为C:\Program Files\IronPython x.x\ipy.exe），选择它作为当前工作区的解释器。

• 添加Spotfire程序集引用路径

  1. 找到Spotfire安装目录，定位到包含Spotfire.Dxp.Application.Visuals.dll的文件夹（通常在Spotfire安装目录\Modules\Spotfire.Dxp.Application或类似路径）；
  2. 在IronPython脚本开头添加路径引用：

     import sys
     sys.path.append("C:\\Path\\To\\Spotfire\\Assemblies")
     

  3. 替换上述路径为实际的Spotfire程序集所在路径。

• 运行脚本注意事项

  1. 运行前需确保Spotfire客户端已启动，且有打开的分析文档（脚本中Document对象依赖Spotfire运行环境）；
  2. 优先直接在Spotfire的内置IronPython控制台运行脚本，无需手动配置程序集路径，Spotfire会自动加载相关.NET组件。

内容的提问来源于stack exchange，提问作者Mattia Sferrazza