PHP export data to excel with filter enabled & protected file

Posted on 2011-05-04
Last Modified: 2012-08-14

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
Question by:simonlai
    LVL 48

    Accepted Solution

    PHP Excel should be able to create filters and protect files. See examples on
    LVL 1

    Author Comment

    Dear Hernst:

    this only working for Excel 2007 but not excel 2003.

    Thank you.
    LVL 107

    Expert Comment

    by:Ray Paseur
    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.
    LVL 1

    Author Closing Comment

    The PHP class was not support for Excel 2003 and below.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
    Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
    The viewer will learn how to dynamically set the form action using jQuery.
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now