如何利用python整合excel_如何使用Python语句快速合并多个Excel文件

import

pandas

as

pd

import

xlrd

import

xlwt

file1=

'G:\ \ \STA-05.xls'

file2=

'G:\ \ \STA-08.xls'

file3=

'G:\ \ \STA-32.xls'

file4=

'G:\ \ \STA-39.xls'

file5=

'G:\ \ \STA-45.xls'

file6=

'G:\ \ \STA-64.xls'

file7=

'G:\ \ \STA-65.xls'

file8=

'G:\ \ \STA-72.xls'

file9=

'G:\ \ \STA-82.xls'

file10=

'G:\ \ \STA-85.xls'

file=[file1,file2,file3,file4,file5,file6,file7,file8,file9,file10]

li=[]

for

i

in

file:

li.append(pd.read_excel(i))

writer=pd.ExcelWriter(

'G:\ \ \\output.xls'

)

pd.concat(li).to_excel(writer,

'sheet'

,

index

=

False

)

writer.save()