Category "openpyxl"

Openpyxl not found in Pycharm

I am new to programming Python using Pycharm. I would like to access openpyxl (which I installed) but get the following error message: Traceback (most recent

Processing large XLSX file in python

I have a large xlsx Excel file (56mb, 550k rows) from which I tried to read the first 10 rows. I tried using xlrd, openpyxl, and pyexcel-xlsx, but they always t

Simple conditional text formatting with openpyxl by text

I am using openpyxl 3.0.3 and python 3.7.3. I don't know what version of Excel I'm using since it does not seem to say anywhere. It's Office 365. What I want t

Using openpyxl module to write to spreadsheet creates a damaged spreadsheet, how to fix with zipfile module?

I have a program which writes to a spreadsheet using openpyxl. Upon execution of the program, the cells are filled as expected but the spreadsheet becomes damag

openpyxl: AttributeError: 'MergedCell' object attribute 'value' is read-only

When i'm trying to fill the cell in existing .xlsx file and then save it to a new one I got message: import openpyxl path = "/home/karol/Dokumenty/wzor.xlsx"

want to add worksheet from one workbook in to another workbook using openpyxl

I am pretty sure there is an easier way than how i am doing it, I just have two workbooks and a single sheet in each work book, does anyone have any any suggest