Excel Special Processes (Command Line Examples List)

The following examples are extremely useful for understanding how to use the command line parameters. Choose one 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.

 

 

Special Process

EXAMPLE

P101

Copy Specified Sheet Data to Same or Different Excel File command line examples

P102

 Copy Entire Sheet to the Same or Different Excel File command line examples

P103

Delete a Single or Range of Worksheets command line examples

P104

 Add New Sheet(s) at a Specified Location command line examples

P105

 Move Sheet Location within Workbook command line examples

P106

 Rename a Worksheet command line examples

P107

 Delete Specified Row(s) or Column(s) command line examples

P108

 Change Cell Number Formatting command line examples

P109

 Search and Replace Cell Contents command line examples

P110

 Transpose Sheet Data command line examples

P111

 Change or Remove Password of XLS File command line examples

P112

 Clear Cell Contents of a Worksheet command line examples

P113

 Print Files command line examples

P114

 Run a Macro command line examples

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 command line examples

P117

 Delete All Empty Sheets within a Workbook command line examples

P118

 Delete Empty Rows from Sheet command line examples