Mutipule .xls files convert into single .csv
by satyarankireddy from LinuxQuestions.org on (#4QXEJ)
On a daily basis, I have received 20 .xls files in Linux box. Each file starts from 6 rows and converts into single.csv file.
ex:-
.xls file 1 contains 106 rows
.xls file 2 contains 206 rows
.xls file 3 contains 56 rows
all three files data convert into a single CSV file. Single CSV file count should be 350.
Using below command i can able to convert .xls file to csv with single file
unoconv -f csv -e FilterOptions="59,0,0,1" test_amount1.xls
can anyone let me know how to implement single shot to all files conversion from .xls to .csv
ex:-
.xls file 1 contains 106 rows
.xls file 2 contains 206 rows
.xls file 3 contains 56 rows
all three files data convert into a single CSV file. Single CSV file count should be 350.
Using below command i can able to convert .xls file to csv with single file
unoconv -f csv -e FilterOptions="59,0,0,1" test_amount1.xls
can anyone let me know how to implement single shot to all files conversion from .xls to .csv