All Questions
637 questions
1
vote
1
answer
90
views
xlsxwriter - Creating Table Formulas using Structural References
I am trying to create a table in Excel using XLSX writer where a lot of the data is precomputed, but a few columns need running formulas.
I am trying to use structural references (headers as ...
- 98
0
votes
0
answers
73
views
copy excel image using openpyxl. The source image was inserted using xlsxwriter
I want to copy an excel image from source sheet to target sheet.
At the beginning I inserted the photo using xlsxwriter in the code down below
def format_sheet_for_mapping_user_sector_location(
...
0
votes
1
answer
214
views
Apply different color coding within a cell with OpenPyxl
I have several already made excels that I'd like to format.
One of these formatting is to set a part of a cell in green, and the other part in red.
For the sake of this example, let's imagine cell &...
- 130
-2
votes
1
answer
70
views
The Excel file gets corrupted every time I write something in it with Python
I am trying to update my excel file with pandas but every time file will be corrupted
and i cant open it anymore
1234.xlsx -> Sheet1
gamma
gammasat
E50ref
EoedRef
EurRef
c
Φ
EA
f.s
17.67
18.6
10500
...
user26437626
2
votes
2
answers
332
views
num_format not applying to Excel Column
Hope someone can shed some light on this as this has beaten me so far today.
Context:
I have a pandas dataframe styled via the pandas styler which I am exporting via a file dialgue so a file name can ...
- 31
0
votes
1
answer
358
views
Creating/Updating an excel file with slicers from python
I have some python code which creates a few pandas data frames which I need to put into a spreadsheet, with different data on multiple sheets and with slicers for easy filtering. This then gets sent ...
- 3,327
0
votes
0
answers
196
views
Adding a DatePicker into Excel cells using Python XlsxWriter?
I am trying to create an input form using Excel generated by Python XlsxWriter. I wonder is it possible to add a mini calendar (as a DatePicker) into Excel cells for users to input dates?
I stumbled ...
- 70
2
votes
1
answer
658
views
How to fit an image exactly inside an Excel cell using Python and XlsxWriter?
I'm working on a Python script that inserts images into Excel cells using the XlsxWriter library. My goal is to have each image fit precisely within its cell, without any overflow or unused space.
...
- 2,588
0
votes
1
answer
165
views
How to add a min/max value in conditional formatting using xlsxwriter for python?
I am trying to create a shmoo plot with conditional formatting where the formatting rule knows the minimum value and does not mark the minimum value in the table with the minimum color, instead it ...
- 5
-2
votes
1
answer
98
views
Formulas has an "@" between them when i use xlsx writer to create a excel sheet in python
im working on a project in python where i have to collect some filtered date from google sheets and create a new .xlsx file, the problem is that one of the columns on google sheets, has a image ...
- 1
0
votes
0
answers
27
views
Is there a way to not have URLs in Excel Spreadsheet table as hyperlinks when using pandas and xlsxwriter? [duplicate]
I made a function to create a table with the contents from the DataFrame to the Excel spreadsheet.
def make_table(file: str, df_to_use: pd.DataFrame):
writer = pd.ExcelWriter(file, engine="...
- 1
0
votes
1
answer
59
views
Python : 2 (or more) conditional formatting for the same Excel range
I have the following code :
Wb.sheets["MySheet"].conditional_format('B2:B15', {'type':'formula',
'criteria':'=(C2:C15="Singular")', 'format':Format1})
Wb.sheets["...
- 19
0
votes
1
answer
119
views
Unexpected keyword argument 'constant_memory'
I need to improve the performance of the Excel writer part of my code and referred to xlsxwriter and pandas documentation.
import pandas as pd
...
writer = pd.ExcelWriter('result.xlsx', engine='...
- 805
0
votes
1
answer
174
views
Is there a way to autofit the comment window height with Python's xlsxwriter?
I just implemented a way to attach various metadata to cells in the excel files we produce in our data validation interface for our scientific data django app. I'm basically migrating from our usage ...
- 1,146
1
vote
1
answer
39
views
Adding row colors based on unique rows in xlxswriter python
I was generating xlxs file from python python xlxswriter package. I want to generate rows with color coded based on the combination unique id. Please find the below output
Current Logic:
...
- 25