pandas更改excel的column宽度

追丰少年

已于 2023-10-31 10:45:17 修改

阅读量893

点赞数

分类专栏： Pandas数据分析文章标签： pandas excel

于 2023-10-31 10:44:47 首次发布

本文链接：https://blog.csdn.net/Ghjkku/article/details/134135288

版权

Pandas数据分析专栏收录该内容

53 篇文章 10 订阅

订阅专栏

	df = pd.DataFrame(data=valuesDict,index=[0])

    # Create a Pandas Excel writer using XlsxWriter as the engine.
    writer = pd.ExcelWriter(os.path.join(ios_inspection_excel_file, file[:-4]) + '.xlsx', engine='xlsxwriter')
    # Convert the dataframe to an XlsxWriter Excel object.
    df.to_excel(writer, sheet_name='Sheet1')
    # Get the xlsxwriter worksheet object.
    worksheet = writer.sheets['Sheet1']
    # Set the column width and format.
    worksheet.set_column("B:Z", 25) # 在这里更改宽度值
    # Close the Pandas Excel writer and output the Excel file.
    writer.save()