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
1 answer
Pyxll file format and extension error on opening Excel
I have been trying to add Pyxll add-in to excel but have run into considerable issues. I have tried to install the add-in through canopy and the standard zip file. I get the file onto my computer, add it to the add-in list, and then re-open excel…
Joseph Sansevero
- 1
- 3
0
votes
1 answer
pyxll return array of strings
I'm creating a xl_func that receives data from sql server (string) and return to excel (auto_resize=True). The end of the code is:
result = cursor.fetchall()
final_result = [row[0] for row in result]
return final_result
It runs okay, but it returns…
ranthero
- 92
- 7
0
votes
2 answers
Make eclipse_debug.py work
(In Windows 10, I have installed ...\AppData\Local\Enthought\Canopy that includes Python 2.7, %PATH% points to Canopy)
I have seen this link, and want to make interactively debug Python code running in PyXLL work via that eclipse_debug.py.
So I have…
SoftTimur
- 5,630
- 38
- 140
- 292
0
votes
1 answer
kernel32 library via excel com in Python
I would like to do the equivalent of the below Excel VBA code in Python - COM
Private Declare Function SetDllDirectory Lib "kernel32.dll" Alias "SetDllDirectoryA" ( _
ByVal lpPathName As String) As Boolean
So now in Excel VBA, I can call…
user2845329
- 13
- 2
0
votes
1 answer
How to install a python package(PyXLL) correctly that is enclosed in a .zip file (that includes a bunch of different file formats)?
I downloaded a .zip file to install the python PyXLL package, using sudo apt-get install PyXLL or sudo pip install PyXLL doesn't work. Normally when you double click on a downloaded .zip that contains something to install in ubuntu it autoinstalls.…
Bentley4
- 10,678
- 25
- 83
- 134
-1
votes
2 answers
KeyError:"['class']" not found in axis
I found a tutorial about decision tree algorithm using pyxll add-in for excel, and tried to execute. I get an error: KeyError:"['class']" not found in axis.
from pyxll import xl_func
from sklearn.tree import DecisionTreeClassifier
from…
minipuncher
- 3
- 2
- 5
-1
votes
2 answers
Excel function created using PyXLL throws #num error
I am using Python with Pyxll to create a function in Excel which should return a timeline chart. Function takes two parameters -"names" and "dates"
when I tried to use this function in excel by selecting the range in "names" and "dates" columns, it…
user3200076
- 109
- 7