xlwings 与 pandas的互动
#与pandas 的交互
#对单元格进行操作,将df值插入单元格
# import xlwings as xw
# import pandas as pd
# app=xw.App(add_book=False)
# wb=app.books.open(r'C:\Users\Administrator\Desktop\1test.xlsm')
# sht=wb.sheets[0]
# df=pd.DataFrame([[1,2,3],[4,5,6]],columns=list('abc'),index=list('ab'))
# sht.range('a1').value=df
#将单元格的值转为df
# import xlwings as xw
# import pandas as pd
# app=xw.App(add_book=False)
# wb=app.books.open(r'C:\Users\Administrator\Desktop\1test.xlsm')
# sht=wb.sheets[0]
# df=pd.DataFrame(sht.range('A1:c3').value)
# print(df)