Excelシートのセル名をPythonで取得する

xls.py

#!/usr/bin/env python3
# -*- coding:utf-8 -*-
# Author: kakakaya, Date: Thu Mar 16 09:35:47 2017
import openpyxl as px


def main():
    wb = px.load_workbook("sheet_with_cell_name.xlsx")
    defined_names = wb.defined_names.definedName
    for defined_name in defined_names:
        for d in defined_name.destinations:
            print("Sheet name: {}, location: {}".format(d[0], d[1]))


if __name__ == "__main__":
    main()