Trusted brand in PDF Converter & Creator, PDF Tools, Office Document Converter, Image Converter, etc.

Home > Products

Okdo Excel Merger Command Line


Okdo Excel Merger Command Line is a powerful Excel tool which can be used to merge multiple excel worksheets into one new worksheet or merge excel files into one new workbook with command line. It allows you to merge a batch of excel documents and combine the specified excel worksheets together in a short time. It supports MS Excel 97-2003,2007,2010,2013 format document like *.XLS, *.XLSX, *.XLSM.

 

Price: $149.95

 

 

 

Advanced Features

Merge worksheets from different Excel files into one Workbook or Worksheet with command line method.
Supported file formats: Excel 2013, 2010, 2007 and 2003(*.XLS, *.XLSX, *.XLSM).
Do not need Microsoft Excel.
Batch merge Excel Workbook with wildcard characters. eg: *.xls, aa*.xls, bb??.xls.
Merge data from multiple worksheets into a single worksheet.
Merge data from multiple workbooks into a new workbook(multiple worksheets).
Merge specific worksheets from workbooks into one workbook or one worksheet.
Merge all workbooks from a directory into one workbook or one worksheet.
Supports stack data from top to bottom in the output worksheet.
Supports stack data from left to right in the output worksheet.
Supports insert the number of blank rows/columns between worksheet contents in the output worksheet.
Supports customize the output path.
Supports overwrite existing output file.
Fast merging speed and high quality output.
More...

 

Okdo Excel Merger Command Line Options

Okdo Excel Merger Command Line is based on command line interface, and you have to open a DOS command prompt window to run it. Change the current directory to the one where Okdo Excel Merger Command Line is installed, and then you can run the application referring to the following usage:

 

Usage: excelmerger.exe [options] -workbook=<source file> -dest=<output file>

-workbook=<value> Specify the source excel workbook path
Supports *.xls, *.xlsx, *.xlsm format
Supports wildcard character like * and ? eg: -workbook=c:\book*.xls

-sheetname=<value1,value2,...>
Specify the sheet name from source workbook:
-sheetname=sheet1,sheet2,sheet3

-dest=<value>
Specify the name for the merged file, supports *.xls format
-dest=c:\out.xls

-mergemode=<value> There are 2 ways to specify the merge mode
Default: -mergemode=0

0. Merge multiple worksheets from workbooks into
one workbook (multiple worksheets) eg:
-mergemode=0

1. Merge multiple worksheets from workbooks into
one worksheet eg:
-mergemode=1

-orientation=<value> This option has effect in mergemode=1 only.
Default: -orientation=0

0. Stack data from top to bottom eg:
-orientation=0

1. Stack data from left to right eg:
-orientation=1

-insertblank=<value>
Insert the number of blank rows/columns between
each worksheet content. default: -insertblank=0
This option has effect in mergemode=1 only.

-overwrite Overwrite existing output file

Example:
excelmerger.exe -workbook=c:\*.xls -dest=c:\out.xls -mergemode=1
excelmerger.exe -workbook=c:\book*.xls -dest=c:\out.xls -mergemode=1
excelmerger.exe -workbook=c:\book??.xls -dest=c:\out.xls -mergemode=1
excelmerger.exe -workbook=c:\1.xls -workbook=c:\2.xls -dest=c:\out.xls -mergemode=1
excelmerger.exe -workbook=c:\1.xls -workbook=c:\2.xls -dest=c:\out.xls -mergemode=0
excelmerger.exe -workbook=c:\1.xls -sheetname=sheet1,sheet2 -dest=c:\out.xls -mergemode=1
excelmerger.exe -workbook=c:\1.xls -sheetname=sheet1,sheet2 -workbook=c:\2.xls -sheetname=sheet3,sheet4 -dest=c:\out.xls -mergemode=0
excelmerger.exe -workbook=c:\1.xls -workbook=c:\2.xls -dest=c:\out.xls -mergemode=1 -insertblank=5 -orientation=0

FREE customer support

If you face any problem while installing or using the Okdo Excel Merger Command Line, we are there to provide guidance and technical support. All you need to do is to send us your queries at support@okdosoft.com.

Supported Formats

Input Formats

MS Excel File

*.xls, *.xlsx, *.xlsm

Output Formats

MS Excel File

*.xls

Free Download Okdo Excel Merger Command Line
Purchase Okdo Excel Merger Command Line (Price: $149.95)

Awards

Software Awards

Free PDF Tools
Okdo PDF Tools Platinum Free
Okdo PDF Splitter Free
Okdo PDF Merger Free
Okdo PDF Encrypter Free
Okdo Split and Merge PDF Free
Office Document Merger
Okdo PowerPoint Merger
Okdo PowerPoint Merger CMD
Okdo Word Merger
Okdo Word Merger CMD
Okdo Excel Merger
Okdo Excel Merger CMD
All-in-One Conversion Toolkit
Okdo Document Converter
PDF to All File
PDF to All Converter
PDF to PowerPoint Converter
PDF to Word Converter
PDF to Excel Converter
PDF to RTF TXT Converter
PDF to SWF Converter
PDF to Image Converter
PDF to HTML Converter
PDF to Website Converter
More...
All File to PDF
All to PDF Converter
Word to PDF Converter
Excel to PDF Converter
PowerPoint to PDF Converter
RTF to PDF Converter
Image to PDF Converter
Website to PDF Converter
More...
All File to PowerPoint
All to PowerPoint Converter
Word to PowerPoint Converter
Excel to PowerPoint Converter
TXT RTF to PowerPoint Converter
Image to PowerPoint Converter
Website HTML to PowerPoint Converter
More...
All File to SWF
All to SWF Converter
Word to SWF Converter
Excel to SWF Converter
PowerPoint to SWF Converter
DOC DOCX to SWF Converter
XLS XLSX to SWF Converter
PPT PPTX to SWF Converter
Image to SWF Converter
More...
All File to Image
All to Image Converter
All to JPEG Converter
Word to Image Converter
Excel to Image Converter
PowerPoint to Image Converter
Word to JPEG Converter
Excel to JPEG Converter
PowerPoint to JPEG Converter
HTML to Image Converter
Website to Image Converter
More...
All File to Word
All to Word Converter
PowerPoint to Word RTF Converter
Excel to Word Converter
DOCX DOCM to DOC Converter
DOC to DOCX DOCM Converter
Image to Word RTF Converter
Image to DOC Converter
GIF to DOC Converter
TIF to DOC Converter
More...
All File to Text HTML Excel
All to Text Converter
All to HTML Converter
Website HTML to Text Converter
HTML to TXT Converter
PowerPoint to HTML Converter
Word RTF to Excel Converter
PowerPoint to Excel Converter
More...