檢查 Visio 形狀中的單元格時，以下代碼不會返回預期值：costVal= shpObj1.CellsU("Prop.Cost")
print (costVal)[注意 - 這是一個在我回答時被刪除的問題的摘要，但這是一個有用的問題，所以我想我會問并回答它。]
1 回答
眼眸繁星
TA貢獻1873條經驗 獲得超9個贊
要在 Visio 中獲取 ShapeSheet 單元格的值，您必須對單元格的結果屬性之一進行交互。
import os
import win32com.client
from win32com.client import constants
# this sample assumes that Visio is running, that the ActiveWindow
# is a Drawing window and that the Selection.PrimaryItem
# is a 'Decision' shape from the 'Basic Flowchart Shapes' stencil
# get the running app
appVisio = win32com.client.GetActiveObject("Visio.Application")
# selection gets you the 1 or more selected shapes and
# the PrimaryItem returns the main / primary item in that selection
# or null if the selection is empty
targetShp = appVisio.ActiveWindow.Selection.PrimaryItem
# set the cell
targetShp.CellsU("Prop.Cost").FormulaU = "=2.50"
# read the cell using its 'internal units' result property
print(targetShp.CellsU("Prop.Cost").ResultIU)
添加回答
舉報
0/150
提交
取消