Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Shell script - Excel/CSV file - More than one tab

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell script - Excel/CSV file - More than one tab
# 1  
Old 07-07-2011
Shell script - Excel/CSV file - More than one tab
Hi All,

Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more.

We are generating different reports through shell script after we finish our data load. Currently there are 7 such reports. Its a CSV file. Once a report generation completes, shell script send the file to respective receipents. With above process, it sends 7 mails each has seperate report to a user.

To reduce the number of mails, we were asked to make all report in one mail. We modified the script where it sends mail to user after all report generates, zip it and send it.

But still user is not satisfied as they want to have only one excel/csv file which has different tabs. ( one report info into one tab..). Now there should be only one csv/excel file which has 7 table contaiing different information.

I know it is not possible to do it through unix shell script. If any one knows on how to achive this, please post your suggestions.

I am thinking of doing it through combination of Shell script and Java script as java has functionality to create excel file with more than one tab. If any one of you have done it before by either combo of shell/java or by different approach, please help me.

The only show stopper is, it should be done by shell script.
# 2  
Old 07-07-2011
Probably Perl if you have it. Here's the module:

John McNamara / Spreadsheet-WriteExcel - search.cpan.org
# 3  
Old 07-07-2011
Thanks turk451,

WHile running one of the sample code, i am facing the below error.

Can't locate Spreadsheet/WriteExcel.pm in @INC
# 4  
Old 07-08-2011
you need to install this module (WriteExcel.pm) from the cpan
Code:
 
 perl -MCPAN -e 'install "Spreadsheet::WriteExcel"'

# 5  
Old 07-08-2011
Hi Kamaraj,

Can you please guide me how to install it? I am working at client side and i do not want to create any issue after executing the above command.

i need information as where can i execute it? any special folder?
# 6  
Old 07-08-2011
please follow this link

Installation instructions for Spreadsheet::WriteExcel
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tabbed multiple csv files into one single excel file with using shell script not perl

Hi Experts, I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script. Could anyone please... (4 Replies)
Discussion started by: ramakrk2
4 Replies

2. Shell Programming and Scripting

Trouble reading from a tab delimited excel file

So I have a file1.txt that is tab delimited: e.g. FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 9545641 123 "Neighbor and Labrador,Canada" 54895 'CANADA' 9456465 456 "Neighbor and Labrador,Canada" 54893 'CANADA' 8746512 789 "Neighbor and... (11 Replies)
Discussion started by: dan139
11 Replies

3. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies

4. Shell Programming and Scripting

Adding tab to excel sheet with shell script

(1 Reply)
Discussion started by: sagar_1986
1 Replies

5. UNIX for Dummies Questions & Answers

How to Create excel file(.csv) using shell script?

Hi, i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies

6. Shell Programming and Scripting

Shell Script for converting file to Excel or CSV

Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies

7. UNIX for Dummies Questions & Answers

Read excel file using shell script

Is it possible to read an excel sheet using shell script ? (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies

8. Shell Programming and Scripting

Convert MS Excel file to Tab limiter file in UNIX

Hi, We have a couple of ms excel files in unix server.We need convert the excel files to files TAB limiter format file with using unix script. Could you please advise on this (2 Replies)
Discussion started by: koti_rama
2 Replies

9. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies

10. Shell Programming and Scripting

editing excel file through shell script

Hi, I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script. For example-- In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies
Login or Register to Ask a Question