Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 05-19-2006, 03:13 AM   #1
LQ Newbie
Registered: May 2006
Posts: 6

Rep: Reputation: 0
How to read Excel 3.0 file in Linux


I am very new to Linux environment. Actually trying to shift my application from Windows to Linux.
I am getting some data from one URL in Excel 3.0 format & want to add it to database.
As I could not find any code which will read Excel 3.0 file, I converted it to Excel 97 using COM component on Windows.
Now for Linux how should I go about it? Is there any way to convert Excel 3.0 to Excel 97 . Or can you please tell me any way to read Excel 3.0 file.
Thanks in advance.

Old 05-19-2006, 04:15 AM   #2
Registered: Aug 2005
Posts: 235

Rep: Reputation: 30 is a Free Office Suite on Linux, which replicates much of the features of Microsoft Office (TM). Specifically, in place of MS Office's Excel, you want's Calc.

There are also other spreadsheet programs, such as kspread on KDE, etc.
Old 05-19-2006, 06:43 AM   #3
Wim Sturkenboom
Senior Member
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
What database are you using? You can save the excel file from OOo (or Excel) as a CSV file. You can specify a separator (at least in OOo) that will separate the fields from the 'record'. Just be carefull not to use one that already occurs in the fields.

Next you can load it into your database.
Old 05-19-2006, 10:16 AM   #4
LQ Newbie
Registered: Jul 2003
Location: France
Distribution: Arch Linux
Posts: 19

Rep: Reputation: 0
I personnaly use gnumeric to work with those kind of file
I find it lightweight and fast and you could use it more easily from your kbd than OOo Calc
Old 05-24-2006, 02:18 AM   #5
LQ Newbie
Registered: May 2006
Posts: 6

Original Poster
Rep: Reputation: 0

I do not want to open the file manually & save it as Excel 97/2000 file. But I want to do it using Java code.
Actually I use JXL to read the file & save data in My sql. But JXL only supports Excel 97 & above. Or is there any open source to
read Excel 3.0 file on linux?
One more thing I cannot save it as csv. When I get data from URL if I save it with extension "csv" & open it in text editor it shows garbage.
May I get some more information regarding "gnumeric" ?
Thanks a lot.


Last edited by veenaonnet; 05-24-2006 at 02:20 AM.
Old 05-24-2006, 02:41 AM   #6
LQ Guru
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 677Reputation: 677Reputation: 677Reputation: 677Reputation: 677Reputation: 677
Why do you need to use java? If you are accessing the files in a web browser, you could assign the mimetype to open with Open Office Calc. Then you can save them as a Native Open Office file type, or as a .csv file, or various other types. You can also export the file to either XHTML or as a PDF file.

Saving as from the browser and changing the extension, is only changing the name of the file, and not the filetype.

Using Google, I noticed a excell conversion program, but it is not open source.
Old 05-24-2006, 03:08 AM   #7
Wim Sturkenboom
Senior Member
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
So your only actual problem at this moment is to read the excel file. Can't help you with that at this moment. If you can't find a ready-made solution, you will have to analyze the format and write your own code.

With regards to the garbage mentioned above.
Not sure what you're doing, but I assume that you read the excel file and next save it with the extension 'csv'.
If so:
Just saving with the extension csv is not the same as 'save as' with type csv. The former still keeps it an excel file while the latter does a conversion. You have to convert it to csv and next save it with the extension CSV.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Culling Data from a CSV file to output in excel jterr02 Programming 2 05-19-2006 04:58 AM
excel file magically deleted? LarryFrigginWachs Linux - Newbie 6 12-13-2005 02:01 PM
convert text file to binary excel file ust Linux - General 2 11-23-2004 02:33 AM calc not multiplying my excel file np complete Linux - Software 0 10-15-2004 10:14 AM
how to recover MS-WORD and MS-EXCEL password protected file in Linux !!! hitesh_linux Linux - Software 1 07-15-2003 03:05 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:35 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration