Examples: Excel Special Processes

The following examples are extremely useful for understanding how to use the command line parameters. Choose from the examples below and modify according to your needs.

Note it is highly encouraged that you use the Verbose (/V) switch initially to see what the status of your conversion is.

P101 Copy Specified Sheet Data to same or different XLS file

P102 Copy Entire Sheet to the Same or new XLS File

P103 Delete a Single or Range of Worksheets

P104 Add New Sheet(s) at a Specified Location

P105 Move Sheet Location within Workbook

P106 Rename a Worksheet

P107 Delete Specified Row(s) or Column(s)

P108 Change Cell Number Formatting

P109 Search and Replace Cell Contents

P110 Transpose Sheet Data

P111 Change or Remove Password of XLS File

P112 Clear Cell Contents of a Worksheet

P113 Print Files

P114 Run a Macro

P115 Import tables from doc, html, xml, rtf, wpd etc into a XLS worksheet(s)/workbook(s)

P116 Change the Value or Formula of a Cell or a Range of Cells

P117 Delete All Empty Sheets within a Workbook