Follow these steps to delete specified row(s) or column(s) from a worksheet:
1. Select the special process “[107] (*.XLS) Delete Specified Row(s) or Column(s)” from the Special Process drop down list. The file format is automatically set as *.XLS.
2. Next select the input and output files. If the output file is the same as the input file, the deletions will occur within the input file. If the output file doesn’t exist, 'Convert XLS' will create it along with a copy of the input workbook including the altered page.
3. Click the Click Here for Delete Cols/Rows Details button.
a. The sheet to be altered must already exist in the input workbook;
b. Select Rows or Columns for deletion and specify. Note that columns should also be referred to by number, not letter. For example, deleting columns A – D should be referred to as 1 – 4.
4. Optionally 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 - 4 as necessary.
5. Click the Convert button to execute the process.
Additional Details
Note: If you name a sheet with numbers only, you will need to use quote marks around that name. For example, if you name a sheet 32, when you specify the Input Sheet you must specify "32" with the quotes around the name so Convert XLS knows it is a name and not an index number for the sheet. If you browse for the file and click to select it, you will still need to manually add the quotes.