Writing the Data to an Existing Excel template
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
DataPirate26
10 - Fireball
‎05-17-2021
10:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have 3 Excel Files and each File has 3 tabs in it which has different structure so the schema is not same. But all the 3 Files has similar structure. The requirement is that I have to take the Data from all the Input Files and Write it into an existing Excel template which also has the similar structure as of the input Files.
Labels:
- Labels:
- Output
1 REPLY 1
19 - Altair
‎05-18-2021
06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check out the solution to this post by @AbhilashR which shows how to create a copy of the template file and then writing to the copy.
Dan
