I am creating an online web voting web page. I have been informed that there is a java code that can be used to display data from an excel spreadsheet on a webpage. I have about 3000 rows of data and about 5 columns of data on the spreadsheet. I want to know how to use java to put all this information online. The reason for this is, I need to frequently change this excel spreadsheet annually and I do not want to hard code it in. Any suggestions will be useful, thank you.
You can also setup an ODBC connection to an Excel file and then just query ODBC much the same way as any other database.
Joined: May 30, 2005
yeah id sujgest using the jdbc-odbc brigde. I even have the code ready for such a thing. It can make use of any ODBC DSN so create one first. This one makes use of a MS Access database, but you could make it work with excel. Dont know it excel can do SELECT statments. Excel is a pretty messed up tool to be useing for a DB.