All Questions
2,591
questions
-1
votes
1
answer
35
views
Creating/Updating an excel file with slicers from python
I have some python code which creates a few pandas data frames which I need to put into a spreadsheet, with different data on multiple sheets and with slicers for easy filtering. This then gets sent ...
- 3,144
-2
votes
1
answer
59
views
How to add a Python list to the end of a column in Excel that already has values in it?
I'm currently trying to write a program that appends values to a list and then adds these values to a column in an Excel data sheet. Each time I run the program, I hope to add more values to the end ...
-5
votes
0
answers
33
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
0
answers
42
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
72
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 ...
- 13
0
votes
0
answers
40
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
35
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
51
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 ...
-1
votes
1
answer
72
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 ...
- 29
-1
votes
0
answers
53
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 = ...
- 1,206
-2
votes
0
answers
64
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 ...
- 29
-2
votes
0
answers
32
views
Creating a new sheet within a workbook every time the script is ran with Openpyxl/Pandas - Python [duplicate]
I'd like my script to be able to add an extra sheet in an existing workbook with Openpyxl, and then Pandas to write data into that new sheet.
Below is what i have
file_name = 'Numbers.xlsx'
wb = ...
- 29
-1
votes
2
answers
100
views
Write a new sheet data in workbook with Pandas everytime script is ran
I would like Pandas to create a new sheet in an existing workbook every time the script is ran.
Below is the data that is being written
Is there a way to do this?
df = pd.DataFrame(zip(house_name,...
- 29
1
vote
0
answers
67
views
How to read data validation rules from an excel sheet using Python?
I have a template Excel sheet with some data validation rules that I need to populate with data from another source. I need to read the template Excel sheet with Python and populate the rows and then ...
- 512
-1
votes
1
answer
109
views
How to use openpyxl to insert new row and keep the formatting of the new row as its last row in table?
I have faced an issue of insert new row in the excel file at the same time keeping its formatting/style
I did try to use the openpyxl's insert new row
conv_ws.insert_rows(idx=14,amount=1)
The new row ...
- 9