All Questions
596
questions
0
votes
0
answers
35
views
How to embed a fully interactive Plotly figure in Excel on MacOS
I am trying to embed a browser object in my excel worksheet so I can display interactive charts using plotly. I found this post Plotly: How to embed a fully interactive Plotly figure in Excel? which ...
- 13
0
votes
1
answer
34
views
How do I disable any kind of automatic conversion into excel when using xlwings?
When using xlwings, I want to, for example, write the string "4 / 5" into excel. However, if I write.
sheet[0,0].value = "4 / 5"
I get: string converted to date
I do not want to ...
- 1
1
vote
1
answer
59
views
Return multiple selected cells from excel into python via xlwings
I am trying to figure out how to pass several selected cells from excel into python via xlwings on macOS. I found code that passes cell notation but not all of the values.
For example: In my ...
- 13
0
votes
1
answer
43
views
Python xlwings slow Execution when scanning Excel Sheet
I'm a beginner at Python.
This code is for scanning Excel cells by range using xlwings however the process is very slow.
I strictly need to use xlwings since it can retain my images and shapes unlike ...
- 1
0
votes
0
answers
33
views
Excel hangs in Python script to export excel as a pdf in Task Scheduler, but works normally
I'm trying to just automate creating a pdf from an excel file to email it out everyday. It should be simple, but it isn't. If I run these files in command line, they will run, create the pdf, and ...
- 453
0
votes
1
answer
62
views
Activate multiple sheets in an Excel file with OpenPyxl
I would like to set several worksheets active in an Excel file, or change the default print settings to "Print entire workbook".
This can be done manually in Excel. But I would like to write ...
- 15
0
votes
0
answers
54
views
Checking Excel Formula behind xlwings sql function
I have some complicated processing to do on an Excel Table, for which I am using xlwings to basically run SQL over that table using the sql() function:
Example: SELECT COUNT(*) FROM a
Is it possible ...
- 415
1
vote
0
answers
55
views
Excel named range creation using xlwings workbook.names.add() generates extra quotes
Xlwings version: 0.30.14
When creating named range in excel 2016 using the following statement generates an extra quote.
Does anyone have the same issue?
Here is my code
workbook.names.add(name, f&...
- 11
1
vote
0
answers
98
views
Excel isnt working properly after python function is started
I have a Python application that can create a graph based on input that the user enters into a form that is created via Tkinter. This application is actually made as an Excel addin. It works by ...
- 11
0
votes
0
answers
26
views
Getting AssignProcessToJobObject error when trying to run Python from Excel using xlwings
I'm trying to use the xlwings add-in to run Python modules from excel. I'm starting with this basic Python script, named xlwings_test.py:
import numpy as np
import xlwings as xw
def main():
wb = ...
0
votes
1
answer
63
views
How do I set relative path as interpreter path xlwings custom add-in
I have made custom add-in using xlwings. I have one dictionary where is: phodnota.py, phodnota.xlam and Python311 (dictionary with python interpreter and all needed libraries). The problem is that ...
- 11
0
votes
1
answer
40
views
Use the row containing the sought value in an excel file as the dataframe column's titles with xlwings
How can I use the row containing a string as the dataframe column's titles, e.g:
EXCEL DATA:
FIELDS
VALUES
F1
V1
F2
V2
F3
V3
F4
V4
With F2 as sought value, my Dataframe should be as below:
F2
...
- 39
1
vote
1
answer
148
views
How do I copy-paste a worksheet from one excel workbook to another using python?
In Excel, I can manually:
open the source workbook
select the sheet I want to copy
click the Select All button in the upper left corner
ctrl-c
open the targe workbook
insert a new sheet using the ...
- 2,856
2
votes
1
answer
78
views
Is there a way to see if an excel workbook contains shapes using either openpxyl or by looking at the underlying XML?
I have thousands of excel workbooks and need to create a list of which ones contain shapes that might have text (ie a text box). How would I use either openpyxl or the underlying XML to generate a ...
- 987
1
vote
1
answer
220
views
Add sensitivity label to Excel files stored inside a folder?
I wish to add sensitivity label to all Excel files stored inside a folder. I created code with some user's reply from stack and modified it to match my use case.
The issue is I have 240 files inside ...
- 45