pyxll / pyxll-examples Goto Github PK

How to make custom menus, like calling formulas, allow users to pass parameters？

How to click hello to pass parameters?
THX!

C:\bamboo\excel>python bitmex.py Traceback (most recent call last): File "C:\bamboo\excel\bitmex.py", line 118, in <module> class BitMexRTD(RTD): File "C:\bamboo\excel\bitmex.py", line 124, in BitMexRTD _bitmex = BitMex(get_event_loop()) File "C:\bamboo\excel\bitmex.py", line 29, in __init__ self.__lock = asyncio.Lock(loop=loop) File "C:\Program Files\Python310\lib\asyncio\locks.py", line 78, in __init__ super().__init__(loop=loop) File "C:\Program Files\Python310\lib\asyncio\mixins.py", line 17, in __init__ raise TypeError( TypeError: As of 3.10, the *loop* parameter was removed from Lock() since it is no longer necessary

This is what I want to run in Excel from a python script:

SolverOk
SetCell := "$O$3", MaxMinVal := 2, ValueOf := 0, ByChange := "$J$3:$K$3", _
Engine := 3, EngineDesc := "Evolutionary"
SolverSolve

After searching for a long time I have not found a suitable pyxll API to communicate this VBA script to Excel.

Note: Due to security issues I cannot use xl.run('vba_script')

However, this API works:

from win32com.client.gencache import EnsureDispatch
import pythoncom

xl = EnsureDispatch("Excel.Application", pythoncom.CoInitialize())
wb = xl.Workbooks.Open(Filename=r"Test.xlsx")

xl.Range("A1:B1").Value = "Worked"

So I am looking for an api similar in spirit to the following:

from win32com.client import Dispatch
x1 = Dispatch('Excel.Application')
workbook = x1.Workbooks.Open(r"Test2.xlsx")

x1.SolverOk()
x1.SetCell("$O$3")
x1.MaxMinVal("2")
x1.ValueOf("0")
x1.ByChange("$J$3:$K$3")
x1.Engine("3")
x1.EngineDesc("Evolutionary")
x1.SolverSolve()

Is there a support for this in pyxll?

Best,

Hi,

I was wondering if Pyxll provides hooks(event handler, APIs) for use case where multiple calls to a remote service can be batched for performance improvement, something similar to this. Please let me know if you need more clarification, appreciate any help in this regards.

Thanks,
Avneesh

File "D:\chromedownload\pyxll-5.1.1-x64-py37\examples\interactiveplot.py", line 10, in
from pandas.stats.moments import ewma
File "build/x64/py37/res/release/pyxll.py", line 8206, in __import_hook
ModuleNotFoundError: No module named 'pandas.stats'
2021-06-05 13:00:19,932 - INFO : This product is licensed to
2021-06-05 13:00:19,932 - INFO : The license will expire on 2021-07-03 (28 days left)
2021-06-05 13:00:19,953 - ERROR : Error loading 'interactiveplot' : No module named 'pandas.stats'

Uninstalling an excel addin involves removing a few registry keys, otherwise excel remembers it in its list of inactive addins.

My code:
@xl_func()
def GetpdfData():
tables = camelot.read_pdf('E:\Idoc\pyxll\Test\pdftable2.pdf',flavor='lattice', pages='1-2')
return tables[1].df

its working on python environment and print table. When I call it from excel using Pyxll, it retruns below:

please help, urgent requirment.

The following line is broken:

https://github.com/pyxll/pyxll-examples/blob/master/pandas/pandastypes.py#L209

There is not dt.timezone attribute in Python 2. It's Python 3 only (https://docs.python.org/3/library/datetime.html#datetime.timezone.utc).

The easy fix for Python 2 is to use PyTZ