Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


CSV to XLS


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
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 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
Code:
      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

# 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) text2xls.pl (was csv2xls.pl)

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
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

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. Shell Programming and Scripting

csv to xls : missing rows

A unix script generates a file "1.csv". I use the following to email this as an excel sheet. /usr/bin/uuencode /tmp/1.csv 1.csv > $PATH/attachment.txt mailx -r abc@domain.com -s "Subject" myself@domain.com < $PATH/attachment.txtI get the file as CSV in the email and everything is fine except... (9 Replies)
Discussion started by: girish1428
9 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