python dataframe 写入 excel

项目中用到把DateFrame写入Excel，其中pandas中的几个参数非常有用。

这里以实例说明：

1. import pandas as pd

2.  

3. #create some Pandas DateFrame from some data

4. df1=pd.DataFrame({'Data1':[1,2,3,4,5,6,7]})

5. df2=pd.DataFrame({'Data2':[8,9,10,11,12,13]})

6. df3=pd.DataFrame({'Data3':[14,15,16,17,18]})

7. All=[df1,df2,df3]

8. #create a Pandas Excel writer using xlswriter

9. writer=pd.ExcelWriter('test.xlsx')

10.  

11. df1.to_excel(writer,sheet_name='Data1',startcol=0,index=False)

12. df2.to_excel(writer,sheet_name='Data1',startcol=1,index=False)

13. df3.to_excel(writer,sheet_name='Data3