Looking at this question and answers (CLI - convert ods to csv with semicolon as delimiter), plus checking some other resources, I found out that you can batch convert spreadsheet files to CSV. This is command you can use:
soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"59,ANSI,1" test.ods
Only problem I have is, I don’t want to convert first/default sheet. I want to convert specific sheet (defined by order number or name).
Does anyone know how to convert specific sheet with this command?
My guess is that opening spreadsheet file in specific sheet and then converting would work also, but not sure how to do that via command line.