hidden row and hidden column hidden row and visible column visible row and hidden column visible row and visible column EOT; $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString($xmldata); self::assertEquals(1, $spreadsheet->getSheetCount()); $sheet = $spreadsheet->getActiveSheet(); self::assertEquals('1', $sheet->getTitle()); self::assertFalse($sheet->getColumnDimension('A')->getVisible()); self::assertTrue($sheet->getColumnDimension('B')->getVisible()); self::assertTrue($sheet->getColumnDimension('C')->getVisible()); self::assertFalse($sheet->getRowDimension(1)->getVisible()); self::assertTrue($sheet->getRowDimension(2)->getVisible()); self::assertTrue($sheet->getRowDimension(3)->getVisible()); $spreadsheet->disconnectWorksheets(); } }