Spreadsheet-WriteExcel Validation Lists

Posted on 2006-03-27 12:43:20-08 by maurice

I am using Spreadsheet::WriteExcel to take info from a database and generate a spreadsheet. Unfortinutally I find no way to create a Excel Validation List (Version 2003) (Drop down within a cell allowing a picklist of valid contents available) Is this functionality (is this a word) availabe in Spreadsheet WriteExcel or any associated componants Thanks for any input

Direct Responses: 2058 | Write a response

Posted on 2006-03-29 03:02:22-08 by genericman in response to 2046

Re: Spreadsheet-WriteExcel Validation Lists

According to postings that John McNamara made to the Spreadsheet-WriteExcel Google group, in-cell validation is not available in Spreadsheet::WriteExcel. It is planned for Spreadsheet::WriteExcelXML but I am not aware of a schedule for when it will be added to that module.

--
Jason

Direct Responses: Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.