CODEWITHSUNDEEP
pythonexcelpandas
Coraline
Coraline

Reputation: 59

Get all bold words from excel column with Pandas

Is it possible to get words that are bold in the excel fields when using Pandas function pd.read_excel for reading the file?

I get all rows with function df.itertuples().

I want in each row to get all words that are bold in the second column. Is this possible?

Upvotes: 0

Views: 1558

Answers (1)

Constantine Mok
Constantine Mok

Reputation: 29

You would need additional package.

from styleframe import StyleFrame

df = StyleFrame.read_excel('test.xlsx', read_style=True, use_openpyxl_styles=False)

for text in df["Colname"]: # replace Colname
    if text.style.bold:
        print(text)

reference StyleFrame

Upvotes: 1

Related Questions