A
A
Andrey Ivanov2020-09-16 20:12:50
Python
Andrey Ivanov, 2020-09-16 20:12:50

Are there python libraries to read all text from excel document??

Good day. I hope for the help of experts))

Tell me if there is a Python library that allows you to completely read the text from the WHOLE Excel document or one of its pages ??
That is, without referring to a specific sheet and a specific cell, following the example of the openpyxl library.
So that the result is similar to simply opening the file:

with open ('example.csv', 'r') as file:
    print (file.read())

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Artem, 2020-09-17
@ulkoart

There is an openpyxl library ( dock ), you can open a document in it and read values ​​in the range from the beginning to the max row / column.

P
PavelMos, 2020-09-16
@PavelMos

Excel reads cells, not text. All excel sheets can be read at once, for example, pandas.read_excel(.. and then iterate over the sheets.
https://pandas.pydata.org/pandas-docs/stable/refer...
But there are many nuances in how the merged cells will be processed

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question