Code Monkey home page Code Monkey logo

pyxll-examples's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

pyxll-examples's Issues

ERROR : Error loading 'interactiveplot' : No module named 'pandas.stats'

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'

Pyxll Example to batch excel calls

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

new script to uninstall pyxll

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

What is the syntax to use the Excel SolverOK command from pyxll

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,

As of 3.10, the *loop* parameter was removed from Lock() since it is no longer necessary

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

Pyxll: How to call dataframe in excel

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:
image

please help, urgent requirment.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.