Python Openpyxl错误：引发ValueError("无法将{0！r}转换为Excel")

To display the data you want to use to_excel from Pandas to write the dataframe to the Excel sheet;

import yfinance as yf
import pandas as pd

ticker = yf.Ticker("AAPL")
info = ticker.info

print("industry:", info["industry"])
print("symbol:", info["symbol"])
print("currentprice:", info["currentPrice"])
Option = ticker.option_chain('2023-06-23')

### Dataframe for Header information. Header and infomation 
### Formatted for two rows; row1 Header, row2 Info 
symbol_df = pd.DataFrame({
    'Symbol': [info["symbol"]],
    'Market': [info["industry"]],
    'Last Price': [info["currentPrice"]]
})

### Option.calls is a dataframe
options_df = Option.calls
### Need to fix the lasttradeDate as it contains TZ information
options_df['lastTradeDate'] = options_df['lastTradeDate'].dt.tz_localize(None)

### Write the two dataframes to Excel
### Symbol Info first from row 1, then Options df from row 3
with pd.ExcelWriter("gamm.xlsx") as writer:
    symbol_df.to_excel(writer,
                       sheet_name="Gamm",
                       startrow=0,
                       index=False)
    options_df.to_excel(writer,
                        sheet_name="Gamm",
                        startrow=3,
                        index=False)

Example Output

Note使用的默认引擎是'Openpyxl'，因此不会为数据调整EXCEL列的大小.如果你愿意，你可以切换到xlsxwriter引擎，使用它的autofit()功能来做到这一点.将ExcelWriter部分更改为下面；

...
### Write the two dataframes to Excel
### Symbol Info first from row 1, then Options df from row 3
with pd.ExcelWriter("gamm.xlsx", engine="xlsxwriter") as writer:
    symbol_df.to_excel(writer,
                       sheet_name="Gamm",
                       startrow=0,
                       index=False)
    options_df.to_excel(writer,
                        sheet_name="Gamm",
                        startrow=3,
                        index=False)

    ### xlsxwriter workbook and sheet objects
    workbook = writer.book
    worksheet = writer.sheets['Gamm']

    ### Use autofit() function on the worksheet 
    worksheet.autofit()

pandas