Im making a website and i want to be able to import employees with an excel file, so im trying to make it so that there is a dropdown with all the departments. Assume you get all the department names with Department.get_all_departments(), how can i make the excel file have a dropdown field with those names using python?

I’ve been trying to unfreeze the first 2 rows and first column with openpyxl, however, when opening the file using Excel, I would get a message stating that Excel found some problem with some content in the file, and if I want to recover as much as they can. When I recover the contents of the file, it appears that the pane is not frozen anymore, even though that pop-up appeared.

Problem I’m trying to get each page of “Page Break Preview”. Precisely speaking, I need to know which cells Page 1 contains, which cells Page 2 contains and so on. Could you teach me how to realize this functionality in Python 3.12? I tried openpyxl, but other libraries are welcome too. Example (What I Tried) […]

I’m appending data to an existing, pre-formatted Excel Template. The problem is, depending on user input the data size could vary and could overflow beyond the available cells of the template. Is there a way to make it so that if the data size is larger than, let’s say 8 entries, a new sheet is appended to the previous one and data is added to the new sheet, then it’s all combined into a PDF in the end? The only part I’m having trouble with is how to make it so that Python keeps multiple instances of the sheet open at the same time and only as much as needed.
I’m using Openpyxl and this is the code that I currently use that handles one excel sheet only up to 8 rows

I am encountering an issue with a Python script that writes to an Excel file. The script works flawlessly on the first run, but any subsequent runs result in an error in the terminal.

I am encountering an issue with a Python script that writes to an Excel file. The script works flawlessly on the first run, but any subsequent runs result in an error in the terminal.

I’m handling a large amount of data in Excel. What I have to do is I want to get the cell reference numbers (e.g. Z3489) that contain a particular numeric value in the selected rows (i.e. e.g. Z3456: Z8976). The numeric value I will enter may lie in many cells in the selected row. How can I execute the above operation?

I have an Excel file where some of the cells got merged and some cells have warp Text with Strike and Non Strike in it.

I’m working on code to delete columns in an Excel sheet, and I’m trying to figure out why columns are not being deleted from my delete_cols function call with openpyxl. Here is the snippet of code I have to do that:

I have several .xlyx sheets that I want to read into a new .xlyx file and add them to separate tabs. Right now, I have manually created tabs for each.