Write two csv files into one excel with multiple sheets

I have requirement to write two CSV files to one single excel with multiple sheets.

Data present in the two files should sit in excel as different sheets.

How can we achieve this using shell script?

1.csv        2. csv
1,2,3,4        5,6,7,8
XXXXX        YYYYY

Res.excel
1.csv data should sit in active sheet.
2.csv data should present in other sheet.

Hi i think its not possible using shell script,however you can try for perl script search perl resources online and i think you can find one