I'm trying to setup a command using Xlwings within a Python script to set a specific cell within an Excel worksheet to an Excel Data type (e.g., Stocks, Currencies). I've found the VBA code that sets to these "newer" Excel Data types that return values from Microsoft's online services. However I'm not having any luck in getting this code to work.
Any feedback would be appreciated.
Using: MacOS: Sequoia v15.1 Excel: Excel for Mac 2021
Sample code:
wb = xw.Book(file)
sheet = wb.sheets('Stock_DataTable')
sheet.Range("B19").api.ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:= "en-US"
Expected result: format the cell as the specified data type and return the correct information from the web-service
Observed result: the call simply fails with a message saying that this is not a supported function.
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1745631761a4637152.html
评论列表（0条）