The description of xls2csv - Play With New Friends
This is a simple converter from XLS (Excel) to CSV format (character/comma delimited).The application works on the command line. The converter is very fast and reliable.Does not need Excel. None of the installation process.xls2csv.exe can be run with command line.The command line interface can be used from Batch files (files with *.BAT extension).Program can call with three parameters:1.Required first: full path to xls2.Optional second: to determine the character encoding [default value = utf-8]3.Optional third: the number of columns in conversion, starting counting from the first column [default all cells with data]Example 1: Data.xls file contains three sheets: sheet1, sheet2, sheet3"C:\small\xls2csv.exe" "C:\XLSfiles\data.xls"as a result of conversion have the files encoded in utf-8:C:\XLSfiles\data_sheet1.csvC:\XLSfiles\data_sheet2.csvC:\XLSfiles\data_sheet3.csvExample 2:"C:\small\xls2csv.exe" "C:\XLSfiles\data.xls" "cp1250"as a result of conversion have the files encoded in cp1250:C:\XLSfiles\data_sheet1.csvC:\XLSfiles\data_sheet2.csvC:\XLSfiles\data_sheet3.csvExample 2:"C:\small\xls2csv.exe" "C:\XLSfiles\data.xls" "utf-8" 5as a result of conversion have the files encoded in utf-8csv files have only the first 5 columnsC:\XLSfiles\data_sheet1.csvC:\XLSfiles\data_sheet2.csvC:\XLSfiles\data_sheet3.csvIf the third parameter, then the number of columns will always be consistent with the value of the parameter, even when the sheet is less. This allows for loading CSV to other programs such as the OPENQUERY in MSSQL Server.
)
