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