How to create xls file using shell

April 5, 2009 at 23:38:23
Specs: HP-UX
Hi All,


I want to create an xls file using shell script. I mean that I have written one script. It is having sql output. So I want to save that sql output into one xls file and I want to send that file as a attachment to my team MAIL_IDs.

Can You any guy help me in this?

Thanks in Advance.

Regards,
Raghu.

Raghunadh


See More: How to create xls file using shell

Report •


#1
April 6, 2009 at 03:28:16
You could make a simple comma separated value (.csv) file. It should open in Excel without problem.

Report •

#2
April 6, 2009 at 04:29:13
Hi Razor,

Thank you very much for ur solution.

I create the output file with (.csv) extension. Good idea..

Can you tell me how to send this file to our team as attachment mail. I used the below command but I am not getting the mail with attachment. I am getting the mail with some junk characters.

(uuencode attach.txt attach.txt ; echo "mail_body")|mailx -m -s "subject" ragu@gmail.com

Can anyone give me any idea in this?

Thanks in advance.

Regards,
Raghu.

Raghunadh


Report •

#3
April 6, 2009 at 04:40:18
Can you tell me how to send this file to our team as attachment mail.
Nope. I deal mainly with Windows, not Unix. There are a few people here who might be able to help, but I wouldn't count on them reading a thread referencing Excel.

Report •

Related Solutions


Ask Question