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.
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.