Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
How to create xls file using shell
Name: raghu.iv85 Date: April 5, 2009 at 23:38:23 Pacific OS: HP-UX Subcategory: General
Comment:
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.
Name: Razor2.3 Date: April 6, 2009 at 03:28:16 Pacific
Reply:
You could make a simple comma separated value (.csv) file. It should open in Excel without problem.
0
Response Number 2
Name: raghu.iv85 Date: April 6, 2009 at 04:29:13 Pacific
Reply:
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.
Name: Razor2.3 Date: April 6, 2009 at 04:40:18 Pacific
Reply:
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.
Summary: Hi, I need to compare 2 files using awk, file1 & file2 line by line. Field 5 in everyline of file1 should be compared in whole file2 & if match is found then print that line in file2 & then print next...