xlsx2csv
xlsx2csv OPTIONS EXCEL_WORKBOOK_NAME [SHEET_NAME]
xlsx2csv is a tool that converts individual Excel Sheets to CSV output.
Extract a workbook sheet as a CSV file
xlsx2csv MyWorkbook.xlsx "My worksheet 1" > sheet1.csv
This would get the first sheet from the workbook and save it as a CSV file.
xlsx2csv -count MyWorkbook.xlsx
This will output the number of sheets in the Workbook.
xlsx2csv -sheets MyWorkbook.xlsx
This will display a list of sheet names, one per line. Putting it all together in a shell script.
xlsx2csv -N MyWorkbook.xlsx | while read SHEET_NAME; do
CSV_NAME="${SHEET_NAME// /-}.csv"
xlsx2csv -o "${CSV_NAME}" MyWorkbook.xlsx "${SHEET_NAME}"
done
xlsx2csv 1.2.10