This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
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 ]
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?
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.
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'
0
