CSV to XLS Post: 302384135

Sponsored Content

Top Forums Shell Programming and Scripting CSV to XLS Post 302384135 by chipmunken on Monday 4th of January 2010 06:22:02 AM

01-04-2010

Registered User

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

chipmunken

View Public Profile for chipmunken

Find all posts by chipmunken

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh

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

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

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

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

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

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

LEARN ABOUT SUSE

pfsclamp

pfsclamp(1)						      General Commands Manual						       pfsclamp(1)

NAME

       pfsclamp - Clamp color and luminance channel values to be within the specified range

SYNOPSIS

       pfsclamp [--min <minimum>] [--max <maximum>] [--percentile] [--zero] [--rgb]

DESCRIPTION

       Use  this command to clamp values of luminance and color channels to be within the specified range. I.e. if a value in the channel is above
       the specified maximum or below specified minimum, set the value to either minimum or maximum.

       The command operates directly on XYZ channels.

OPTIONS

       --min <val>

	      Lower bound for clamping. Default value: 0.0001 (10^-4)

       --max <val>

	      Upper bound for clamping. Default value: 100000000 (10^8)

       --percentile, -p

	      Treat given min and max values as a percentile.

       --zero, -z

	      Set values out of clamping range to zero, instead of setting to specified maximum and minimum.

       --rgb

	      Perform clamping in RGB space.

EXAMPLES

       pfsin memorial.hdr | pfsclamp | pfsout memorial_cl.hdr

	      Remove possible out-of-range values, for examples zeros, from memorial image.

       pfsin memorial.hdr | pfsclamp --max 0.95 -p | pfsout memorial_cl.hdr

	      Remove 5% of the brightest pixels from the original image.

SEE ALSO

       pfsin(1) pfsout(1)

BUGS

       Please report bugs and comments to Rafal Mantiuk <mantiuk@mpi-sb.mpg.de> and Grzegorz Krawczyk <krawczyk@mpi-sb.mpg.de>.

																       pfsclamp(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Discussion started by: miltony

2. Shell Programming and Scripting

From xls to csv file

Discussion started by: sureshg_sampat

3. Shell Programming and Scripting

.xls to .csv conversion

Discussion started by: neil546

4. Shell Programming and Scripting

xls to csv

Discussion started by: infyanurag