have a 1 GB excel sheet with xls format (old excel), and I can’t read it with pandas df = pd.read_excel("filelocation/filename.xls",engine = "xlrd") XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'<html>\r\n’ and if removed the engine it sends this error ValueError: Excel file format cannot be determined, you must specify an engine… Read More Python Pandas can't read .xls file though engine is xlrd
In writing dataframe to Excel spreadsheet, I want the file to have no border on the first row and column width to be auto adjusted. With the old package xlwt and xlrd, I can read the file from Pandas produced, to a new file with no border on the header. But it’s .xls (not .xlsx)… Read More Dataframe to Excel, with no border formatting, and auto column width
I’ve been following this answer : How do I extract data from multiple text files to Excel for merging multiple .txt files to one .xlsx spreadsheet, but this answer is giving me the data in multiple worksheets with no distinct column names. What I’m trying to do is to extract the data of 3 .txt… Read More merging multiple .txt files into one .xlsx having different column names