I use PhpSpreadsheet for read xlsx
file. How to open xlsx
passowrd protected file?
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('file.xlsx');
$spreadsheet->getSecurity()->setWorkbookPassword('111111');
$worksheet = $spreadsheet->getActiveSheet();