StyleFrame

A library that wraps pandas and openpyxl and allows easy styling of dataframes in excel.

Contents:

• Installation and testing
• Basic Usage Examples
• API Documentation
  • Styler
    • Styler.combine()
    • Styler.to_openpyxl_style()
  • utils
    • number_formats
      • number_formats.decimal_with_num_of_digits()
    • colors
    • fonts
    • borders
    • horizontal_alignments
    • vertical_alignments
    • underline
    • fill_pattern_types
    • conditional_formatting_types
  • StyleFrame
    • StyleFrame
      • StyleFrame.apply_style_by_indexes()
      • StyleFrame.apply_column_style()
      • StyleFrame.apply_headers_style()
      • StyleFrame.style_alternate_rows()
      • StyleFrame.rename()
      • StyleFrame.set_column_width()
      • StyleFrame.set_column_width_dict()
      • StyleFrame.set_row_height()
      • StyleFrame.set_row_height_dict()
      • StyleFrame.add_color_scale_conditional_formatting()
      • StyleFrame.read_excel()
      • StyleFrame.to_excel()
• Commandline Interface
  • General Information
  • Usage
    • Usage Examples
  • JSON Format
    • style
    • cell
    • column
    • sheet