Mail csv to xls in Shell Script

Tags

shell scripts

Top Forums Shell Programming and Scripting Mail csv to xls in Shell Script

11-17-2011

Registered User

30, 0

Join Date: Nov 2011

Last Activity: 8 July 2013, 3:09 AM EDT

Posts: 30

Thanks Given: 0

Thanked 0 Times in 0 Posts

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

Thanks

skhichi

View Public Profile for skhichi

Find all posts by skhichi

11-17-2011

Registered User

833, 187

Join Date: Jul 2008

Last Activity: 9 March 2016, 9:36 AM EST

Posts: 833

Thanks Given: 9

Thanked 187 Times in 177 Posts

Double post .. https://www.unix.com/unix-advanced-ex...xls-shell.html

jayan_jay

View Public Profile for jayan_jay

Find all posts by jayan_jay

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script for converting to xls and to mail the same

i have installed CENTOS in VMware. I want the linux command to run in CENTOS. The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script. Thanks, Shobana

2. 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.

3. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl...

4. 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?

5. UNIX for Advanced & Expert Users

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 ";". unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid...

6. 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...

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

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

9. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me.

10. 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

Shell Programming and Scripting