openpyxl Logo

Introduction

  • Tutorial
  • Simple usage

Styling

  • Working with styles
  • Working with Rich Text
  • Conditional Formatting

Worksheets

  • Inserting and deleting rows and columns, moving ranges of cells
  • Additional Worksheet Properties
  • Validating cells
  • Worksheet Tables
  • Using filters and sorts
  • Print Settings
  • Pivot Tables
  • Comments
  • Dates and Times
  • Simple Formualae

Workbooks

  • Defined Names
  • Custom Document Properties
  • Protection

Charts

  • Charts

Images

  • Working with Images

Pandas

  • Working with Pandas and NumPy

Performance

  • Optimised Modes
  • Performance

Developers

  • Development
  • openpyxl package
    • Subpackages
      • openpyxl.cell package
      • openpyxl.chart package
      • openpyxl.chartsheet package
      • openpyxl.comments package
      • openpyxl.descriptors package
      • openpyxl.drawing package
      • openpyxl.formatting package
      • openpyxl.packaging package
      • openpyxl.pivot package
      • openpyxl.reader package
      • openpyxl.styles package
      • openpyxl.utils package
        • Submodules
      • openpyxl.workbook package
      • openpyxl.worksheet package
      • openpyxl.writer package
      • openpyxl.xml package
  • Parsing Formulas

Release Notes

  • 3.1.5 (2024-06-28)
  • 3.1.4 (2024-06-12)
  • 3.1.3 (2024-05-29)
  • 3.1.2 (2023-03-11)
  • 3.1.1 (2023-02-13)
  • 3.1.0 (2023-01-31)
  • 3.0.10 (2022-05-19)
  • 3.0.9 (2021-09-22)
  • 3.0.8 (brown bag)
  • 3.0.7 (2021-03-09)
  • 3.0.6 (2021-01-14)
  • 3.0.5 (2020-08-21)
  • 3.0.4 (2020-06-24)
  • 3.0.3 (2020-01-20)
  • 3.0.2 (2019-11-25)
  • 3.0.1 (2019-11-14)
  • 3.0.0 (2019-09-25)
  • 2.6.4 (2019-09-25)
  • 2.6.3 (2019-08-19)
  • 2.6.2 (2019-03-29)
  • 2.6.1 (2019-03-04)
  • 2.6.0 (2019-02-06)
  • 2.6.-b1 (2019-01-08)
  • 2.6-a1 (2018-11-21)
  • 2.5.14 (2019-01-23)
  • 2.5.13 (brown bag)
  • 2.5.12 (2018-11-29)
  • 2.5.11 (2018-11-21)
  • 2.5.10 (2018-11-13)
  • 2.5.9 (2018-10-19)
  • 2.5.8 (2018-09-25)
  • 2.5.7 (2018-09-13)
  • 2.5.6 (2018-08-30)
  • 2.5.5 (2018-08-04)
  • 2.5.4 (2018-06-07)
  • 2.5.3 (2018-04-18)
  • 2.5.2 (2018-04-06)
  • 2.5.1 (2018-03-12)
  • 2.5.0 (2018-01-24)
  • 2.5.0-b2 (2018-01-19)
  • 2.5.0-b1 (2017-10-19)
  • 2.5.0-a3 (2017-08-14)
  • 2.5.0-a2 (2017-06-25)
  • 2.5.0-a1 (2017-05-30)
  • 2.4.11 (2018-01-24)
  • 2.4.10 (2018-01-19)
  • 2.4.9 (2017-10-19)
  • 2.4.8 (2017-05-30)
  • 2.4.7 (2017-04-24)
  • 2.4.6 (2017-04-14)
  • 2.4.5 (2017-03-07)
  • 2.4.4 (2017-02-23)
  • 2.4.3 (unreleased)
  • 2.4.2 (2017-01-31)
  • 2.4.1 (2016-11-23)
  • 2.4.0 (2016-09-15)
  • 2.4.0-b1 (2016-06-08)
  • 2.4.0-a1 (2016-04-11)
  • 2.3.5 (2016-04-11)
  • 2.3.4 (2016-03-16)
  • 2.3.3 (2016-01-18)
  • 2.3.2 (2015-12-07)
  • 2.3.1 (2015-11-20)
  • 2.3.0 (2015-10-20)
  • 2.3.0-b2 (2015-09-04)
  • 2.3.0-b1 (2015-06-29)
  • 2.2.6 (unreleased)
  • 2.2.5 (2015-06-29)
  • 2.2.4 (2015-06-17)
  • 2.2.3 (2015-05-26)
  • 2.2.2 (2015-04-28)
  • 2.2.1 (2015-03-31)
  • 2.2.0 (2015-03-11)
  • 2.2.0-b1 (2015-02-18)
  • 2.1.5 (2015-02-18)
  • 2.1.4 (2014-12-16)
  • 2.1.3 (2014-12-09)
  • 2.1.2 (2014-10-23)
  • 2.1.1 (2014-10-08)
  • 2.1.0 (2014-09-21)
  • 2.0.5 (2014-08-08)
  • 2.0.4 (2014-06-25)
  • 2.0.3 (2014-05-22)
  • 2.0.2 (2014-05-13)
  • 2.0.1 (2014-05-13) brown bag
  • 2.0.0 (2014-05-13) brown bag
  • 1.8.6 (2014-05-05)
  • 1.8.5 (2014-03-25)
  • 1.8.4 (2014-02-25)
  • 1.8.3 (2014-02-09)
  • 1.8.2 (2014-01-17)
  • 1.8.1 (2014-01-14)
  • 1.8.0 (2014-01-08)
  • 1.7.0 (2013-10-31)
