pycode0019

from openpyxl import load_workbook
from case0017 import dumpxml
def (path, wbname):
    """
    载入xlsx文件内容
    :param path: 文件路径
    :param wbname: wb名称
    :return: 返回文件内容（dict）
    """
    wb = load_workbook(filename=path)
    ws = wb[wbname]
    content = []
    for i in range(0, 3):
        temp = []
        for j in range(0, 3):
            temp.append(ws.cell(row=i + 1, column=j+1).value)
        content.append(temp)
    return content
if __name__ == '__main__':
    path = 'resource/number.xlsx'
    wbname = 'number'
    content = loadxlsx(path, wbname)
    comment = 'nt数字信息nt'
    element = 'numbers'
    output = 'resource/number.xml'
    dumpxml(content, comment, element, output)