Shell script for dealing with XLS file with multiple tabs/worksheets

UNIX for Advanced & Expert Users
1

Hey Guys ,

Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :

  1. Convert one XLS file with multiple tabs to multiple CSV files.
    -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But during this , i read lots of forum and learnt that UNIX shell scripting do not have any utility or solution for this.Is this really true?bcaz i everywhere found ppl recommending PERL or other stuff .

----------------------
Real Problem.
----------------------
2. Once Files are converted to CSV , we have to rename all CSV files with names as in different tab from XLS i.e first CSV should be named as the first tab in that XLS and so on .

Is there anyway in scripting to capture those tab names from XLS?

and if not , what alternative i should try to make this happen ?

I am eagerly looking forward for your replies.

Cheers!!!
Himanshu Sood

2

Can you show some example data how the xls is looking alike?
You probably dont have to rename the files in a second appraoch if you save them as the 'tab/register' name in the first place.

Cheers

3

Hello Sea ,

I have added a xls for ur reference.
You will see 3 sheets in that and the new csv files need to have those names in it .

E.g :-
Origin File Name :- 20130430_Himanshu.xls

CSV File Name :-
20130430_DE000A0V7550_Himanshu.csv
20130430_DE000A0V7568_Himanshu.csv
20130430_DE000A0V7570 _Himanshu.csv

Hope its clear to you .

Thanks,
Himanshu Sood