Top "Openpyxl" questions

openpyxl font conditional formatting

I am using pyopenxl to output some excel spreadsheets, I encountered a problem with font conditional formatting. I want to …

python excel fonts conditional-formatting openpyxl

Django: openpyxl saving workbook as attachment

Hi I have a quick question. I didn't find answer in internet maybe someone of you can help me. So …

python django excel xlsx openpyxl

openpyxl: assign value or apply format to a range of Excel cells without iteration

I would like to apply a specific format or assign a value to a range of Excel cells without iterating …

python openpyxl

Setting default number format when writing to Excel from Pandas

I'm looking to set the default number format when writing to Excel from a Pandas dataframe. Is this possible? I …

python python-3.x pandas openpyxl xlsxwriter

Openpyxl and Hidden/Unhidden Excel Worksheets

I have the following code that reads data from a tab-delimited text file and then writes it to a specified …

python excel openpyxl

Inserting a table with openpyxl

Is there any way with openpyxl (or perhaps another library) to insert a table into an Excel worksheet? By "insert …

python python-2.7 openpyxl

Removing gridlines from excel using python (openpyxl)

I'm trying to remove gridlines from excel worksheet which I created using openpyxl, and it's not working. I'm doing this: …

python excel python-2.7 openpyxl

Python: openpyxl how to read a cell font color

I have tried to print some_cell.font.color.rgb and got various results. For some I got what I …

python openpyxl

Insert an image into Excel with openpyxl

My PC crashed and so I had to reinstall all of my libraries; after finishing the install, I realized that …

python-3.x openpyxl insert-image

How to load in Python an xlsx that originally had .xls file extension?

I'm using xlrd to process .xls files, and openpyxl to process .xlsx files, and this is working well. Then I'm …

python python-2.7 excel-2010 xlrd openpyxl