v0.0.9

We are pleased to announce the release of version 0.0.9. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Notable Features

• Add new Name field in GraphicOptions to support set and get graphic name
• Add new drop_lines and high_low_lines fields in ChartAxis class
• Add 15 new functions:
  • add_header_footer_image
  • add_ignored_errors
  • delete_form_control
  • get_cols
  • get_doc_props
  • get_form_controls
  • get_hyperlink_cells
  • get_page_layout
  • get_page_margins
  • get_pictures
  • get_pivot_tables
  • get_sheet_protection
  • get_sheet_view
  • get_slicers
  • set_col_outline_level (stream writer)

Miscellaneous

• Upgrade the dependencies package version

Thank you

Thanks for all the contributors to Excelize. Below is a list of contributors that have code contributions in this version:

• @yan00353-0729

v0.0.8

We are pleased to announce the release of version 0.0.8. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Notable Features

• Add rows iterator to support stream reader and 14 new functions:
  • get_calc_props
  • get_custom_props
  • join_cell_name
  • rows
  • rows.close
  • rows.columns
  • rows.error
  • rows.get_row_opts
  • rows.next
  • set_calc_props
  • set_cell_default
  • set_cell_float
  • set_custom_props
  • split_cell_name

Bugfix

• Fix get_rows function skip the empty rows, resolved issue #38
• Fix missing function parameter checking for set_cell_bool function
• Made functions set_row, set_sheet_col and set_sheet_row functions accept float data type value

Miscellaneous

• Upgrade the dependencies package version
• Using escape tab control character in the code doc blocks

v0.0.7

We are pleased to announce the release of version 0.0.7. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Notable Features

• Add new function: get_merge_cells
• Support set the data point color for doughnut, pie and 3D pie chart
• Add new ChartDataPoint data type
• Add new field data_point in the ChartSeries data type

Miscellaneous

• Automating dependabot tasks with GitHub Actions
• Upgrade GitHub Action tool chains version

Thank you

Thanks for all the contributors to excelize-py. Below is a list of contributors that have code contributions in this version:

• @tostenzel (Tobias)

v0.0.6

We are pleased to announce the release of version 0.0.6. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Breaking Change

• Rename set_row_outline to set_row_outline_level

Notable Features

• support x86_64 Python build on ARM64 Windows
• Build Linux ARM64 version shared library with glibc 2.17 for more compatibility
• Update build flag to trim path for shared library
• Update GitHub Action, test with Python 3.15.0
• Upgrade the dependencies package version

v0.0.5

We are pleased to announce the release of version 0.0.5. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Breaking Change

• Rename set_row_outline to set_row_outline_level

Notable Features

• There are 9 normal mode functions added in this version
  • get_defined_name
  • get_row_height
  • get_row_outline_level
  • get_sheet_props
  • get_sheet_visible
  • set_app_props
  • unprotect_sheet
  • unprotect_workbook
  • unset_conditional_format
• Add TmpDir field in the Options class
• Add dash and fill fields in the ChartLine class
• Add border field in the ChartMarker class
• Add font field in the ChartLegend class
• Add legend field in the ChartSeries class
• Add 2 new ChartDashType and ChartUpDownBar` class
• Add 2 new fields up_bars and down_bars in the ChartPlotArea type
• Add Transparency field in the Fill class
• Support setting dash line and marker border type of charts
• Support setting dash type of line charts
• Support setting font for chart legends
• Add argument data type checking for functions
• Add 4 stock chart support for add_chart and add_chart_sheet function

Miscellaneous

• Upgrade GitHub Action tool chains version
• Upgrade the Excelize library v2.10.0
• New excelize-py logo

Thank you

Thanks for all the contributors to excelize-py. Below is a list of contributors that have code contributions in this version:

• @JerryLuo-2005
• @xiaoq898
• @Jameshu0513
• @Leopard31415926
• @Laolaowwu
• @Leo012345678
• @Siyet (Tseluyko Alexander)
• @yafei-xie (Oliver)

v0.0.4

We are pleased to announce the release of version 0.0.4. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Notable Features

There are 4 normal mode functions added in this version

• get_col_width
• get_comments
• get_sheet_list
• get_sheet_map

Bug Fixes

• Fix invalid ELF header error on Linux to fix, resolve issue #7

Miscellaneous

• Throw an exception if a error occurs in the function instead of return error
• Add support for working with 32 bits Python on 64 bits Windows

Thank you

Thanks for all the contributors to excelize-py. Below is a list of contributors that have code contributions in this version:

• @hm3248
• @LZCZ
• @crush-wu
• @Now-Shimmer

v0.0.3

We are pleased to announce the release of version 0.0.3. Featured are a handful of new areas of functionality and numerous bug fixes.

A summary of changes is available in the Release Notes.

Release Notes

The most notable changes in this release are:

Notable Features

There are 99 normal mode functions available in this version

• add_chart
• add_chart_sheet
• add_comment
• add_form_control
• add_picture
• add_picture_from_bytes
• add_pivot_table
• add_shape
• add_slicer
• add_sparkline
• add_table
• add_vba_project
• auto_filter
• calc_cell_value
• close
• copy_sheet
• delete_chart
• delete_comment
• delete_defined_name
• delete_picture
• delete_sheet
• delete_slicer
• duplicate_row
• duplicate_row_to
• get_active_sheet_index
• get_app_props
• get_cell_formula
• get_cell_hyperlink
• get_cell_rich_text
• get_cell_style
• get_cell_value
• get_col_outline_level
• get_col_style
• get_col_visible
• get_default_font
• get_row_visible
• get_rows
• get_sheet_dimension
• get_sheet_index
• get_sheet_name
• get_style
• get_tables
• get_workbook_props
• group_sheets
• insert_cols
• insert_page_break
• insert_rows
• merge_cell
• move_sheet
• new_conditional_style
• new_sheet
• new_stream_writer
• new_style
• protect_sheet
• protect_workbook
• remove_col
• remove_page_break
• remove_row
• save
• save_as
• search_sheet
• set_active_sheet
• set_cell_bool
• set_cell_formula
• set_cell_hyperlink
• set_cell_int
• set_cell_rich_text
• set_cell_str
• set_cell_style
• set_cell_value
• set_col_outline_level
• set_col_style
• set_col_visible
• set_col_width
• set_conditional_format
• set_default_font
• set_defined_name
• set_doc_props
• set_header_footer
• set_page_layout
• set_page_margins
• set_panes
• set_row_height
• set_row_outline
• set_row_style
• set_row_visible
• set_sheet_background
• set_sheet_background_from_bytes
• set_sheet_col
• set_sheet_dimension
• set_sheet_name
• set_sheet_props
• set_sheet_row
• set_sheet_view
• set_sheet_visible
• set_workbook_props
• ungroup_sheets
• unmerge_cell
• update_linked_value

7 utility functions

• cell_name_to_coordinates
• column_name_to_number
• column_number_to_name
• coordinates_to_cell_name
• new_file
• open_file
• open_reader

7 streaming mode functions

• add_table
• flush
• insert_page_break
• merge_cell
• set_col_width
• set_panes
• set_row