One question please, could you tell me how I could maintain the original format of the data that I want to add from one excel file to another.
I turned on the keep formatting options, but it didn’t work. The format in the first column is changed, it lacks a leading zero, in addition the date format changes.
The problem is that it is an automatic process and every day there are new files.
The date format changes quite badly for me, for example when the original says February 08, 2022 (02/08/2022), after the merger the date remains August 02, 2022 (08/02/2022). I would like the original format to be preserved.
Step 2 - Create an “Output” folder. This folder will contain the result of the merge between the tables. It doesn’t need to contain anything inside beforehand.
Step 4 - Just change the end of your .xaml. Instead of writing the result in the merge in the worksheet “book_two” write it in the worksheet “Result” in the folder “Output”.