Convert xlsx file to csv using batch

Convert xlsx file to csv using batch

Asked on January 11, 2019 in Excel.
Add Comment


  • 3 Answer(s)

    Procedure :

    You can use this command,

    in2csv file.xlsx > file.csv
    
    

    For more information click here

    Answered on January 11, 2019.
    Add Comment

          To operating the xlsx2csv mechanism wants to be installed earlier. When maintaining the file names, a shell script to batch alter name every xlsx files to csv.

    for i in *.xlsx;
      do
       filename=$(basename "$i" .xlsx);
       outext=".csv"
       xlsx2csv $i $filename$outext
    done
    
    Answered on January 11, 2019.
    Add Comment

          The following command in the group of same objects, will explain about after installing from the below link,

    “c:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE” /S”C:\MyExcelFile.xlsx” /F51 /N”Sheet1″ /T”C:\MyExcelFile.CSV” /C6 /M1 /V

    Use this link, SoftInterface.com – Convert XLSX to CSV.

    Answered on January 11, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.