Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)
Top Forums Shell Programming and Scripting HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle) Post 302431654 by bakunin on Tuesday 22nd of June 2010 11:44:39 AM
Old 06-22-2010
Set aside that there are several "Excel formats", as the thing chanes its output with every (sub-)release: the native Excel format is not standardized at all and many aspects of it are undisclosed information by Microsoft, so all the information about its format out there in the net are mostly the fruit of (more or less accurate) reverse engineering.

It is doubtful that there is any gain in converting the output to Excel format with any other tool than Excel itself - just feed it a CSV-file and hope for the best (as you should anyways, using M$$-Office).

If you still want to undergo the exertion, you might want to read this document:

http://sc.openoffice.org/excelfileformat.pdf

I hope this helps.

bakunin
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

2. Programming

How to create java based dictionary for mobile using data in microsoft excel?

i am having a ms excel file which contains 2 columns, I first column i added words, and in second column meaning to the word in the first column. I want to create a dictionary for mobile like nokia or any java based application running mobile. How it can be created as i, dont know the java... (1 Reply)
Discussion started by: Anna Hussie
1 Replies

3. Red Hat

HOWTO transfer Hosts in excel sheet to file in LINUX?

Hi guys! I have around 300 hostsname is excelsheet in one column. These hosts I want to add in one file in linux one after the another like hostname1,hostname2.hostname3, I don't want to waste enter it manually it very time consuming, so how to transfer these files from excelsheet to a... (1 Reply)
Discussion started by: manalisharmabe
1 Replies

4. Shell Programming and Scripting

Perl : not capturing all the data from excel sheet

Hi folks, I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month. If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies

5. Programming

converting data from excel sheet to oracle using toad

guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

6. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

Hi, i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks Regards, Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies

7. UNIX for Dummies Questions & Answers

UNIX data to be updated to ms excel sheet

hi, i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies

8. Shell Programming and Scripting

Save log data in excel sheet

Hello, I have the following data format in a log file : a : x1 b : x2 c : x3 d : x4 -------- a : x5 b : x6 c : x7 d : x8 so the same fields ( a ,b ,c,d) repeated many times in the same log file but with different "x" values (x5,x6,x7,x8). I need a script to save this data in an... (6 Replies)
Discussion started by: mm00123
6 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Programming

Sql developer how to upload the excel sheet in Oracle table

I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records. (4 Replies)
Discussion started by: ramkumar15
4 Replies

LEARN ABOUT SUSE

ooconvert

ooconvert(1)							   User Commands						      ooconvert(1)

Name
       ooconvert - Commandline Document Converter Using OpenOffice.org

SYNOPSIS

       ooconvert [--help] [--force]  input output

DESCRIPTION

       This  tool  converts documents between various formats on the commandline.  It uses OpenOffice.org that guarantees the quality of available
       import and export filters.

       This tool tries to start OpenOffice.org in the server mode on backgroud.  It does not work if the OpenOffice.org  application  has  already
       been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions.

OPTIONS

       input  Input file. The filename suffix must be one of the currently supported file formats, see below.

       output Output  file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over-
	      written by the --force option.

       --help Print help and exit.

       --force
	      Force an already existing output file to be replaced.

SUPPORTED FILE FORMATS

       The current version of this tool does not read the list of available input and output filters directly from  OpenOffice.org.  The  list	of
       supported file formats is hardcoded and thus limited to:

       doc    Microsoft Word 97/2000/XP

       docx   MS Word 2007 XML

       dot    Microsoft Word 97/2000/XP Template

       dotx   MS Word 2007 XML Template

       html   HyperText Markup Language (Web Page)

       odt    ODF Text Document

       ods    ODF Spreadsheet

       odp    ODF Presentation

       ott    ODF Text Document Template

       ots    ODF Spreadsheet Template

       otp    ODF Presentation Template

       pdf    Portable Document Format

       ppt    Microsoft PowerPoint 97/2000/XP

       pptx   Microsoft PowerPoint 2007 XML

       pot    Microsoft PowerPoint 97/2000/XP Template

       potx   Microsoft PowerPoint 2007 XML Template

       rtf    Rich Text Format

       stc    OpenOffice.org 1.0 Spreadsheet Template

       sti    OpenOffice.org 1.0 Presentation Template

       stw    OpenOffice.org 1.0 Text Document Template

       sxc    OpenOffice.org 1.0 Spreadsheet

       sxi    OpenOffice.org 1.0 Presentation

       sxw    OpenOffice.org 1.0 Text Document

       swf    Macromedia Flash

       txt    Plain Text

       xls    Microsoft Excel 97/2000/XP

       xlsx   Microsoft Excel 2007 XML

       xlt    Microsoft Excel 97/2000/XP Template

       xltx   Microsoft Excel 2007 XML Template

TROUBLESHOOTING PROBLEMS

       See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org.

AUTHOR

       This manual page was created by Petr Mladek <petr.mladek@novell.com>.

OpenOffice.org Converter					    2009-02-09							      ooconvert(1)
All times are GMT -4. The time now is 01:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy