1,134 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Tooling
0
votes
1
replies
67
views
Web page interaction inside PySide6.QtWebEngine
As written in the title, im looking for a way to interact with a web embedded inside a PySide6 window.
Right now i have a pyside6 GUI which connects to an excel page (xlwings library) to extract the ...
4
votes
0
answers
145
views
How to read mixed data (numbers and strings) from Excel with xlwings without converting 123 → 123.0
I’m using xlwings to read an Excel sheet into a pandas DataFrame with the built-in pd.DataFrame converter.
Some of my columns contain mixed data (e.g. IDs or codes like 123, 00123, ABCD).
When I read ...
0
votes
0
answers
101
views
Why xlwings custom scripts fails with queries and connections in excel file?
I use xlwings server, installed it as described here: , it runs on one of the VMs of my server. On another VM (Win Server 2025) I installed python, xlwings, xlwing addin and other dependencies. In the ...
0
votes
0
answers
98
views
How to automatically trigger Ctrl+Shift+Enter for array formulas in Excel after adding sheets with Python?
I have a main Excel workbook containing array formulas, which reference data from several sub-workbooks (or sheets). The workflow is as follows:
The main workbook initially does not contain the sub-...
1
vote
2
answers
143
views
How to Bypass "Grant Access" when using Xlwings
I am in the process of porting over some python excel automation scripts to work on MacOS (previously they were run on windows, and used the pywin32 library to "refresh" an excel file - the ...
0
votes
2
answers
101
views
Try to open Excel.xlsm file using xlwings results in Com-Error
I'm currently working on a project where I need to open an .xlsm Excel file through my code.
However, I keep running into the following error:
öffnen
Traceback (most recent call last):
File "C:\...
0
votes
1
answer
65
views
How to copy a picture cell using python with xlwings?
I try to copy the picture cells in column B using xlwings with the following code-snippet to first read all the images:
import os
import sys
import xlwings as xw
path = os.path.abspath(os.path....
1
vote
2
answers
155
views
Get the current folder of Excel from xlwings Lite addin
I am using xlwings Lite addin with Excel 2021. Is there any way to get the path of Excel file from xlwings Lite? I tried to use os.getcwd() function, but it returns python working directory.
Thanks,
0
votes
1
answer
75
views
UnboundLocalError when trying to access a sharepoint file using xw.Book
I am trying to access an excel which is stored in sharepoint. I am opening that particular file runs_excel after closing all excel instances from Task Manager. This used to work since the last six ...
0
votes
2
answers
239
views
How to force a string to stay a string and not be converted to a date ? - Python [closed]
I'm facing an issue while pushing data into Excel using Python.
I need to write a string like "4/10" to a cell, but Excel automatically converts it into a date.
However, "4/10" is ...
1
vote
1
answer
288
views
Reticulate with pywin32, a dependency of xlwings, not found when sourcing python script from R [duplicate]
Overview
I have a python script opens an excel workbook, makes some changes, then saves it. This is just one step in a series of excel processing operations, most of which are written in R. My end ...
0
votes
1
answer
98
views
pipx installed xlwings module not found
I have an Excel workbook that uses an xlwings RunPythonScript() call to an external python script. As I want to run this python script outside of my vdev I've installed pipx and through pipx installed ...
0
votes
0
answers
64
views
How to make xlwings work on mac Sonoma? Error message tells I need to have appscript and psutil dependencies
Trying to install xlwings on a mac. MacOS Sonoma, version 14.7.1. Python 3.12. Installed through Anaconda. I get the error message
XlwingsError: Make sure to have "appscript" and "...
0
votes
0
answers
79
views
python clearing Excel autofilter
I'm currently automating a process using python and xlwings and need to clear any AutoFilters in a target excel worksheet. I've seen numerous samples that refer to using
if wb.sheets[sheetname].api....
0
votes
0
answers
75
views
Using Python to Import data from MySql into Ms.Excel ListObject
I am trying to automate a process where we need to import data from MySQL Database in to a ListObject (Ms.Excel Table).
Environment:
Ms.Office Professional 2021
Windows 10 pro
Python 3.12.1
The code ...