Combine multiple excel workbooks into one workbook

Saaduddi...

SOLVED CLOSED ACTIVE ANSWERED
User: Saaduddin
Posted: on Mar 05, 2012 05:02 AM
Forum: Windows Basics
Answer: 2
Views: 5566

Hi,

Hi, I have around 10 separate Excel workbooks contaiing only data in them. The data is from Test, Dev, QA, UAT, PRE-PROD, PROD.....etc environments. I need to combine all 10 workbooks data into one. After combining i need to have the data from the 1st column of each sheet into a new sheet without duplicated data.

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 3

Reply
ANSWER
User: Mudassar
Replied: on Mar 05, 2012 05:28 AM
Report

http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx

http://msdn.microsoft.com/en-us/library/gg549168.aspx

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Combine multiple excel workbooks into one workbook

Company

Explore

Follow us

Contact Us