510', $data); } } public function testValidData(): void { $reader = new Xlsx(); $spreadsheet = $reader->load(self::$testbook); $sheet = $spreadsheet->getActiveSheet(); self::assertSame('between', $sheet->getCell('A1')->getDataValidation()->getOperator()); $validator = new DataValidator(); self::assertTrue($validator->isValid($sheet->getCell('A1'))); $sheet->getCell('A1')->setValue(3); self::assertFalse($validator->isValid($sheet->getCell('A1'))); $sheet->getCell('A1')->setValue(7); self::assertTrue($validator->isValid($sheet->getCell('A1'))); $spreadsheet->disconnectWorksheets(); } }