Solved

How to combine 2 excels into one, and include header from only first one

Posted on 2014-11-19
7
88 Views
Last Modified: 2014-12-26
Hi,

How do we combine 2 excels into one, and include header from only first one.
Is there a any easy way to script it via a bat file.

Thanks!
0
Comment
Question by:chetan1981
  • 3
  • 2
7 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 40453904
Do you really mean XLS(x), or rather CSV?
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40453910
The former requires Office Automation, and that only works with .NET(like) languages (VB, VB Script, PowerShell), The latter is feasible in a .cmd batch, unless there are special characters like ampersand, parens, percent signs, double quotes, in short - very delicate.
0
 

Author Comment

by:chetan1981
ID: 40455025
CSV should be fine too..thanks
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40455133
copy /A firstFile.csv combinedFile.csv
more +1 <secondFile.csv >>combinedFile.csv

Open in new window

0
 

Author Comment

by:chetan1981
ID: 40455332
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
base64 decode encode 12 119
Need more details 5 124
Counting documents in a Domino View 3 64
Plain Text Editor for iPad 6 59
Being a system administrator some time we require to do things remotely, one of them is installing software. Here I am going to tell you how to install software through wmic (Windows management instrument console). I am not at all saying that this i…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now