Combine several xlsx files into one single xlsx

Question

I want to combine several xlsx files into one. However this xlsx files have different number of lines and they have highlight cells. When I combine them into one, they appear to be next, without a row beteween the two dataframes, and they also lost the highlighted cells.

Here is the code I have, so far:

writer=pd.ExcelWriter('output.xlsx')
# xlsfiles = [files_in for files_in in glob.glob('*.xlsx')]
for files_in in glob.glob('*.final_2.xlsx'):
    excel_file=pd.ExcelFile(files_in)
    df_excell=pd.read_excel(files_in)
    df_excell.to_excel(writer,index=False)
writer.save()

Thanks!

So really the question you are after is: how do I maintain my Excel formatting when combining excel files using Python? — Jeff Coldplume, Feb 28 '20 at 18:45
Can you provide a [mcve], at least some example input/output? — AMC, Feb 28 '20 at 20:43

score 0 · Answer 1 · answered Mar 04 '20 at 15:57

0

I would start by taking a look at a similar question a user has posted here:

Python Excel template read and re-write, maintaining formulae and formatting

answered Mar 04 '20 at 15:57

Jeff Coldplume

343
1
13

Combine several xlsx files into one single xlsx

1 Answers1