Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Excel files without Excel Automation

    <hr>Excel Automation is not allowed on the server running the application.<hr>
    You mean, you cannot run macros?

    How many Excel files are to be combined? If they are a few but containing a zillion worksheets each, try the following VBA-free solution:

    - Open all the files to be combined.
    - Create a new workbook.
    - Select any of the files you opened, and click on the first worksheet tab counting from left to right. The worksheet will become active.
    - From the set of arrows to the left of the worksheets tab, press the one right of all (this will scroll all the worksheet tabs to the last, counting from left to right).
    - Now hold Ctrl + Shift and click on the last worksheet tab. This way you've selected all the worksheets.
    - Right click on any worksheet tab. A context menu displays. Select "Move or Copy", remember to check the "Create a copy" box, choose the workbook you'd created to this effect, select where the worksheets should be inserted. Done.
    - Repeat with every workbook.

    Hope it works...
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Combine Excel files without Excel Automation

    You can access database-like XLS files using ADO, but if you are wanting to do something other than simply replicate data from one workbook to another, this probably won't suit your needs.

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Combine Excel files without Excel Automation

    When the files are created can you save them as CSV files? If so then it could be very easy to combine them on a server that isn't running Excel. But of course all sheets would be combined into one big worksheet.

    StuartR

  4. #4
    New Lounger
    Join Date
    Sep 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine Excel files without Excel Automation

    <P ID="edit" class=small>(Edited by sabu on 09-Sep-03 07:47. Further clarification of situation.)</P>Has anybody run across any software (library or application) that can combine multiple excel files into one excel workbook without requiring Excel? I'd like each worksheet from the group of files to be a worksheet in the combined file. Excel Automation (or even running Excel) is not allowed on the server running the application.

    The worksheets have graphs on them. The data is being populated and changed via ADO.NET.

    Thanks,
    Bob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •