Linux - NewbieThis 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!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
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.
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.
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.
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.
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'.
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.