Hi Kyle,

I am developing a web interface for chip designers which, besides other functions, helps them in keeping track of the status of some of their testcases.

The data is stored in a MySQL database and shown on a web page using Template Toolkit. The table has columns like, Testcase Name, Owner, Status, etc. I provide a link to the users to download this info as a Spreadsheet/MS Excel file. I write the data into the Spreadsheet using WriteExcel module.

There is a new requirement that I should provide drop down list boxes in the Status column of the Spreadsheet containing values like '0% completed', '25% completed', etc., which the user can select according to the progress of the testcase(in the downloaded file).

So I would like to know if it is possible to have such drop down boxes for the 'Status' columns for each of the testcases which will contain values I can specify.

I have gone through the WriteExcel module and found the option 'autofilter' which is basically used to filter the rows based on the value selected in one of the Heading columns. But this does not help my situation as I can not specify values in the drop down list of my own. It just can accept a range of cell values already in the Spreadsheet.

Hope I explained my problem clearly. Please let me know if it is not clear yet. Thanks for the help.

Cheers,
Naren.