怎么在此代码基础设置列宽啊，就得到的excel表跟图片一样

Question

import requests
import json
import pandas as pd

url = "https://www.chinamoney.com.cn/ags/ms/cm-u-md-bond/CbtPri"

resp = requests.get(url=url)

res = resp.content.decode("utf-8")

datas = json.loads(res)

df = pd.DataFrame(datas['records'][:231])

df_saved = df[['abdAssetEncdShrtDesc', 'dmiLatestRate', 'dmiLatestContraRateLabel', 'dmiWghtdContraRateLabel']]

df_saved.columns = ['简称', '成交净价', ' 最新收益率', ' 加权收益率']

pd.set_option('display.unicode.ambiguous_as_wide', True)
pd.set_option('display.unicode.east_asian_width', True)

df_saved.to_excel("债券数据.xlsx", encoding='utf-8', index=None)
print('over!')

Answer 1

https://cloud.tencent.com/developer/article/1420752