[Python] why pandas in python does not return all the rows from excel sheet?

Discussão em 'Python' iniciado por Stack, Fevereiro 22, 2025.

  1. Stack

    Stack Membro Participativo

    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...

Compartilhe esta Página