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.

In reply to Re^2: Drop down list box in Spreadsheet by kaiser_naren
in thread Drop down list box in Spreadsheet by kaiser_naren

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.