Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

excel as a database

 
victor shon
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check POI for Excel access: http://poi.apache.org/
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Hendy Setyo Mulyo
Ranch Hand
Posts: 219
Firefox Browser Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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'
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic