Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Mail csv as xls in shell

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Mail csv as xls in shell
# 1  
Old 11-17-2011
Mail csv as xls in shell
Hello,

I have one csv file(";" separated). I would like to mail it as an attachment in xls format.

I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".
Code:
unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid

Thanks


Moderator's Comments:
Mod Comment Please use code tags!
Last edited by zaxxon; 11-17-2011 at 04:14 AM.. Reason: code tags, see PM
# 2  
Old 11-17-2011
Try with this ..
Code:
$ sed 's,;,\,,g' file2 > csvfile
$ uuencode csvfile filename.csv | mailx -s "hi" abc@xyz.com

PS: Please dont double post ..
https://www.unix.com/shell-programmin...ll-script.html
# 3  
Old 11-17-2011
There is also a nice search function in this forum and if you enter "uuencode" or "mail" or both, you will get a lot of hits I bet.
# 4  
Old 11-17-2011
thanks Jayan .... it worked Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Download .xls file from mail and copy to another path using shell script

Hi I have a mail attachment coming from a mail id and evreytime with the same name in .xls format.I have to download the .xls file into a location and convert it itno .csv format and copy the .csv file to another location. (1 Reply)
Discussion started by: bikky6
1 Replies

2. Shell Programming and Scripting

Csv to xls

Hello I have a script which converts log to csv. Now I need to have xls. Is there any easy way/command which can convert csv to xls?:confused: preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies

3. Shell Programming and Scripting

Mail csv to xls in Shell Script

Hello, I have one csv file(";" separated). I would like to mail it as an attachment in xls format. I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";". unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (1 Reply)
Discussion started by: skhichi
1 Replies

4. Shell Programming and Scripting

Oracle to CSV to XLS

I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet Thanks so much JAvier (3 Replies)
Discussion started by: javeiregh
3 Replies

5. Shell Programming and Scripting

CSV to XLS

Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading. All the trading run's in Redhat or Solaris environments. We run a script on a Redhat server whitch generates the stats in CSV format. After we download we open it in Excel and... (3 Replies)
Discussion started by: chipmunken
3 Replies

6. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

7. Shell Programming and Scripting

Shell convert xls to csv

Hi does anybody know how to convert xls to csv undex linux. I need only data (that is log from test, dont need any macro and so on) from xls. Any idea how to do that? Perl? shell? Could you give me any example? Thanks in advance for answer. Gracjan (4 Replies)
Discussion started by: Gracjan
4 Replies

8. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

9. Shell Programming and Scripting

xls to csv

how to convert a xls file into .csv file? is tghere any command in unix for that? please help thanks (3 Replies)
Discussion started by: infyanurag
3 Replies

10. Shell Programming and Scripting

Converting csv to xls

Hi, Can anyone tell the option to change the file type in unix. i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format. Thanks in advance, Milton. (1 Reply)
Discussion started by: miltony
1 Replies
Login or Register to Ask a Question