返回范围内所有单元格地址的列表

我在列表（例如）中有一个范围列表（通过openpyxl从Excel工作簿加载rng_list = ['$A$1:$A$3', '$B$1:$B$3', '$C$1:$C$3']），我想将这些范围中的每一个“解包”到列表列表（即unpacked_list = [['$A$1','$A$2','$A$3'], ['$B$1','$B$2','$B$3'], ['$C$1','$C$2','$C$3']]）中的单独列表中。

请参阅下面的代码，了解到目前为止我在Jupyter Notebook中尝试过的内容。关于我为什么会收到以下错误的任何想法？或者，如果您对我可能想从另一个角度解决这个问题有任何想法，将不胜感激！谢谢！

    import os
    from openpyxl import Workbook
    from openpyxl.utils import get_column_letter

    # create temp worksheet
    wb_A = Workbook() 
    sheet_A = wb_A.create_sheet('sheetA')

    # list with Excel ranges as str items in list
    rng_list = ['$A$1:$B$10', '$C$1:$D$10', '$E$1:$F$10']
    temp_list = []
    unpacked_list = []


    for item in rng_list:
        for row in sheet_A(item): # use range from item in rng_list to iterate 
                                    through range in temp worksheet
            for cell in row:
                x = cell.row
                y = cell.column
                addr = get_column_letter(y) + str(x)
                temp_list.append(addr)
            unpacked_list.append(addr)

    # delete temp worksheet
    wb_A.remove(sheet_A)

    unpacked_list

我希望使用列表中的范围str来迭代创建的“虚拟工作表”，该工作表仅用于遍历单元格范围并捕获该范围内的相应单元格地址。我收到以下错误：

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-85-13b28d369550> in <module>
     14 
     15 for item in rng_list:
---> 16     for row in sheet_A(item): # use range from item in rng_list to iterate through range in temp worksheet
     17         for cell in row:
     18             x = cell.row

TypeError: 'Worksheet' object is not callable