How to generate password protected Excel file using PHP? [duplicate]

Question

I am trying to create password protected excel file using PHP. Tried many options including PHPExcel library, but its not preventing from Excel from reading. Whenever user tries to open Excel, i need to ask password. I can not go with zipping the file and adding password to it, as suggested in many forums.

Is there any other option ?

I didn't get any such code yet. I tried PHPExcel library but it prevents only file modification (i.e. user can still read file but can not modify without password). — user4119828
– user4119828, Commented Oct 8, 2014 at 5:37
My Sample Code : $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello'); $objPHPExcel->getActiveSheet()->SetCellValue('B1', 'world!'); $objPHPExcel->getSecurity()->setLockWindows(true); $objPHPExcel->getSecurity()->setLockStructure(true); $objPHPExcel->getSecurity()->setWorkbookPassword('1234'); $objPHPExcel->getActiveSheet()->setTitle('Reports'); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('Reports.xlsx'); — user4119828
– user4119828, Commented Oct 8, 2014 at 5:38
If I remember correctly PhpSpreadsheet only supports protecting data changes, not reading. If you need something like that, you'd probably need to go the password-protected zip route. You can try someone within the PhpSpreadsheet community knows more. github.com/Maatwebsite/Laravel-Excel/issues/3152 github.com/Maatwebsite/Laravel-Excel/discussions/3151 — Gulshan Prajapati
– Gulshan Prajapati, Commented May 12, 2021 at 7:56

Mark Baker · Accepted Answer · 2014-10-08 07:19:54Z

1

PHPExcel does not support writing password-protected files so that they cannot be read without entering the password; the password protection features in PHPExcel are only to prevent editing of data, changing the structure of the worksheets, etc

answered Oct 8, 2014 at 7:19

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mark Baker Over a year ago

I'll take your word for it then.... I wasn't aware that I'd implemented password protection for opening files

Gulshan Prajapati Over a year ago

If I remember correctly PhpSpreadsheet only supports protecting data changes, not reading. If you need something like that, you'd probably need to go the password-protected zip route. You can try someone within the PhpSpreadsheet community knows more. github.com/Maatwebsite/Laravel-Excel/issues/3152 github.com/Maatwebsite/Laravel-Excel/discussions/3151

Community · Accepted Answer · 2017-05-23 12:29:43Z

-2

There is a duplicate of It I hope?

Go Here

$reader = new PHPExcel_Reader_Excel2007;
$workbook =  $reader->load("document.xlsx");
$workbook->-getActiveSheet()->getSecurity()->setWorkbookPassword("your password");

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Oct 8, 2014 at 5:28

Jenno Richi Benat

6715 silver badges23 bronze badges

2 Comments

user4119828 Over a year ago

Thanks for response. I already tried this, but it prevents only file modification.

Gulshan Prajapati Over a year ago

If I remember correctly PhpSpreadsheet only supports protecting data changes, not reading. If you need something like that, you'd probably need to go the password-protected zip route. You can try someone within the PhpSpreadsheet community knows more. github.com/Maatwebsite/Laravel-Excel/issues/3152 github.com/Maatwebsite/Laravel-Excel/discussions/3151

Community · Accepted Answer · 2017-05-23 12:06:16Z

-2

Try this

    $objPHPExcel->getSecurity()->setLockWindows(true);
    $objPHPExcel->getSecurity()->setLockStructure(true);

    $objPHPExcel->getSecurity()->setWorkbookPassword('secret');

for worksheet security:it is working for me!

    $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
    $objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
    $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
    $objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);

    $objPHPExcel->getActiveSheet()->getProtection()->setPassword('password');

but for work book security,phpExcel have a issue i think, still exploring

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Oct 8, 2014 at 5:49

Jangya satapathy

9069 silver badges20 bronze badges

1 Comment

Jangya satapathy Over a year ago

No dear nothing related to os.Because i am using windows and when trying to do this the worksheet is working fine but the workbook password is not working.your approaching is correct.once try for the worksheet.

Collectives™ on Stack Overflow

How to generate password protected Excel file using PHP? [duplicate]

3 Answers 3

2 Comments

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Linked

Related