aspose file tools*
The moose likes JDBC and the fly likes excel as a database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "excel as a database" Watch "excel as a database" New topic
Author

excel as a database

victor shon
Greenhorn

Joined: Dec 18, 2007
Posts: 1
hi,
i am developing a java app, where i need to use Excel as the database. the difficulty that i facing is that,the Excel is stored in another computer on the same network.The Excel is in "Shared" mode. cud you pls help me with suitable steps and also if possible give me a some basic code to solve this
thank you

[edited to use a meaningful subject line - was "Victor"]
[ December 23, 2007: Message edited by: Jeanne Boyarsky ]
Walter Bernstein
Ranch Hand

Joined: Dec 19, 2007
Posts: 57
Check POI for Excel access: http://poi.apache.org/
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
I'm sure you're aware that there are better methods of storing data than Excel, e.g. relational databases. Can you question the requirement of misusing Excel as a database?


Ping & DNS - updated with new look and Ping home screen widget
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29241
    
139

Victor,
Welcome to JavaRanch!

Is that "other computer" a server or someone else's PC? If the later, do you have a requirement for what should happen when the other computer is unavailable.

If the Excel file is in CSV, you can just use Java parsing. If it is a true Excel file, POI is good for reading. I agree with Ulf that Excel isn't a database and you should avoid using it as such.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Hendy Setyo Mulyo
Ranch Hand

Joined: Dec 01, 2004
Posts: 219

There are other options than using Jakarta POI.
You may also have a look at Andy Khan's Java Excel API or Nilostep xlsql Excel JDBC Driver.
Use Google with keywords 'excel jdbc ' or 'java excel'


Hendy Setyo Mulyo
SCJP 1.4 (95%), SCWCD 1.4 (94%)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: excel as a database
 
Similar Threads
[URGENT]Java Excel communication
Excel Data Population using Java
How to insert data from file excel into DB?
Reading XLS file
Write Data to Excel