All Questions
2,331 questions
1
vote
2
answers
118
views
Update formulas in excel using Python
I am trying to update formulas in an existing excel which has data and tables but I am failing to update the formulas so that they would update the data for example:
Okay since I get some answers but ...
- 55
1
vote
1
answer
75
views
how to read excel merged cell properties value using python?
I need to read data from an Excel file. The first cell contains the property name, and the second cell contains the property value. However, some of the property names in the first column are merged ...
- 5,075
0
votes
1
answer
160
views
Pandas read_excel() not reading all columns
I'm using Python 3.12.6 and pandas==2.2.3.
This is a simple code, that I've always used and always worked to read the first sheet of an excel file:
df = pd.read_excel(file_path, engine='openpyxl', ...
0
votes
2
answers
69
views
How to speed up Python for highlighting cells for an Excel spreadsheet conditionally?
I have the following Python code which tries to color rows of an Excel spreadsheet conditionally upon the values of the columns. Due to the number of rows, the run time is very slow at more than 30 ...
- 2,588
0
votes
0
answers
31
views
Python-based design of experiments applied to excel Sheet [duplicate]
Modify values of an excel sheet containing formulas, and looking at variations of an outcome when some input parameters are modified through a python script
I have an excel sheet (.xlsx) with a lot of ...
- 1
0
votes
0
answers
53
views
Excel with cells empty when I copy and paste into another excel with python
I have a code that copy specific cells from an xlsx and paste in another excel (which was previously xls but saved as xlsx now) with a searching criteria.
The code has to look for the first empty cell ...
- 1
2
votes
1
answer
75
views
Inconsistent font color between openpyxl and the excel rendered version
I need to read an excel file in python and get the font color of one particular cell. I have this column that sometimes contains a red value (font color) that is correctly rendered in excel.
When i ...
- 21
1
vote
1
answer
61
views
how to get excel chart's main title text using python openpyxl library
Using the Python module openpyxl, I'm attempting to obtain the excel chart's main title.
I need your assistance writing the script.
For example, the chart title "Test" is below. I want to ...
- 33
0
votes
1
answer
30
views
openpyxl corrupting xls file after adding new Table to a sheet
I'm currently trying to generate an excel table within a new sheet in a workbook. I'm able to add a new sheet and save it with some random data in a given cell, but when I try to add a new Table, if I ...
- 69
0
votes
1
answer
84
views
Dealing with struck-through and non-struck-through characters using Python on Linux and/or MacOS
I'm looking for an up to date way of determining whether or not text inside an Excel xlsx workbook cell is struck-through using Python on Linux and Mac.
I understand that Openpyxl will determine if a ...
1
vote
1
answer
129
views
Adjusting Python script to add data to Excel table
I’m totally new to Python and I’m banging my head against a wall trying to solve my problem.
I’ve got a table in an Excel file I keep in iCloud Drive to track expenses, and I need to utilize this file ...
- 13
0
votes
0
answers
69
views
Using openpyxl inside excel produces error "File not found" but works fine from Spyder
In my effort to automate the production of worksheets for students everywhere I have run into a snag. I am trying to get Python in Excel (=py) to turn an Excel table into an image and place the image ...
- 49
0
votes
0
answers
54
views
no able to open .xlsx file using openpyxl in VS code . Gives error as shown
PS C:\Users\Asit\Desktop\python> python -u "c:\Users\Asit\Desktop\python\excel_project\excel.py"
Traceback (most recent call last):
File "c:\Users\Asit\Desktop\python\excel_project\...
0
votes
0
answers
48
views
Excel copy and paste values with source formatting using OpenPyxl
Iam trying to copy the sheet from one workbook to another workbook and paste the whole content along with the source formatting. My source sheet has formulas and have to copy only values with source ...
- 11
0
votes
1
answer
77
views
Get absolute hyperlink from excel via python script
I am using openpyxl to process information from a excel spreadsheet. The spreadsheet is in Microsoft sharepoint, when some hyperlink is added into it, if the hyperlink is in the same sharepoint, it ...
- 933