I am having a problem with this...please feel free to throw some light and all your input will be much appreciated.
I want a servlet to generate a MS Excel spreadsheet with formatted cells and the user/client should be able to download that spreadsheet and then make modifications to the spreadsheet and load up the spreadsheet data by clicking on another link so that the spreadsheet data is uploaded into my DB2 database. The basic goal here is to restrict the user from entering invalid data into the spreadsheet. I have written applications where I could load up the spreadsheet into DB2 but I had to make sure all the data in the spreadsheet is valid. Any suggestions will be much appreciated.