Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

generating report in Excel(Open office) using shell scripting

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting generating report in Excel(Open office) using shell scripting
# 1  
Old 06-02-2011
generating report in Excel(Open office) using shell scripting
Hello All,
I need to execute around 15 queries after which all data should come in Excel format.

Executing 15 queries is not a problem.
Problem is how to present/put data in excel.
kindly suggest me how to start, what to study or what should i do.

thanks,
# 2  
Old 06-02-2011
Usual easiest path is to turn it into Comma Separated Value (CSV) data using sed or such, and put it in a file with a csv or xls extension. If you need multiple worksheets in one file, things get more complex. There are PERL and JAVA apis for doing excel.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script for re-installation of open office

Below is the script for open office automatic re-installation, there are different versions on different servers the below script will check the version of the openoffice and will reinstall the same version(downloading for httpd server) the below code looks lengthy can we make it short ... (3 Replies)
Discussion started by: James0806
3 Replies

2. Solaris

Star/Libre/Open/???-Office for Solaris 11.2 ?

It's been a few years since this topic was last asked and answered.. curious whether anyone knows if the landscape has improved? looking for a more modern release of OpenOffice / LibreOffice / etc than the OOo-3.3 version mentioned in earlier posts from 2012. Would prefer not to compile from... (1 Reply)
Discussion started by: Yeaboem
1 Replies

3. Red Hat

Open office recommendation

NEED recommendation and assistance on getting open office source installation on redhat 6 linux . I want an open office on redhat 6 linux server . Dont have root access Can someone guide me ? (0 Replies)
Discussion started by: ajayram_arya
0 Replies

4. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies

5. Emergency UNIX and Linux Support

Error when trying to start open office

Hi all I am receivng following error while running openoffice on linux system Please suggest and linux comman which can remove this error: (I) x.org loaded video driver of... (II) Loading /usr/lib64/xorg/modules/drivers/intel_drv.so (==) Depth 24 pixmap format is 32 bpp (III) ... (2 Replies)
Discussion started by: manigrover
2 Replies

6. Shell Programming and Scripting

Novice in shell scripting - generating report

Hi I recently joined a project where I have been asked to generate a report using shell script accessing UNIX box. I have no idea on how to do it as I am a beginner and learning shell scripts. Suppose I have a XML: <XYZRequest> <effectiveDate>someDate</effectiveDate>... (2 Replies)
Discussion started by: vat1kor
2 Replies

7. Shell Programming and Scripting

shell scripting to export the results to an excel file

Hi, I am facing issues while exporting the results retrieved from the Database to an excel file. I have 5 count query in order to count the records in 5 different tables. I had connected to the DB and retrieved the column count and printed in the screen. But wat I need to do is, I... (8 Replies)
Discussion started by: Learner 20
8 Replies

8. Red Hat

how can i get open office package for Redhat Linux 5.0

Dear Team, Any body who have idea to down load the open office package for Redhat linux 5.0. Please send me the URL. so that i can easily down load from net. (2 Replies)
Discussion started by: sahu.tapan
2 Replies

9. UNIX for Dummies Questions & Answers

.ttf font installation in open office

How can we install new .ttf (Arial,Times new roman etc,) font in linux open office.org? (1 Reply)
Discussion started by: pcsaji
1 Replies
Login or Register to Ask a Question