Python中使用pandas实现excel的读取和写入

import pandas as pd


def read_file():
    file_path = r'C:\test_excel.xlsx'
    data_file = pd.read_excel(file_path)
    for index, row in data_file.iterrows():
        print(index)
        print(row["columnA"])
    pass


def export_to_excel():
    final_list = [["a", "b"], ["c", "d"]]
    output_file = r'C:\test_excel.xlsx'
    title_list = ['columnA', 'columnB']
    title_tup = tuple(title_list)
    res = pd.DataFrame(columns=title_tup)
    for i in range(len(final_list)):
        res.loc[i + 1] = final_list[i]
    res.to_excel(output_file, index=False)


if __name__ == '__main__':
    read_file()
    export_to_excel()