openpyxl
  • openpyxl package
  • openpyxl.utils package
  • View page source

openpyxl.utils package

Submodules

  • openpyxl.utils.bound_dictionary module
    • BoundDictionary
  • openpyxl.utils.cell module
    • absolute_coordinate()
    • cols_from_range()
    • column_index_from_string()
    • coordinate_from_string()
    • coordinate_to_tuple()
    • get_column_interval()
    • get_column_letter()
    • quote_sheetname()
    • range_boundaries()
    • range_to_tuple()
    • rows_from_range()
  • openpyxl.utils.dataframe module
    • dataframe_to_rows()
    • expand_index()
  • openpyxl.utils.datetime module
    • days_to_time()
    • from_ISO8601()
    • from_excel()
    • time_to_days()
    • timedelta_to_days()
    • to_ISO8601()
    • to_excel()
  • openpyxl.utils.escape module
    • escape()
    • unescape()
  • openpyxl.utils.exceptions module
    • CellCoordinatesException
    • IllegalCharacterError
    • InvalidFileException
    • NamedRangeException
    • ReadOnlyWorkbookException
    • SheetTitleException
    • WorkbookAlreadySaved
  • openpyxl.utils.indexed_list module
    • IndexedList
      • IndexedList.add()
      • IndexedList.append()
      • IndexedList.index()
  • openpyxl.utils.inference module
    • cast_numeric()
    • cast_percentage()
    • cast_time()
  • openpyxl.utils.protection module
    • hash_password()
  • openpyxl.utils.units module
    • DEFAULT_HEADER
    • EMU_to_cm()
    • EMU_to_inch()
    • EMU_to_pixels()
    • angle_to_degrees()
    • cm_to_EMU()
    • cm_to_dxa()
    • degrees_to_angle()
    • dxa_to_cm()
    • dxa_to_inch()
    • inch_to_EMU()
    • inch_to_dxa()
    • pixels_to_EMU()
    • pixels_to_points()
    • points_to_pixels()
    • short_color()
Previous Next

© Copyright 2010 - 2025, See AUTHORS.

Built with Sphinx using a theme provided by Read the Docs.