Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: merging Excel files
Topic Summary: merge several Excel fiels into one
Created On: 03/10/2009 02:30 PM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 03/10/2009 02:30 PM
User is offline View Users Profile Print this message

Author Icon
JivaJentile
Journeyman (50-99)

Posts: 94
Joined: 03/07/2006

I need to create a task that will take one to many excel files and merge them into a single file. they will all have the same format and will need to end up on a single worksheet tab. can someone advise me if this is possible, and give an overview of how it would be done? i have not to date done any manipulation of excel data. Thanks...

 Category Survey
 03/16/2009 07:33 AM
User is offline View Users Profile Print this message

Author Icon
RonMiller
Expert (100-199)

Posts: 199
Joined: 03/02/2007

JivaJentile,

Interesting idea, see attached code example. I didn't do any extensive testing but it should get you going.

Good luck



 Category Survey



Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)


-------------------------
Paulo Monaco - Fiserv
AM6E, AM7E, BPA7E - W2K3 Servers, XP Clients
 03/16/2009 12:21 PM
User is offline View Users Profile Print this message

Author Icon
JivaJentile
Journeyman (50-99)

Posts: 94
Joined: 03/07/2006

Thanks Jeff, that gives me a good start. i will check it out soonest i have some time to get back to this project. one addition i can see off the bat is that i will not know how many rows each sheet will contain [format the same as far as columns, but variable # of rows, sorry wasnt more clear on this] so i will somehow have to detect the first blank row [or ???] in order to get my count. thanks again for the leg up... ~j

 Category Survey
 07/21/2015 08:38 AM
User is offline View Users Profile Print this message

Author Icon
KevinLush
Expert (100-199)

Posts: 123
Joined: 04/05/2011

"Thanks Jeff, that gives me a good start. i will check it out soonest i have some time to get back to this project. one addition i can see off the bat is that i will not know how many rows each sheet will contain [format the same as far as columns, but variable # of rows, sorry wasnt more clear on this] so i will somehow have to detect the first blank row [or ???] in order to get my count. thanks again for the leg up... ~j " - I agree 100% with this. I have files with uniform column names but each file can contain 1 record up to 500. I need to combine these two files and only have one header row. Help!

 Category Survey
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1005 guests browsing this forum, which makes a total of 1005 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog