Visit The New, Modern Unix Linux Community


Thread Tools Search this Thread
Top Forums Shell Programming and Scripting CSV to XLS
# 1  

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 convert to XLS. Meaning changing from comma separated to separate columns.
Then the graphs can get appropriate data from the row's and columns and everything looks the way the Economy folk's want it.

What I want is to automate this somehow so that we don't manually need to do the conversion from CSV to XLS.
Is there any way to do this?
I cant install homemade lib's or anything not supported on production environments without going threw RFC process.

However I am able to do whatever on my local machine after I downloaded the file's. (Ubuntu desktop)

If anyone has an idea or knows of a way to solve this. Tips are welcome.

So far I have found things like this with google, but it isn't what I'm looking for.
Convert CSV to excel File

Here is a small example of how the CSV file's look like
      Average inc Pegged,   0.94       Latency 99.5th percentile, 2.19       Latency 99th percentile, 1.85       Latency 90th percentile, 1.31       Latency 50th percentile, 0.92       Min duration (ms), 0.13       Minduration at, 15:31:03       Max duration (ms), 88.43       Maxduration at, 08:02:22       Max tps, 578       Max tps at,  9:37: 4

# 2  
perl has Spreadsheet::WriteExcel module .
It produces xls files .
# 3  
or another manual way is to,

have it as CSV file
open the CSV file in excel specifying it as CSV and mention the delimiters for CSV, that should do it.

But the best way is to use CPAN module for manipulating excel sheets
# 4  
(code) (was

This and some sed scripting solved my problems.
I did a sed script to remove a space after the comma sign which made my values corrupt in the Final excel sheet.
Now I run a script from my local machine that grabs the files then sed them and then convert to xls...
Then I can email to Economy ppl Smilie

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #571
Difficulty: Medium
A simple units bug in the Mars Climate Orbiter caused an error which resulted in loses of over $125M USD in 1999.
True or False?

10 More Discussions You Might Find Interesting

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

2. 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... (3 Replies)
Discussion started by: skhichi
3 Replies

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

4. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

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

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

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

8. Shell Programming and Scripting

.xls to .csv conversion

Hi Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix. many thanks, neil (4 Replies)
Discussion started by: neil546
4 Replies

9. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 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

Featured Tech Videos