P118 Delete Empty Rows from Sheet (command line examples)

 

P118 Command Line Reference:

/P#

Meaning

Extra Parameters:

118

Search the specified sheet for empty rows and delete them.

/1 = sSheet(s) - worksheet(s) to be modified (by name or number)

/2 = Rows to be checked for emptiness (and deleted if empty)

 

This special process allows you to remove empty rows within a sheet. You can do the whole sheet, or specific rows.

 

Special Parameters Described in Detail

/1{sSheet} Required. Name of the sheet(s) to modify.

    Sheets can specified by name or number.  

              You may specify ranges by index:  i.e. "2-4,10" or "*" for all.

              You may specify by name: i.e. "Sheet4","Sheet6","Accounting"

 

/2{sCheckRows} Optional. Specifies which row(s) to scan to check for emptiness. If you would like to check the whole sheet, simply do not include this switch.

 

     To specify rows 2-4 the syntax is:

     /2  2-4

     Or even specify several sets of rows to check:

     /2 100-200,50-70,1-2

 

     Separate each set with a comma.

 

     IMPORTANT: If you are specifying more than one set of rows always do so in descending order, as shown immediately above.

 

Command Line Examples for Deleting Empty Rows from a Sheet

Example 1: Remove all empty rows of specified sheet

This next example deletes all empty rows within sheet named ABC within the IN.XLS workbook and saves it to Out.XLS

ConvertXLS.EXE /S"C:\Input\In.XLS" /T"C:\Output\Out.XLS" /P118 /1 ABC

 

Example 2: Scan a specific set of rows to check and remove if empty

This next example deletes rows within the following ranges:

Rows 100-149

Rows 50-60

Rows 3-4

It does so in the sheet named ABC within the IN.XLS workbook and saves it to Out.XLS

ConvertXLS.EXE /S"C:\Input\In.XLS" /T"C:\Output\Out.XLS" /P118 /1 ABC /2 100-149,50-60,3-4