Skip to content

Releases: DeepSpace2/StyleFrame

4.2

13 Nov 19:19
26a2b9c
Compare
Choose a tag to compare

4.2

  • Added Python 3.10 support
  • Added ability to set individual borders' type via the border_type argument
    when creating a Styler object
  • Fixes GitHub issue #108 - Styling and exporting a dataframe that
    contains a column called "index"
  • Fixes error when attempting to use best_fit argument in StyleFrame.to_excel
    on an empty dataframe GitHub PR #157

4.1

15 Jun 12:48
c8a1117
Compare
Choose a tag to compare
4.1
  • Added strikethrough and italic to Styler
  • Raising TypeError in to_excel if trying to use a non-openpyxl engine
  • Exposing Exposing StyleFrame.ExcelWriter and StyleFrame.read_excel to the module-level (styleframe.ExcelWriter
    and styleframe.read_excel) to more closely mimic pandas' API
  • Fixes GitHub issue #124 - Improved calculation of color luminosity from tint

4.0.0

09 Apr 10:16
Compare
Choose a tag to compare
  • Removed Python 3.4 support
  • Removed Python 3.5 support
  • Added Python 3.9 support
  • Allowing StyleFrame.ExcelWriter to accept any argument (except for engine) that pandas.ExcelWriter accepts
  • Allowing customizing formats of date, time and datetime objects when creating Styler instances
  • Fixed rows mis-alignment issue when calling to_excel with header=False (GitHub issue #88)
  • read_excel does not accept sheetname argument anymore (was deprecated since version 1.6). Use sheet_name instead.

3.0.6

26 Jan 21:40
Compare
Choose a tag to compare
  • Fixes github issue #94 - Passing border_type=utils.borders.default_grid to Styler

3.0.5

25 Aug 11:52
Compare
Choose a tag to compare
  • Fixes github issue #81 - read excel as template headers height

3.0.4

18 Aug 20:29
Compare
Choose a tag to compare
  • Fixed style "shifts" when using read_style=True and header=None with StyleFrame.read_excel. Fixes github issue #80

3.0.3

09 Aug 18:37
Compare
Choose a tag to compare
  • No longer relying on openpyxl's colors definition. Related to github issue #73

3.0.1

09 Jun 16:15
Compare
Choose a tag to compare
  • Removed Python 2.7 support

  • Added Python 3.8 support

  • Renamed package name to styleframe (all lowercase) in accordance of PEP8

  • Added .style accessor. This allows for easy selection/indexing based on style, for example:
    sf.loc[sf['col_name'].style.bg_color == utils.colors.yellow]

    or

    sf.loc[~sf['col_name'].style.bold]

  • Added default_grid to utils.borders to allow usage of the default spreadsheet grid

  • Added read_excel_as_template method

  • Fixed a bug that prevented saving if read_excel was used with use_openpxl_style=True, see github issue #67

  • Allowing usage of pathlib.Path in to_excel, see github issue #69

  • Added ability to execute the tests from the commandline: styleframe --test

2.0.5

29 Oct 17:36
5f37a77
Compare
Choose a tag to compare
  • style_alternate_rows can accept all arguments that apply_style_by_indexes accepts as kwargs.
  • Added cols_to_style argument to apply_headers_style

2.0.4

18 Jun 17:53
Compare
Choose a tag to compare
  • Fixed a bug that caused apply_style_by_indexes not to work in case the dataframe had non-integer indexes in some cases
  • Added support for text rotation

Also includes the following changes from non-tagged releases:

2.0.3

  • Fixing pandas dependency for different Python versions, related to #52, #53

2.0.2

  • Fixed a "'column' is out of columns range" error when settings a column's width if dataframe has more than 26 columns.