Most voted "openpyxl" questions
9 questions
Sort by count of
-
4
votes0
answers47
viewsHow to format a cell number in excel for hours type through Openpyxl (Python)?
Whoa, you guys are fine? So, I’m developing a Python test API that when it’s called, it has to return me an Excel file with pre-defined data. One of these data is a time variable that must be…
-
2
votes1
answer223
viewsWorking with sheet dates
Guys, I’m looking for data in a spreadsheet using python, and in one of the worksheets it contains only dates. The problem is that when I look for these dates they come in the form of tuples that…
-
0
votes1
answer170
viewsImportarror: No module named 'openpyxl'...python Raspberry...appears this error in Raspberry on my micro works well...what can it be?
I made a small program in python in my note to use with Raspberry, tested and worked well.... when step pro Raspberry it does not find the file openpyxl...has installed the openpyxl in Raspberry by…
-
-1
votes1
answer73
viewsEliminate radar chart caption created with the openpyxl module in Python
would like to be able to delete the chart caption generated in excel by the Pyhton program using the openpyxl module below: from openpyxl import workbook from openpyxl import load_workbook from…
-
-1
votes1
answer848
viewsGet value from an Excel cell with Openpyxl (Python)
I have a spreadsheet in Excel that I am analyzing some data, and when I do this loop, the returned value is a string, like '=AL35/AH35' for example, instead of a float. This set of cells I’m…
-
-1
votes3
answers384
viewsDownload spreadsheet with Openpyxl
I’m struggling to resolve this issue. I’ve done a lot of research and haven’t found a solution to the problem yet. In Python, I use the Openpyxl library to generate a simple spreadsheet in Excel.…
-
-1
votes1
answer32
viewsHow to delete lines in openpyxl with conditions?
I’m trying to delete lines that have data repeated this way: nome = sheet['I2'].value for coluna in sheet.iter_cols(min_col=9, max_col=9, min_row=3): for celula in coluna: if celula.value == nome:…
-
-1
votes0
answers23
viewsIt is possible to make a system that when you press a button adds one more in excel
I am making a system in Python for a bakery at each sale the user clicks on the button and adds one in a certain cell in an excel spreadsheet, I wanted to know how does this system add another…
-
-2
votes1
answer181
viewsLoad a variable from a file with module. Django/Python
Hello, my name is Marvin, I’m a beginner in the area and I have a problem giving a 'POST' a 'file.py' variable to my local server Django. I use a module called 'openpyxl' that serves to load a table…