Why not show the index when I save sf to excel?

[boh5]

• Python == 3.7
• StyleFrame == 2.0.5
• pandas == 0.25.3
• openpyxl == 3.0.2

My code shows below, I tried to save sf to excel file, but lost the index in excel.

ew = StyleFrame.ExcelWriter(filepath + '/' + filename + '-result' + extension)
sf.to_excel(ew, best_fit=sf.columns.to_list())
ew.save()

THX

[DeepSpace2]

The index will be shown if index=True is passed to to_excel:

sf.to_excel(ew, best_fit=sf.columns.to_list(), index=True)

[TimurDela]

This information is missing from the API documentation.

Is there any way to make it work for multi indexes?

[DeepSpace2]

@TimurDela Hi, the documentation for StyleFrame.to_excel mentions

to_excel also accepts all arguments that pandas.DataFrame.to_excel accepts as kwargs

As per your question, no. styleframe does not support multi-index at the moment. A multiindex will be "squashed" to a single-level index by

StyleFrame/styleframe/style_frame.py

Lines 58 to 59 in da61d62

	self.data_df.index = [Container(index, deepcopy(styler_obj)) if not isinstance(index, Container) else deepcopy(index)
	for index in self.data_df.index]