this is my code and my excel sheet has 1000 rows and 22 columns of data. i want to convert excel to text file. but when i run this, i only get first and line 5 rows and columns of data? how to solve this issue import pandas as pd xlsFile = pd.ExcelFile('sample.xlsx') totalPages= xlsFile.sheet_names with open('output.txt','w') as textFile: for page in totalPages: dataFrame = xlsFile.parse(page) textFile.write("\nSheet name is:"+page+"\n") textFile.write(str(dataFrame)) textFile.write('\n') Continue reading...