Sponsored Content
Top Forums Shell Programming and Scripting generating report in Excel(Open office) using shell scripting Post 302527152 by DGPickett on Thursday 2nd of June 2011 04:26:31 PM
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.
 

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

9. 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
PYEXCELERATOR(1)					      General Commands Manual						  PYEXCELERATOR(1)

NAME
pyexcelerator - a module for reading/writing Excel spreadsheet files SYNOPSIS
pyexcelerator DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page. pyExcelerator is a Python module that can generate Excel 97/2000/XP/2003 spreadsheet files. It can also extract data from these files. It supports Unicode in Excel files, and can use a variety of formatting features and printing options. It can dump Excel and OLE2 compound files. Numerous examples of usage can be found in the examples/ directory. Additions utility scripts can be found in the tools/ directory. OPTIONS
This program does not take any command line options. AUTHOR
pyexcelerator was written by Roman V. Kiseliov <roman@kiseliov.ru>. This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. SEE-ALSO py_xls2csv(1), py_xls2txt(1), py_xls2html(1) October 12, 2006 PYEXCELERATOR(1)
All times are GMT -4. The time now is 10:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy