LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


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

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


Hi,

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.

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

Rep: Reputation: 30
OpenOffice.org 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 OpenOffice.org'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
Gnux
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
veenaonnet
LQ Newbie
 
Registered: May 2006
Posts: 6

Original Poster
Rep: Reputation: 0
Hi,

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.

Regards,
Veena

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

Rep: Reputation: 671Reputation: 671Reputation: 671Reputation: 671Reputation: 671Reputation: 671
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.
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 08:39 AM.

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