Excel

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
crazycaddy
Forum Commoner
Posts: 43
Joined: Fri Aug 05, 2005 6:59 am
Location: England, UK

Excel

Post by crazycaddy »

Where could I find an application/macro that can merge multiple execl spreadsheets together?
but on the same sheet.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

....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 »

how? There is about 1000 excel documents with the same layout, but i want the data all in one sheet.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

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 »

could you please give an example script? its fairly urgent.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

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 »

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 8O )
Post Reply