Office中是否存在一个对象，它等同于vba中的mytable.tableobject.workbookconnection.oledbconnection.commandtext

Question

嗨，有人建议我尝试学习办公脚本，并且正在尝试将现有的基于vba的解决方案转换为办公脚本。现有的解决方案编写一个DAX查询并返回一个excel表。我找不到如何在typescript中访问它。

VBA是

Function GetDataFromDataModel(myDAXScript As String) As ListObject
Dim myDaxHubTable As ListObject
Set myDaxHubTable = blwModel.ListObjects("dxtDAXHub")


With myDaxHubTable.TableObject.WorkbookConnection.OLEDBConnection
        .CommandText = myDAXScript
        .CommandType = xlCmdDAX
End With
'Debug.Print myDAXScript
    ActiveWorkbook.Connections(myDaxHubTable.TableObject.WorkbookConnection.Name).Refresh
    
   Set GetDataFromDataModel = myDaxHubTable

End Function

Answer 1

不幸的是，目前还不支持这一点。如果有帮助，DataConnectionCollection.refreshAll可用于现有连接。