EOT; $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString($xmldata); self::assertEquals(1, $spreadsheet->getSheetCount()); $sheet = $spreadsheet->getActiveSheet(); self::assertEquals('sheet 1', $sheet->getTitle()); self::assertTrue($sheet->getProtection()->isProtectionEnabled()); self::assertSame('protected', $sheet->getCell('A1')->getStyle()->getProtection()->getLocked()); self::assertSame('protected', $sheet->getCell('A1')->getStyle()->getProtection()->getHidden()); self::assertSame('protected', $sheet->getCell('B1')->getStyle()->getProtection()->getLocked()); self::assertSame('unprotected', $sheet->getCell('B1')->getStyle()->getProtection()->getHidden()); self::assertSame('unprotected', $sheet->getCell('C1')->getStyle()->getProtection()->getLocked()); self::assertSame('protected', $sheet->getCell('C1')->getStyle()->getProtection()->getHidden()); $spreadsheet->disconnectWorksheets(); } }