import xlwings as xl
path = r'.\托辊算价表.xls'
workbook = xl.Book(path)
worksheets = workbook.sheets['托辊']
value = worksheets.range('A1').expand('table')
cells = 'A3:O9'
cellArea = worksheets.range(cells).value
worksheet = workbook.sheets['托辊记录']
if worksheet.range('A1') == '':
newData = worksheet.range('A1').expand('table')
worksheet.range(newData.shape[0], 2).value = cellArea
else:
oldData = worksheet.range('A1').expand('table')
worksheet.range('A10').value = oldData
newData = worksheet.range('A1').expand()
worksheet.range(newData.shape[0], 2).value = cellArea
我这样写的话,原有的数据下移了只有1行,新数据值粘贴了1行,如何写原有的旧数据下移了10行,新数据全部粘贴
https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html
# range平移
worksheets.range(cells).offset(row_offset=0,column_offset=10)