python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - odf

While parsing .ods file with pandas using read_excel() (and odf), how to drop comments in cells?

I'm trying to parse .ods files with pandas, using pd.read_excel() function, which uses odf under the hood. The problem I face is simple: some cells have comments, and pandas treat them as if they were...
test-img

Clej

python

pandas

ods

odf

Votes: 0

Answers: 1

Latest Answer

It seems like a bug. You may try, instead of read_excel, to use this module: https://pypi.org/project/pandas-ods-reader/
test-img

Liutprand

Python Pandas is removing newlines when importing an ODS file and I want to keep them

Python 3.8.10 Pandas 1.4.1 Hi everyone, I have a spread sheet in ods(odf) format. I am importing this data using pandas and it seems to be removing all newline characters but I want to keep them. This...
test-img

Obsnold

python

pandas

odf

Votes: 0

Answers: 1

Latest Answer

Yeah this seems to be a bug in odfpy used by pandas https://github.com/eea/odfpy/issues/114. If I save the file as xlsx then I have no issues. For the time being I will use xlsx. Here's some code show...
test-img

Obsnold

how to extract the titles of a document .odt in Libreoffice - Python

I have a document in the .odt file, I just want to extract the titles of this document : in other words , I want to extract the "sentenses " or in others words "the "line" whi...
test-img

dkk

python

libreoffice

odf

odfpy

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs