Password Protect Excel or CSV File

[stevesimo]

Hi, my client has asked me to generate a CSV file or Excel file which is straight forward enough to do.  The complication is that they have asked if the file can be password protected.  Does anyone know how I could achieve this.  Is it actually possible to do this with PHP? 

 

Any advice on this subject would be appreciated.

 

Steve 

[Mark Baker]

Hi, my client has asked me to generate a CSV file or Excel file which is straight forward enough to do.  The complication is that they have asked if the file can be password protected.  Does anyone know how I could achieve this.  Is it actually possible to do this with PHP?

About the only way to password protect a text file such as a CSV would be to zip it up in a password-protected zip.

 

If you want to write the data to an Excel file, that can be password-protected.

[DarkerAngel]

This can also be done with PHP, but I'm not going to write [all] the code for you.

 

<?php
/** User Check / Login Code / Password Check **/

if( file_exist($_GET['file']) ) {
  header('Content-Length: '.filesize($_GET['file']);
  header("Content-Disposition: attachment; filename=\"{$_GET['file']}\"");
  header('Content-type: application/vnd.ms-excel');
  readfile($_GET['file']);
}