我认为目前无法通过Pandas API传递XlsxWriter构造函数选项,但是您可以
strings_to_url按照以下方法解决此问题:
import pandas as pddf = 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})


