0

I use xlwings server, installed it as described here: , it runs on one of the VMs of my server. On another VM (Win Server 2025) I installed python, xlwings, xlwing addin and other dependencies. In the excel file in Developer > Macros > Tools > References I added xlwings. Saved the file as xlsm and exited. After that I added a script:

Sub RemoteCall()
    RunServerPython "http://100.20.11.11:8000/xlwings/custom-scripts-call/hello_world"
End Sub
'    sheet = book.sheets.active
'    cell = sheet["A1"]

'    if cell.value == "Hello test!":
'        cell.value = "Bye test!"
'    else:
'        cell.value = "Hello test!"

This works fine until I add a query to the file. Anything can happen next. For example, when adding a table with a query where the number of rows is 32766 or more, I get the error "Overflow".

enter image description here

I can also get the "Object required" error in a file that contains queries, pivot tables, smart tables.

enter image description here

At the same time, xlwings functions work fine in an empty file without any other data. Why is this happening? Why does the overflow error occur, although the query does not involve a table from another query? And what could be the cause of the Object required error?

I tried to install the xlwings server locally and run tests, and the results were the same.

Improve this question
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
8
xlwings : Object Required
0
Python XLWings Anaconda Newbie - Install / Basic issues
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.