How to extract output from a script to .xls file

scriptlearner · #1 (**permalink**) 08-06-2007

Hi,

I am running a script, the output of which is needed to be filled in .xls file. I am doing this manually now, i mean I am writing the output of the script to Excel file manually. How to redirect the output of the script to .xls file? Please help me out!!!

Thanks much,
Scriptlearner.

lorcan · #2 (**permalink**) 08-06-2007

You can just format your output such that the values of the output are delimited to "," and are redirected to a CSV file.

So you can use to CSV file to view your output in the excel format

firdousamir · #3 (**permalink**) 08-06-2007

You mean you are copying outputs from the screen to an excel file?

You can format your outputs in CSV format (like lorcan suggested) and redirect the script out to a file say,

$ sh your_script.sh > your_output.csv

does that help?

scriptlearner · #4 (**permalink**) 08-07-2007

Hi,

Thanks a lot. Yep,it works if I am extracting output from .sh file. Actually I have one shell script i.e myscripts.sh, in which it calls other .sql scripts which are in my home directory. Actually I wanted the output of .sql scripts to .csv file. I tried to get the output of .sql to .csv, but it is throwing error. Can I redirect the output from myscripts.sh to myouput.csv?Is that possible? Please help me.

Thanks much in advance,
Scriptlearner.

lorcan · #5 (**permalink**) 08-07-2007

You cannot redirect the SQL queries to the files. Instead you can use the spool concept in ORACLE (hope Oracle is the database).

Spool your output such that the records are comma separated.

something like the below;

Code:

select sysdate||","|| sysdate from dual;
spool on;
/
spool off;

This will have the output from the sql command into the Spool file.

scriptlearner · #6 (**permalink**) 08-10-2007

Thanks a lot for your help. I got that. Initially I got problem coz my.sql script had control characters in it. Now it is working fine.

Thanks a lot,
Scriptlearner.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to extract paragraphs from file in BASH script followed by prefix ! , !! and !!!	nabmufti	Shell Programming and Scripting	6	02-09-2008 08:32 PM
Script that extract some lines from a file lookin into another	heartwork	Shell Programming and Scripting	7	01-25-2008 06:57 AM
compare file size from a output file from a script	moustik	Shell Programming and Scripting	7	11-07-2007 10:17 AM
Extract text in 2 columns of output file.	Danish Shakil	Shell Programming and Scripting	2	10-19-2007 11:03 AM
Script to Extract the line from File with specified offset	thinakarmani	UNIX for Advanced & Expert Users	5	05-04-2006 06:50 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by