i have an excel file that i cant change, where im getting some info with openpyxl, on this case i have a cell with this DATE format MM/DD/YYYY i need the output on python to be: %d/%m/%Y Ive tried this : I get this error : How can i make this work correctly? (im new in python and also on
Tag: openpyxl
How to write to new empty cell in openpyxl
I see there are a few similar questions already asked, but none seem to solve my problem. Also, some offer deprecated solutions such as using coordinate. The code I have works fine, but because I start the loop at a certain position, every time I re-run the code, it obviously starts writing from that one posi…
How to detect protected cells in Excel file using Python?
Given that an Excel file contains some cells protected with passwords, I want to detect these protected cells to choose whether to include them in the inputs or skip them. I have tried pandas and openpyxl However, the protected cells are read normally like other unprotected cells and could be easily changed. …
workbook save failing, not sure why
I apologize for the length of this. I am a relative Neophyte to Excel VBA and even more junior with Python. I have run into an issue with an error that occasionally occurs in python using OpenPyXl (just trying that for the first time). Background: I have a series of python scripts (12) running and querying an…
How can I write to specific Excel columns using openpyxl?
I’m writing a Python script that needs to write collections of data down specific columns in an Excel document. More specifically, I’m calling an API that returns a list of items. Each item in the list contains multiple fields of data (item name, item version, etc). I would like to iterate through…
How do I go about incrementally adding data using openpyxl?
I have a folder full of PDFs which I have parsed using Apache Tika, and I have a template excel file which I use to gather specific information from those PDFs and store using openpyxl. The issue I am having is looping through using openpyxl rows. For example, if there is just one PDF in folder, the values go…
Export sheets from excel with given names and save them to new excel files
Is it possible to export multiple excel sheets having the same naming attribute to new excel file ? For example I have excel file named ONTO.xlsx and this file has 4 sheets: Classification ClassificationTypeAllowed BizHierarchy BizHierarchyType I want to export from ONTO.xlsx every sheet with Classification i…
Make a lists of list with excel values and sort by sheets
I would like to make a lists of list with excel values. I have multiple excel sheets where there is always 1 same data,and i want to put the datas into lists. Here is an example: In the Sheet1 these are the datas: And at the Sheet2 these are the datas: In my code i find the 1Data and after
Remove Automatic Page Breaks in Openpyxl
I am using openpyxl in Python to write to a worksheet. I need to add page breaks to specific rows. I am able to successfully add those row breaks using this block of code: However, I cannot seem to get rid of the automatic page breaks that Excel creates, leaving me with a bunch of unnecessary pages on my work…
How to delete rows in Excel if cells in specific column are blank using python openpyxl?
I am a Python beginner (and also new to Stack Overflow) and I’ve recently discovered openpyxl which has been a lifesaver, but I cannot solve the following issue. I have a spreadsheet with data in columns A-I. The spreadsheet is a course-completion report which tells me if customers have completed a part…