我认为目前无法通过Pandas API传递XlsxWriter构造函数选项,但是您可以strings_to_url
按照以下方法解决此问题:
import pandas as pd
df = pd.DataFrame({'Data': ['http://python.org']})
# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')
# Don't convert url-like strings to urls.
writer.book.strings_to_urls = False
# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')
# Close the Pandas Excel writer and output the Excel file.
writer.save()
:在最新版本的Pandas中,您可以ExcelWriter()
直接将XlsxWriter构造函数选项传递给,而无需writer.book.strings_to_urls
间接设置:
writer = pd.ExcelWriter('pandas_simple.xlsx',
engine='xlsxwriter',
options={'strings_to_urls': False})