I want all the data to stack in columns 1 through 6. My question is, is it possible to add a header in the loop to all the individual excels, with the hope that when I then combine all of them, the data stacks correctly.Įxcel one is in columns 1 through 6, first 20 rows.Įxcel two, first line is in columns 7-12, in the first row.
Outputxlsx.to_excel('combined.xlsx', index =False) Outputxlsx = outputxlsx.append(df, ignore_index=True) Table.to_excel(os.path.join(folder_name, f"table_.xlsx"), index=False, header=True)ĭf = pd.concat(pd.read_excel(file, sheet_name=None), ignore_index=True, sort=False) Open the file in Acrobat and click on the 'Page Thumbnail' at the side bar Select the page you want to 'Export' and right click. # iterate over extracted tables and export as excel individuallyįor i, table in enumerate(tables, start=1): #Create folder tables, and save each table from pdf to folder as excel Tables = tabula.read_pdf("File.pdf", pages="all") I then want to combine all those excels on top of another, but the code is instead treating the first line as header and stacking the excels side by side. I currently have the following functioning code to import a large pdf with tables on each page, and then exporting each table to an excel.
0 kommentar(er)
