报错:.....since it exceeds Excel's limit of 65,530 URLS per worksheet.warn("Ignoring URL '%s' since it exceeds Excel's limit of
原因:使用pandas处理excel表格时,因为excel单个工作表限制URL类型数据量为65530,超出则报错。
解决:将参数strings_to_urls自动转换功能关闭。即,options={'strings_to_urls': False}
with pd.ExcelWriter('xxxx.xlsx',engine='xlsxwriter',options={'strings_to_urls': False}) as writer:
df_all.to_excel(writer, index=False)