Speeding up the saving excel process while using Styleframe

Asked Feb 27 '20 at 07:43

Active Feb 27 '20 at 07:43

Viewed 163 times

I am using StyleFrame's to_excel function to save the dataframe df in .xlsx file. Below is my code which works fine:

 import pandas as pd
 from StyleFrame import StyleFrame, Styler

 bgStyle = Styler(bg_color='yellow')
 sf = StyleFrame(df)
 sf.apply_style_by_indexes([1,2], styler_obj=bgStyle, overwrite_default_style=False)

 sf.to_excel('output.xlsx').save()

Since my dataframe is big , so to speed up the writing and saving process , I want to use engine='xlsxwriter' but StyleFrame's to_excel function doesnt have engine as a parameter.

So how can I speed up the process of writing and saving df into .xlsx while using Styleframe for styling?

asked Feb 27 '20 at 07:43

Anudocs

How big is your dataframe? styleframe is indeed not the fastest, since it needs to iterate over every single cell in order to apply the correct style. `engine` is not a parameter since only openpyxl is supported. – DeepSpace Feb 27 '20 at 07:55
my dataframe can have upto 100,000 rows and 10 columns. – Anudocs Feb 27 '20 at 08:09
Do you have any plan to add engine has parameter in near future? – Anudocs Feb 27 '20 at 08:12
1

Not at the moment, but I'm always open to pull requests on github ;) – DeepSpace Feb 27 '20 at 08:58
Are any updates available? – Mare Seestern Apr 10 '22 at 08:28

Speeding up the saving excel process while using Styleframe

0 Answers0