search

dimastbk / python-calamine

Python binding for Rust's library for reading excel and odf file - calamine.
https://pypi.org/project/python-calamine/
MIT License
279 stars 6 forks source link

Colour in excel file and iterrows ? #54

Closed jc77100 closed 9 months ago

jc77100 commented 9 months ago

Hi ,

I would like to know if it would be possible within your library to extract the colour of the excel files (e.g : extract all cells that have highlighted background in colour : '00FFAFAF' ?

Also, i can see another thread about the possibility to use iterrows(), is it something possible now ?

Currently using openpyxl but it's taking ~ 20 sec per file (have a folder with 200+ files) to read all those infos ( i cant use the data mode as it do not support the colour)...

Thanks in advance for your time, Please note that i'm not a software dev.

dimastbk commented 9 months ago

Hi!

I would like to know if it would be possible within your library to extract the colour of the excel files (e.g : extract all cells that have highlighted background in colour : '00FFAFAF' ?

No, calamine (and python-calamine) doesn't support this.

Also, i can see another thread about the possibility to use iterrows(), is it something possible now ?

No, I work on this.