Financial work, over how to multiple EXCEL SHEET with the same content is merged into another EXCEL in a SHEET

CodePudding user response:

In three steps:
1. Open multiple excel
Process your logic
2.3. Save

CodePudding user response:

Use openpyxl

Open eventually merge table
One by one to open the Excel table:
If the same watches:
Processing merger
Close the Excel table
Save eventually merge table
Shut down eventually merge table

Because you didn't made clear what is "merge", is to add rows, or the same cell number, etc., so can't clear code

CodePudding user response:

Is to combine different EXCEL SHEET with the same content together, and generate another EXCEL SHEET, if there is any code a look

CodePudding user response:

reference o f m reply:

with openpyxl

Open eventually merge table
One by one to open the Excel table:
If the same watches:
Processing merger
Close the Excel table
Save eventually merge table
Shut down eventually merge table

Because you didn't made clear what is "merge", is to add rows, or the same cell number, etc., so can't clear code

Is to combine different EXCEL SHEET with the same content together, and generate another EXCEL SHEET, if there is any code a look

CodePudding user response:

reference 1/f, happy pigs response:

in three steps:
1. Open multiple excel
Process your logic
2.3. Save

Is to combine different EXCEL SHEET with the same content together, and generate another EXCEL SHEET, if there is any code a look