PyXLL - Create Excel addins using Python
PyXLL is a software product that embeds Python into Microsoft Excel enabling worksheet functions, menu items and macros to be written in Python.
More details on the website: http://www.pyxll.com
Questions tagged [pyxll]
37 questions
0
votes
0 answers
Excel not oppening Using pyxll with Conda
I was trying to generate Excel graphs with python from a dataframe and I found this code (code below):
So is not running, or opening Excel so I'm not sure if I install correctly pyxll in Conda, some help please or some easiest way to graph in excel…
user16239103
0
votes
1 answer
Trying to launch subprocess from macro
I am trying to launch a python subprocess from excel using PYXLL, but it seems to have trouble launching the cmd window and running commands.
Below is a sample of what I am trying to run:
@xl_macro()
def test():
if 1 == 1:
…
pcp23
- 11
- 3
0
votes
1 answer
Using blp.live with Pyxll Asyncio RTD in python
I am new to Pyxll and Asyncio and having trouble get the following code going. I kept getting the initial value = 0 on the spreadsheet and it's not refreshing. Could you help and let me know what I did wrong? I followed the example from Pyxll's…
DLW
- 121
- 1
- 2
- 8
0
votes
2 answers
Read and manipulate xlsx file from local storage and extract some of the values from cells into .txt and .csv files
Read excel file and extract the details into a new .txt file using openpyxl
I am new to openpyxl, just started yesterday. I need to extract the data from the excel file from my local storage that excel file have 500+ rows and 50+ columns. I want to…
user15047438
0
votes
0 answers
Handling VBA macros prompts in python
How to handle prompts generated when running the macros using the below code?
import win32com.client
import time
xl=win32com.client.Dispatch('Excel.Application')
xl.Visible = 1
xl.DisplayAlerts =…
Aditya
- 90
- 1
- 8
0
votes
0 answers
Using Pyxll to extract excel formula/vba code for re-writting in python
I have a large Excel/vba workbook (~70 sheets, most of them data tables computing loads of values) that will need converting into an actual language, so it can be packaged as a web application. Some of the logic is in VBA, however most of it is…
logicOnAbstractions
- 2,178
- 4
- 25
- 37
0
votes
0 answers
how to hide and show button on excel ribbon using VBA
Hii guys I am working a excel addin project which add custom ribbon using the ribbon xml structure defined by microsoft. I have 2 button on this ribbon login and logout .Now when the excel load I want to show login button only and when user login…
vibhor Gupta
- 103
- 11
0
votes
1 answer
Pyxll:TypeError list indices must be integers or slices,not float
In excel in cell A1 I have a simple text Hello World.
I write simple UDF function in Pyxll:
from pyxll import xl_func
@xl_func
def get_txt(txt,delimiter,ind):
l=txt.split(delimiter)
return l[ind]
example picture
When i call this function…
olksv
- 11
- 2
0
votes
1 answer
how to place multiple list on a specific cell co-ordinates using pyxll functions
Hii guys I am stuck in this bad situation I have to place multiple lists in excel at specific cell co-ordinates and cannot find any solution anywhere
Current implementation :
@xl_func("string key: object", macro=True)
def calc(key) -> object:
…
vibhor Gupta
- 103
- 11
0
votes
0 answers
is there chance could trigger validation to a certain field of a data model by using SQLAlchemy
class DataXX(Base):
__tablename__ = 'DataXX'
MyID = Column(Integer, primary_key=True, unique=True)
AnForeignID = Column(ForeignKey('xxxx.xxx'), nullable=False)
Then I am thinking to have a validate function to constrains required field AnForeignID…
BBe
- 1
- 2
0
votes
1 answer
PyXll : Range with L1C1 instead A1:B2
i installed the Add-on PyXll and all is set to work fine.
i defined a function for fetch an Array in excel which under the function
and i want to re-use this function on many arrays, so i would like to use the Reference L1C1 for be relative to the…
maxashtar
- 21
- 5
0
votes
2 answers
Fastest approach to read and process 10k Excell cells in Python/Pandas?
I want to read and process realtime DDE data from a trading platform, using Excel as 'bridge' between trading platform (which sends out datas) and Python which process it, and print it back to Excel as front-end 'gui'. SPEED IS CRUCIAL. I need…
Lorenzo Bassetti
- 795
- 10
- 15
0
votes
2 answers
How could I generate a list of dates based on user input?
Say that I have a spreadsheet that allows users to put in some metadata like the following:
Date range start: mm/dd/yyyy
Date range end: mm/dd/yyyy
Mondays: (y/n)
Tuesdays: (y/n)
Wednesdays: (y/n)
Thursdays: (y/n)
Fridays: (y/n)
Based on that, I…
simplycoding
- 2,770
- 9
- 46
- 91
0
votes
1 answer
Microsoft Excel generation on server
We are facing issue in below scenario. Expert advice will be appriciated.
Excel files are being opened with pywin32 library and excel files have User Defined Functions written using an excel addin called PyXLL. These UDFs make rest api calls and…
Swapnil Pensalwar
- 35
- 1
- 1
- 6
0
votes
1 answer
Pyxll 'ipywidgets.widgets' reloading error
I have been having the below error trying to reload Pyxll since updating my Anaconda version to 5.0.1 Python 2.7 64.
ERROR : Not reloading dependency ipywidgets.widgets because of previous failure
to reload ipywidgets.widgets.interaction
2018-07-30…
rbonallo
- 970
- 1
- 9
- 21