XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).
Moderator: General Moderators
crazycaddy
Forum Commoner
Posts: 43 Joined: Fri Aug 05, 2005 6:59 am
Location: England, UK
Post
by crazycaddy » Fri Aug 05, 2005 9:19 am
Where could I find an application/macro that can merge multiple execl spreadsheets together?
but on the same sheet.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Fri Aug 05, 2005 9:23 am
....on a windows server?
You should be able to use Excel itself if it's installed..
crazycaddy
Forum Commoner
Posts: 43 Joined: Fri Aug 05, 2005 6:59 am
Location: England, UK
Post
by crazycaddy » Fri Aug 05, 2005 9:34 am
how? There is about 1000 excel documents with the same layout, but i want the data all in one sheet.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Fri Aug 05, 2005 10:40 am
if it's a windows server, and Excel is installed, you can use
COM to open each file and dump each into a single file.
crazycaddy
Forum Commoner
Posts: 43 Joined: Fri Aug 05, 2005 6:59 am
Location: England, UK
Post
by crazycaddy » Tue Aug 09, 2005 4:01 am
could you please give an example script? its fairly urgent.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Tue Aug 09, 2005 8:11 am
sorry, I can't. None of my work goes on windows servers much.
crazycaddy
Forum Commoner
Posts: 43 Joined: Fri Aug 05, 2005 6:59 am
Location: England, UK
Post
by crazycaddy » Tue Aug 09, 2005 10:42 am
OK no problem, I found a program called filemonkey to merge txt files, and another program costing around £11 to convert the xls documents to txt (most programs like that are either $40 for 3 months or $399 as a one of payment
)