All Questions
573 questions
-2
votes
1
answer
76
views
XLS Old File Format Python Read Issue
I have an old file format xls file (Microsoft Excel 97-2003 Worksheet)
This file is opening in the excel app without any issues. But when i try to read with python xlrd engine.It throws the below ...
0
votes
1
answer
64
views
Python xlrd: Reading format of each cell values
I am currently working on a data engineering project. At the moment I want to read an Excel file with the extension '.xls' into my Python workspace. This is not a big problem with Pandas. However, I ...
- 3
0
votes
0
answers
311
views
pandas.read_excel() cannot read an .xls file, what is going wrong?
I am using pandas 2.2.0 and xlrd version is 2.0.1. The code snippet
import pandas as pd
filepath = './data/myfile.xls'
df = pd.read_excel(filepath)
generates the following log:
Traceback (most recent ...
- 13
1
vote
1
answer
532
views
Having difficulties to open an old format xls file with python pandas
I have a spreadsheet which is in format of Microsoft Excel 97-2003 xls. I tried following:
import pandas as pd
xlsx_file_path = "C:/temp/a_file.xls"
sheets_dict = pd.read_excel(...
- 177
1
vote
0
answers
450
views
How do I use Python/openpyxl to create collapsible rows/columns in Excel that can be collapsed?
I have a spreadsheet that I created using Python and openpyxl, and I'm trying to create collapsible columns that look like this:
I know which row and column numbers I want to make collapsible. ...
- 35
0
votes
2
answers
798
views
Python solution for iterating through .xls spreadsheet with multiple tabs, deleting rows and first column, and export to csv?
I am extremely frustrated trying to write a code to iterate through a .xls (or .xlsx) spreadsheet where each sheet is a year, editing each sheet to remove rows 1-4,6,and 72-150, remove first column, ...
2
votes
1
answer
499
views
How to loop through column in excel until an empty cell
I have written some python code that loops through an excel sheet and extracts the strings from the cells. I wish the loop to stop once it reaches an empty cell. I can get this to work if I put a ...
- 17
0
votes
2
answers
44
views
How to read a null cell in excel as numeric zero value using xlrd in Python
I'm importing values from different cells and appending them in a column from 50 excel's sheets (timeserie). I need to add them up when reading them, as I just need the aggregated values. But when the ...
0
votes
0
answers
102
views
Convert .xls to .csv using python while preserving trailing zeros
I want to convert my .xls file to .csv with python. In my .xls file, I have decimal values with significant digits that I need to keep. For example, I have values like 27.50 and 45.550, and when I ...
- 1
0
votes
0
answers
66
views
Create inter linked drop-downs in excel files using python
I am working to write python script using xlsxwriter package. I have already written the script but reached at a point where I am unable to move ahead.
Let me explain what I want to achieve:-
I have ...
0
votes
0
answers
183
views
Dealing with Error "found in NAME formula"
I have tons of ".xls" format excel files that haves #NAME error in it.
I need to open each one, collect data from a specific range. but when I try to open it with xlrd I get the following ...
- 1
1
vote
1
answer
633
views
xlrd assertion error when opening a .xls file (converted from .xlsx): assert _unused_i == nstrings - 1
I have a script that uses the xlrd library to read and write .xls files. The program works for most .xls', but I found that after I converted an .xlsx to .xls and try to open the workbook, I get the ...
- 353
2
votes
3
answers
1k
views
Getting coordinates of a certain merged cell
I am trying to get starting and end column of a merged cell in excel -
I am looking to know start and end column number of one row. This code gives me all merged cells in sheet -
from openpyxl import ...
0
votes
0
answers
174
views
Parsing excel sheet in python with no empty spaces if column extends across multiple rows
I am trying to parse an excel sheet in which some columns spread across multiple rows. Here is the sheet -
I am trying to get all the inputs and those start from column E. In the sheet 'human ...
-1
votes
1
answer
175
views
Python Index out of range Error in lib loop issue
everything's fine? I hope so.
I'm dealing with this issue: List index out of range. -
Error message:
c:\Users.....\Documents\t.py:41: FutureWarning: As the xlwt package is no longer maintained, the ...
- 1