Questions tagged [openpyxl]
Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
openpyxl
5,629
questions
1
vote
0
answers
10
views
Issue with openpyxl version 3.1.4: X and Y axis labels not displaying in Excel chart (It works with the version 3.1.2)
Title: Issue with openpyxl version 3.1.4: X and Y axis labels not displaying in Excel chart
Description
I encountered an issue with the openpyxl library where values on the X and Y axes are not ...
-4
votes
0
answers
22
views
Using "openpyxl" Excel lib. With Python [closed]
Currently I am Using openpyxl Lib with Python to Generate and customize Reports as a task for my job, for a small scale it works fine,
but when dealing with lots of Rows and Columns and more sheets or ...
0
votes
1
answer
20
views
openpyxl Scatter plot w/ flitted x/y axis
starting from the example at:
https://openpyxl.readthedocs.io/en/stable/charts/scatter.html#scatter-charts
original scatter plot](https://i.sstatic.net/82ypMpIT.png)
I would like to generate this plot ...
0
votes
0
answers
39
views
openpyxl workbook.save(file_path) corrupting .xlsx file
I am trying to write a python file to do some .xlsx file editing. I am having some success with that. When saving and closing the .xlsx file I am getting errors when opening the saved file using ...
0
votes
2
answers
65
views
I have a problem with removed records in Excel using Openpyxl
Today at work, I decided to use Openpyxl for the first time so that my colleagues don't have to do manual work filling out Excel spreadsheets.
The code I wrote works fine, but when I try to insert the ...
0
votes
0
answers
35
views
y-axis numbers not displaying in openpyxl graph output
Y-axis does not display in a graph I am outputting from openpyxl using a python script node in KNIME. Here is the code that creates and saves the graph.
chart = LineChart()
...
-3
votes
0
answers
33
views
Return cell reference number from Excel sheet using Python and openpyxl
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: ...
0
votes
1
answer
44
views
List index out of range (openpyxl) - writing to a document
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.
Here is a brief ...
0
votes
0
answers
35
views
Openpyxl insert_rows; Mismatch of content and format [duplicate]
I have an Excel file with a worksheet where I want to insert a new row in 6th row (see image 1).
Wanted
If I directly open Excel app and right-click on the 6th row and select “insert”, it will insert ...
-1
votes
1
answer
69
views
Scrape images into an excel file - Selenium/Pandas/Python [closed]
I'm looking to scrape an image from a website into an excel file.
Below is a snippet of my code. This gets the SRC URL and put that into the excel sheet. Is it possible to turn that into the actual ...
-1
votes
0
answers
52
views
Python warning: Expected Collection.Iterable, got 'cell' instead
Given the following code, I got the warning in the title for the part for cell in row:. Why? And how to fix, please? Note that the code can run through. Thanks.
from openpyxl import load_workbook
wb = ...
0
votes
0
answers
44
views
Python Automation: Loop not working properly
Thank you all for your generous help. I am still new to programming and I have some trouble automating data entry from Excel sheet to a third-party software.
For the excel sheet, it is very straight ...
0
votes
0
answers
48
views
How can I look in a column of a spreadsheet for a string and put into another column, if another one is found then paste that into a different column
I have a Spreadsheet with a notes column "M" that I want to search through row by row and if anything is found in my dictionary then paste it into column "I" and clear column "...
-2
votes
0
answers
62
views
Using Pandas or Openpyxl to put data from a table into a variable
Im looking to be able to put the data from an excel file into one variable
The excel file wont always have the same amount of rows of data, but the columns will stay the same
This is what i believe ...
0
votes
1
answer
46
views
aiogram download excel file to user as a file
I have a little project which is automate work task with telegram.
I use aiogram 3.5 version
I need upload excel file, which contains several sheets as a dict , sheet names as a dict keys, ...