如何解决Excel的URL限制? [英] How can I get around Excel's URL Limitation?

问题描述

我正在使用出色的xlsxwriter用Python构建电子表格.我意识到问题，您只能在其中写入40k左右的URL表格开始警告之前，功能已关闭.

I'm using the excellent xlsxwriter to build spreadsheets with Python. I've become aware of the issue where you can only write 40k or so URLS to a sheet before you start getting warned and the functionality is gated.

是否有一种将URL编写为字符串的方式，使得Excel应用程序在打开时不会将url解释为字符串(因此允许我 添加无限的网址)?我知道这些URL是不可点击的，但对我而言，总比没有好.

Is there a way to write the urls as strings in such a way that the Excel application will not interpret the url as a string on open (and therefore allow me to add unlimited urls)? I get that those URLs won't be clickable, but it's better than nothing in this case for me.

推荐答案

Excel的限制为每个工作表网址约65k. XlsxWriter会发出警告.

Excel's limit is around 65k urls per worksheet. XlsxWriter warns if you exceed that.

是否有一种将URL编写为字符串的方式，使得Excel应用程序在打开时不会将URL解释为字符串(因此允许我添加无限的URL)

Is there a way to write the urls as strings in such a way that the Excel application will not interpret the url as a string on open (and therefore allow me to add unlimited urls)

XlsxWriter具有构造函数选项，用于将字符串转换为网址:

XlsxWriter has a constructor option to turn off conversion of strings to urls:

workbook = xlsxwriter.Workbook(filename, {'strings_to_urls': False})

这篇关于如何解决Excel的URL限制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！