/P# |
Meaning |
Extra Parameters: /1{Parameter1} /n{Nth Parameter} |
205 |
CSV, File Include specified ROWS, discard all others |
/1 = Selection of rows to include. All others will be discarded.
For example to keep rows 4-20, 25, and 30 specify: /1 4-20,25,30 |
Special Parameters Described in Detail
/1 Specifies which rows to leave. Those not specified will be removed. For example to keep rows 1,9-10, 25, and 30 specify: "/1 1,9-10, 25,30"
To keep rows 1,9-10, 25, and 30 in file D:\CSVFiles\Simple.CSV, the following syntax would be used:
ConvertXLS.EXE /S"D:\CSVFiles\Simple.CSV" /T"D:\CSVFiles\Simple.CSV" /P205 /1 1,9-10,25,30
The /S and /T switches specify input and output workbook respectively, which in this case is the same workbook. You can optionally keep the input file unchanged by specifying a different name or path for the output file.