xlwings直接读取为pandas

app = xw.App(visible=False,add_book= False)

workbook =app.books.open(pathfile)

df = worksheet.range("A1").options(pd.DataFrame,expand = 'table').value

split_columns = df['规格'].str.split('*',expand=True)

df['长'] = split_columns[0]

worksheet.range("A1").value = df