Office 2013 Compatible!

FYI: We're upgrading our website look and feel over the next 30 days. This page will be done soon!
Batch Print Excel files easily with 'Convert XLS'.


Customers

convert CSV to PDF software, adobe customer

Adobe Systems Inc. Chooses 'Convert Doc'.  A custom site license has been signed by Adobe allowing them to install 'Convert Doc' on their servers.  They will be using it specifically to do Doc to HTML conversions. "We look forward to using your product and potentially working together in the future", Bob Free, Adobe

convert CSV to PDF IBM Customer

Great customer service, prompt attention to our requirements and lightening speed development has been my experience with the staff at Softinterface Inc. Within a few hours of installing... Bruce King, IBM Canada, Toronto, Ontario



Click for the BBB Business Review of this Computers Hardware, Software & Services in Santa Monica CA
convert CSV to PDF software, no viruses

Batch Print Excel Files with 'Convert XLS'

(MS Excel Batch Printing, Conversion and Sheet Manipulation Utility)
English, Deutsch, Franšais, Italiano, 日本語, Brazilian Portuguese, Espa˝ol, Other Languages

'Convert XLS' logo, can be used to Batch Print Excel files

Special Promotion: Buy 'Convert XLS' and get 'Convert Doc', 'Convert Image', 'Convert PowerPoint' and 'Convert Document To Image' free!

Need to batch print Excel files? Excellent, you are at the right place. Softinterface has created a sophisticated software utility called 'Convert XLS' which has many 'special processes' to convert/manipulate Excel files (including the bulk printing of Excel). Read below for details on this specific feature, or click on the 'Convert XLS' home page to get a better idea of what the product completely does.

Have a requirement for automating the batch printing of Excel files?  No problem, see the bottom of this page for some examples of how to do just that.  We have a built in scheduler as well as a command line (and a COM/ActiveX) interface which will allow you to leverage 'Convert XLS' to automate your workplace!

Download Bulk Print Excel utility

'Convert XLS' Printing Worksheets/Workbooks

  • Batch print Excel Files (or any file MS Excel can open).
  • Save and restore complex conversion configurations.
  • Move or delete input files after processing.
  • Convert Excel files to and from Text/CSV/HTML/XML without requiring MS Excel to be installed. If you do have MS Excel, 'Convert XLS' will support all file types in addition to TXT, XML, CSV etc. (see table below for a listing).
  • Special processing of files including appending/concatenation, removing extra lines, launching 3rd party programs, search and replace strings and much more.
  • Advanced Excel Manipulation Special processes including moving, deleting, adding and copying sheets.  Append/Concatenate Excel files into a single sheet (See below for more details).
  • Numerous Comma Delimited File (CSV) manipulation methods (See below for more details).
  • Convert Fixed Width Text Files to/from Excel or CSV files.
  • Batch can be stopped midway and resumed at a later time. 
  • Command line (Invisible at runtime) and GUI execution. Complete flexibility, complete power.
  • Can be adapted for all languages.

Batch Print Excel dialog boxYou can print some or all of one or more workbooks using the special process for printing. In fact, if MS Excel can open it, you can specify other file types as well (such as CSV for example).

Follow these steps to print contents of a workbook:

1. Select the special process "[113] (*.XLS) Print Excel Sheet(s)" from the Special Process drop down list. The file format is automatically set as *.XLS.

2. Next select original and target files. Target file is only needed if you are printing to a file.

Click the 'Click Here for Printing Details' button to modify printing details.

3. Click the Add button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.

Click the 'Convert' button to execute the process.

 

'Convert XLS' Command Line

Command Line Explained

'Convert XLS' can be run without a user interface with command line arguments much like in the good old DOS days.  Alternatively you can initiate command line execution by going to the operating system 'command prompt' or within Windows at the START-RUN menu and typing it in there.  Lastly, the command line interface can be used from Batch files (files with *.BAT extension). 

There are two approaches to using the command line:

     A)  Specify a 'Conversion Job' that was built using the graphical user interface (GUI); or

     B)   Specify a 'Conversion Task' in detail from the command line.

See the  'Convert Xls' documentation for a full explanation and reference.  Below we focus specifically on using 'Convert XLS' to bulk print Excel files.

COMMAND LINE PRINTING

The special process associated with printing is 113. 

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

113

Print worksheet(s) in one or more workbooks.

Bulk print Excel

sPrinter^OriginalSheet^sRange^lNumCopies^lFromPage^lToPage^bCollate^bPrintToFile

/1 = sPrinter (not sure what this is, use the user interface to see strings associated with printers)

/2 = sSheetsToPrint (by name or number)

/3 = sRange (leave blank for 'used range')

/4 = lNumber of copies

/5 = lPageFrom (leave empty to start printing from the beginning)

/6 = lPageTo (leave empty to terminate printing at the end)

/7 = bCollate ("TRUE" or "FALSE"). Set to "TRUE" to collate multiple copies

/8 = bPrintToFile ("TRUE" or "FALSE"). Set to "TRUE" if printing to a file. You must specify a target file if printing to a file.

This special process can clear the contents that you specify in the range that you specify.

Special Parameters Described in Detail

/1{sPrinter} String associated with the printer you wish to print to. If you are not sure about this, use the graphical user interface and save a 'conversion job' from the file menu. Open this 'conversion job' file in notepad to see the string associated with the printer you used.

/2{ sSheetsToPrint } Name or number of the sheet(s) to print. Required.

/3{sRange} Range of cells being printed (i.e. "A1:B4, J10"). Leave empty for 'used range'.

/4{lNumberOfCopies} Numeric value specifying the number of copies to print

/5{lPageFrom} You can optionally specify a range of pages to print by using this and the lPagesTo parameters. Leave empty to simply print the range chosen

/6{lPageTo} You can optionally specify a range of pages to print by using this and the lPagesTo parameters. Leave empty to simply print the range chosen

/7{bCollate} If doing numerous copies of a print job that has more than one page, you may want to keep them in proper order by setting this parameter to "TRUE".

/8{bPrintToFile} Set to "TRUE" to print to a file. If you are printing to a file, the target file must be specified.

Examples:

EXAMPLE 1: Print the 2nd sheet in a workbook

To print 1 copy of the 2nd worksheet and a specific range of cells in "C:\ExcelFiles\Summary.XLS" the following syntax would be used:

ConvertXLS.EXE /S"C:\ExcelFiles\Summary.XLS" /T"C:\ExcelFiles\Summary.XLS" /P113 /1"HP Deskjet 550" /2 2 /3 A19:F19,Z12 /4 1

Batch print xls files by modifying the example above to meet your specific needs.

See Also:
Web Based Documentation which includes example usage of the command line.