Description: This method allows you to crop or remove certain rows while keeping others. Those not specified will be removed. For example to keep rows 1,9-10, 25, and 30 specify: "1,9-10, 25,30" for the sRowsToUse parameter.
Parameters:
csvCropCSVFileRows(sInputFile As String, sOutputFile As String, sRowsToUse As String) As Long
|
Parameter |
Meaning |
|
SPathOriginal |
CSV file to modify |
|
SPathTarget |
Can be same as sPathOriginal in which case sPathOriginal will be overwritten. If a different name is specified, XLSConverterX will create a new file. |
|
SRowsToUse |
/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. |
Return Values:
0: Success
-2: "Unable to open or save to target file. Could be a sharing violation, or invalid file type.
-3: "Unable to open original file. Check file format. Could be a sharing violation.
-201: "Shareware has expired"
Example Code:
Please review the code sample under csvChangeDelimitationCharacter()