Python爬取数据通过pandas生成Excel将数据追加到多个sheet表中

import requests

class Read_Url():

    def find_read(self):
        file_name = 'url.txt'
        with open(file_name) as file_obj:
            import pandas as pd
            with pd.ExcelWriter(r"省公司新闻公告-2022.11.15.xlsx") as writer:
                for index,content in enumerate(file_obj):
                    content = content.strip('\n')
                    print(content)
                    json_data = requests.get(content)
                    data = json_data.json().get('cData').get('list')
                    # 循环遍历每一条内容
                    rows = [[row.get('detail_href'),row.get('noticeTitle'),row.get('publishTime')] for row in data]
                    dataframe = pd.DataFrame(rows, columns=["链接", "标题", "日期"])
                    dataframe.to_excel(writer, sheet_name="sheet" + str(index), index=False,engine="openpyxl")

if __name__ == '__main__':
    el = Read_Url()
    el.find_read()