For Programmers: Free Programming Magazines  


Home > Archive > PERL Beginners > February 2006 > Creating dropdown using Perl









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Creating dropdown using Perl
Saikat

2006-02-21, 7:55 am

Hi,
I want to create a dropdown list in a cell in the excel file using
perl.
Can anybody help?
I have sending the code I have tried - its not working!

$val = $sheet->Range("F14")->Validation;
$val->Add( {Type=>xlValidateList, Formula1=>"abc,xyz"} );
$val->{IgnoreBlank} = 1;
$val->{InCellDropdown} = 1;

Thanks in advance,
-- Saikat

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com