Read from excel using StyleFrame

Question

sf = sf[[col for col in sf.columns
         if col.style.fill.fgColor.rgb in ('FFFFFFFF', utils.colors.white)]]

I got an error when read the file and looping the columns

return object.__getattribute__(self, name)
AttributeError: 'Series' object has no attribute 'columns'

I want to read the excel without loosing the style values

Can you please provide the output of `import StyleFrame ; print(StyleFrame._versions_)` ? — DeepSpace, Feb 22 '18 at 17:50
Python 2.7 (r27:82525, Jul 4 2010, 09:01:59) [MSC v.1500 32 bit (Intel)] pandas 0.19.0 openpyxl 2.2.5 StyleFrame 1.3.1 — Suresh K, Mar 03 '18 at 13:30
@SureshK Thanks, finally managed to reproduce. See my answer. — DeepSpace, Mar 04 '18 at 18:13
@DeepSpace Thank you so much. I will check and let you know soon — Suresh K, Mar 05 '18 at 07:06

score 2 · Accepted Answer · answered Feb 22 '18 at 12:34

That's a bug in StyleFrame that is caused by the fact that [col for col in sf.columns if col.style.fill.fgColor.rgb in ('FFFFFFFF', utils.colors.white)] returns an empty list (ie, the condition is False for every column).

This will be fixed in the next version.

A temporary workaround:

required_cols = [col for col in sf.columns
                 if col.style.fill.fgColor.rgb in ('FFFFFFFF', utils.colors.white)]
sf = sf[required_cols] if required_cols else StyleFrame(pd.DataFrame(columns=sf.columns))

Read from excel using StyleFrame

1 Answers1