spotfire Document Property

访问spotfire的文件属性和表格
############################################################
from Spotfire.Dxp.Data import *
independentPropertyValue = Document.Properties[independentPropertyName]
i = 0
for dependentPropertyName in dependentPropertyNames.Split(","):
dependentPropertyName = dependentPropertyName.Trim()
dependentValuesDataTableName = dependentValuesDataTableNames.Split(",")[i].Trim()#去掉字符串的头尾空格
dependentValuesDataTable = Document.Data.Tables[dependentValuesDataTableName]
dependentPropertyName = dependentPropertyNames.Split(",")[i].Trim()
dependentPropertyValue = Document.Properties[dependentPropertyName]
dependentValuesColumnName = dependentValuesColumnNames.Split(",")[i].Trim()
dependentValuesColumnCursor = DataValueCursor.CreateFormatted(dependentValuesDataTable.Columns[dependentValuesColumnName])
independentValuesCursor = DataValueCursor.CreateFormatted(dependentValuesDataTable.Columns[independentValuesColumnName])#获得某列的指向指正
firstValidValue = “”
for row in dependentValuesDataTable.GetRows(dependentValuesColumnCursor, independentValuesCursor):#遍历表格
independentValue = independentValuesCursor.CurrentValue
val = dependentValuesColumnCursor.CurrentValue
if independentValue == independentPropertyValue and val != “(Empty)” :
if firstValidValue == “” :
firstValidValue = val
break
print "Setting value of dependent property " + dependentPropertyName + " to: " + firstValidValue
Document.Properties[dependentPropertyName] = firstValidValue
i += 1
#################################################################
参数
independentPropertyName: Region
independentValuesColumnName: Region
dependentPropertyNames: Country
depndentValuesDataTableNames: Continents and Countries
dependentValuesColumnNames: Region Country