openpyxl.utils package

Subpackages

• openpyxl.utils.tests package
  • Submodules
    • openpyxl.utils.tests.test_bound_dictionary module
      • BoundDictionary()
      • test_coupling()
      • test_ctor()
    • openpyxl.utils.tests.test_cell module
      • test_absolute()
      • test_bad_column_index()
      • test_bounds()
      • test_cols_from_range()
      • test_column_index()
      • test_column_interval()
      • test_column_letter()
      • test_column_letter_boundries()
      • test_coordinate_tuple()
      • test_coordinates()
      • test_invalid_bounds()
      • test_invalid_coordinate()
      • test_invalid_range()
      • test_quote_sheetname()
      • test_range_to_tuple()
      • test_rows_from_range()
    • openpyxl.utils.tests.test_dataframe module
      • sample_data()
      • test_dataframe()
      • test_dataframe_categorical()
      • test_dataframe_header()
      • test_dataframe_index()
      • test_dataframe_multiindex()
      • test_expand_index_vertically()
      • test_expand_levels_horizontally()
    • openpyxl.utils.tests.test_datetime module
      • test_days_to_time()
      • test_from_excel()
      • test_from_excel_mac()
      • test_from_excel_timedelta()
      • test_from_iso()
      • test_iso_regex()
      • test_time_to_days()
      • test_timedelta_to_days()
      • test_to_excel()
      • test_to_excel_mac()
      • test_to_iso()
    • openpyxl.utils.tests.test_escape module
      • test_escape()
      • test_unescape()
    • openpyxl.utils.tests.test_formulas module
      • TestValidate
    • openpyxl.utils.tests.test_indexed_list module
      • list()
      • test_allow_duplicate_ctor()
      • test_contains()
      • test_ctor()
      • test_function()
      • test_index()
      • test_table_builder()
    • openpyxl.utils.tests.test_inference module
      • test_cast_numeric()
      • test_cast_percent()
      • test_infer_datetime()
      • test_time_regex()
    • openpyxl.utils.tests.test_protection module
      • test_password()
    • openpyxl.utils.tests.test_units module
      • test_EMU_to_cm()
      • test_EMU_to_inch()
      • test_EMU_to_pixels()
      • test_angle_to_degrees()
      • test_cm_to_EMU()
      • test_cm_to_dxa()
      • test_degrees_to_angle()
      • test_dxa_to_cm()
      • test_dxa_to_inch()
      • test_inch_to_EMU()
      • test_inch_to_dxa()
      • test_pixels_to_EMU()
      • test_pixels_to_points()
      • test_points_to_pixels()
      • test_short_color()

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.formulas module
  • validate()
• 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()