Reputation: 366
I am curious to know if anyone has ever found a way to dynamically create a XLS, pre-populated with a drop down field on each row? For example if I wanted to provide a client with a list of all their employees and next to each employee's name is a drop down pre-filled with a list of positions (developer, marketing, designer) for the client to select. The client then could reupload the XLS providing me with this new information. The reason for the drop down field is to provide easy options for the client to select, rather then forcing them to type them all out or copy and paste through the list.
I have searched high and low through PHP classes and Google Docs API, but I have not found a way to accomplish this. Before I give up on this path I thought I would ask the community.
I appreciate any help you can provide.
Upvotes: 1
Views: 1912
Reputation: 366
Thanks to Waygood this provides me with a path forward:
http://phpexcel.codeplex.com/discussions/278878
Which is the best way to generate excel output in PHP?
Much appreciated!
Upvotes: 1