• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1352
  • Last Modified:

PHP export data to excel with filter enabled & protected file

Dear:

Does is possible using PHP script to export data into excel with filter enabled & protected file?
or export to excel with VBA embedded?

Thank you.

Best Regard
0
simonlai
Asked:
simonlai
  • 2
1 Solution
 
hernst42Commented:
PHP Excel should be able to create filters and protect files. See examples on http://phpexcel.codeplex.com/wikipage?title=Examples&referringTitle=Home
0
 
simonlaiAuthor Commented:
Dear Hernst:

this only working for Excel 2007 but not excel 2003.

Thank you.
0
 
Ray PaseurCommented:
It may be possible, but it sounds like a huge R&D task.  What would be the problem with having things work for Excel 2007?  Excel 2007 is the more current version of the product.
0
 
simonlaiAuthor Commented:
The PHP class was not support for Excel 2003 and below.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now