Login   Register  
PHP Classes
elePHPant
Icontem

write out an xls drop-down

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      Spreadsheet_WriteExcel  >  All threads  >  write out an xls drop-down  >  (Un) Subscribe thread alerts  
Subject:write out an xls drop-down
Summary:Is it possible to generate an xls with a drop-down list?
Messages:2
Author:Tim Riley
Date:2010-08-26 20:54:43
Update:2010-08-27 19:24:20
 

  1. write out an xls drop-down   Reply   Report abuse  
Picture of Tim Riley
Tim Riley
2010-08-26 20:54:43
Is it possible to use the package Spreadsheet_WriteExcel to generate an xls with a drop-down list?

I am attempting to create an xls file that contains dropdown lists of valid values for some columns. It looks like the perl module Spreadsheet::WriteExcel this library is ported from does support validation/dropdown lists. Does the php Spreadsheet_WriteExcel library have support for data validation and dropdown lists?

If so: is there any sample code for how to create a dropdown?
If not: does anyone know of any other php->xls libraries that have support for validation/dropdown lists?

TIA,
Tim



  2. Re: write out an xls drop-down   Reply   Report abuse  
Picture of Tim Riley
Tim Riley
2010-08-27 19:24:20 - In reply to message 1 from Tim Riley
I have found an alternate php library for writing out excel files with validation/dropdowns: phpExcel http://phpexcel.codeplex.com

My existing application uses SpreadSheet_WriteExcel so I would rather continue to use it if it has support for validation/dropdowns.

Does anyone know if SpreadSheet_WriteExcel supports validation/dropdowns?
IS phpExcel a good alternative if not?

TIA,
Tim