使用xlsxwriter写入数据时，出现字符长度限制

最新推荐文章于 2023-04-21 14:21:11 发布

原创

最新推荐文章于 2023-04-21 14:21:11 发布 · 4.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#xlsxwriter #255

python 使用xlsxwriter写入数据时，出现字符长度限制anchor > 255 ，可修改源码，取消长度限制

with link or location/anchor > 255 characters since it exceeds Excel’s limit for URLS

[2019-05-07 08:48:43] [WARNING] C:\Users\AppData\Local\Programs\Python\Python36-32\lib\site-packages\xlsxwriter\worksheet.py:912: UserWarning: Ignoring URL 'http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_2ebdee54-1d6c-4850-1b14-46db56fb9982.jpg
http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_1ffa3913-b800-39cd-6d06-cfc53c66e20a.jpg
http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_2acae613-d3be-3035-a43e-3ef1825c3457.jpg
http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_ee816e55-ff18-08e0-380d-35ba1c1767f4.jpg
http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_aeb4f129-a737-7f28-d360-72c2f9ce6759.jpg
http://7xlmz4.com1.z0.glb.clouddn.com/data_upload_cook_step_2a360b9c-c023-6347-5fad-e0365b6470dc.jpg
http://7xlmz