How to generate xls file in unix

Computing.Net > Forums > Unix > How to generate xls file in unix

How to generate xls file in unix

Original Message

Name: newtounix
Date: September 29, 2003 at 23:50:50 Pacific
Subject: How to generate xls file in unix
OS: Sun Solaris
CPU/Ram: E450

Comment:

Hi There
I have created a small script to extract data from an table and output to txt file. Since the table contains more 100 columns I want to select few main columns around 20 and then extract the data from the table. Now, how can I redirect the sql query output to an excel file??? Thanks for yoour kind help. BTW, I am using sybase database on Sun Solaris Unix.
cheers

Report Offensive Message For Removal

Response Number 1

Name: covina
Date: September 30, 2003 at 14:02:34 Pacific

Reply: (edit)

I don't think you can generate an xls file from unix. You spool a flat file and the file name should have .csv (comma delimited). Also, each columns from the database should be separated by (, i.e.,comma). Note: You have to the eliminate
all commas from your db columns. The excel reads .csv format file. After opening the csv file you have to save in xls format.

Report Offensive Follow Up For Removal

Response Number 2

Name: newtounix
Date: October 1, 2003 at 21:52:18 Pacific

Reply: (edit)

Hi
Thanks for your advice. If that is the case can you please tell me how to generate a csv file out of an sql query???
thanks for your kind help
cheers

Report Offensive Follow Up For Removal


how to read binary files in Unix How to Read .txt file and edit how to read a file how to span files in unix? how to replace a file in a .zip fil	Tips in creating files in UNIX How to conver a text file into .xls how to manage files in diskette in unix how to get fixed width file in unix Opening large log files in unix

Sorting in C

awk record too long

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: How to generate xls file in unix

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 5 Days.
Discuss in The Lounge

use of disk defragmenter?

Recording data

Share Interet XP to 2000

Bootable cd and start SIW

western digital 80GB HD problem.

All Posts Awaiting Replies