• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

excel as a database

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Check POI for Excel access: http://poi.apache.org/
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 219
Firefox Browser Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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'
 
reply
    Bookmark Topic Watch Topic
  • New Topic