Stack Overflow
Stack Overflow

Questions tagged [pyxll]

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

37 questions
14
votes
6 answers

Calculating Excel sheets without opening them (openpyxl or xlwt)

I made a script that opens a .xls file, writes a few new values in it, then saves the file. Later, the script opens it again, and wants to find the answers in some cells which contain formulas. If I call that cell with openpyxl, I get the formula…
Frtschaal
  • 75
  • 1
  • 1
  • 9
8
votes
2 answers

Automation Excel from Python

In my company, we use Linux in development and production environment. But we have a machine running Windows and Excel because we use a third party application excel addin to get financial market data to the machine. The add-in provides some…
nam
  • 3,542
  • 9
  • 46
  • 68
4
votes
1 answer

Trouble Loading scipy through PyXLL - Has Anyone Succeeded in Loading Scipy via PyXLL?

I am using Python 2.6, Excel 2007 Professional and the latest version of PyXLL. When loading a module in PyXLL that has import scipy An exception is thrown and the module is not loaded. Has anyone been able to load Scipy in PyXLL? Could it be a…
DonQuixote
  • 441
  • 1
  • 5
  • 9
3
votes
3 answers

Importing arrays from Excel to Python Pandas using Pyxll

I'm desperately trying to use Pyxll in order to write some excel function that gets a bunch of arrays, loads them in Python, converts them to pandas DataFrames, plays with the data a bit and then returns the final DataFrame. Now, for returning the…
erantdo
  • 685
  • 2
  • 9
  • 19
2
votes
2 answers

integration of python into excel using pyxll... having problems with lxml module

I am new to python. I am trying to get the meaning of a word from internet. The standalone python code works just fine. from lxml import html import requests url = "http://dictionnaire.reverso.net/francais-definition/" word =…
Ravi Gautam
  • 21
  • 3
2
votes
1 answer

How to add Excel cells to Python dictionary using PyXll

I have the following data in Excel: Column(A) Column(B) Column(C) Header1 Header2 Header3 A 100 USD B 200 USD C 300 USD D 400 USD E 500 USD ... ... …
Maxim
  • 507
  • 1
  • 7
  • 18
1
vote
1 answer

How can I retrieve an Excel IRibbonUI instance in Python using win32com?

I'm trying to invalidate specific controls on an Excel add-in ribbon using Python's win32com package in order to have their callbacks re-fire. Reading over Microsoft's Object References and the IRibbonUI documentation all I've seen recommended is to…
CaffeinatedMike
  • 1,537
  • 2
  • 25
  • 57
1
vote
1 answer

RefreshAll function not working on excel when call from a python function on a unsaved excel workbook

I want to update all the functions on my current workbook when I am working on it by the press of a button from the ribbon but the refreshAll function does not work. Following is the refresh_func function mapped to button clicked which run the…
vibhor Gupta
  • 103
  • 11
1
vote
0 answers

How can I use the Python language to put add-ins in Excel without using Pyxll or xlwings or VBA?

I am trying to figure out how to use Python-based functions in excel. I came across Pyxll which can make Python add-ins instead of using VBA. But Pyxll is not free after their 30-day trial. I also came across xlwings which worked fine and served the…
rdalie
  • 11
  • 3
1
vote
1 answer

Attach the PyDev interactive debugger to Python code running in PyXLL

(In Windows 10, I have installed ...\AppData\Local\Enthought\Canopy that includes Python 2.7, and another ...\AppData\Local\Programs\Python\Python35 that includes Python 3.5. %PATH points to Canopy) I want to make "attaching the PyDev interactive…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
1
vote
1 answer

How can I get number of rows and columns selected by excel COM interface?

I can get area selected by application's .Selection property. (I'm using python to access excel com interface) I want to know how many rows and columns user have selected, for instance input: user has selected A1:G8 output: the selected…
thkang
  • 11,215
  • 14
  • 67
  • 83
0
votes
0 answers

Result error by using SpaCy to find adjectives in an Excel sheet

I have an Excel file with several lines. In each row there is a cell with a longer text description. From this cell I want to export all adjectives for each row into a new column. I have created a code by using openPyXL to manipulate the excel file…
DO5DKL
  • 1
  • 1
0
votes
1 answer

How to import a range into Python from Excel as a list?

I am trying to import the range A1:C4 from Excel into Python as a list, then add '_a' to the end of every element in that list. Currently it is returning the TypeError "can only concatenate list(not 'str') to list" I've gotten it to import a range…
Connor
  • 13
  • 5
0
votes
1 answer

Issue with batch when %APPDATA% generates a path with a space in it

I have a batch script which moves, and unzips and activates an excel add in. This script works fine when run on a computer with a user with no spaces in the name however fails when a user with a space attempts to run it. Here is what I have: Echo…
Pete
  • 5
  • 4
0
votes
1 answer

How to detect value in change in excel using python?

Is there is way to know if the user changed a cells value in excel and python can react to it?
Awdsa
  • 3
  • 2
1
2 3