public function PHPExcelTest::testIgnoreHeaders in PHPExcel 7.3
Same name and namespace in other branches
- 8.3 tests/phpexcel.test \PHPExcelTest::testIgnoreHeaders()
- 7.2 tests/phpexcel.test \PHPExcelTest::testIgnoreHeaders()
Test "ignore_headers" option.
File
- tests/
phpexcel.test, line 286 - Defines the test case for phpexcel
Class
- PHPExcelTest
- @file Defines the test case for phpexcel
Code
public function testIgnoreHeaders() {
// Prepare data.
$data = array(
0 => array(
array(
'Data 1.1.1',
'Data 1.1.2',
),
array(
'Data 1.2.1',
'Data 1.2.2',
),
array(
'Data 1.3.1',
'Data 1.3.2',
),
),
'Sheet 2' => array(
array(
'Data 2.1.1',
'Data 2.1.2',
),
array(
'Data 2.2.1',
'Data 2.2.2',
),
array(
'Data 2.3.1',
'Data 2.3.2',
),
),
);
// Create a file path.
$correct_path = file_create_filename($this
->getFilename(), $this->directory);
// The filename will be munged by the export function, so:
$this->test_files[] = $actual_path = phpexcel_munge_filename($correct_path);
// Should pass
$this
->assertEqual(PHPEXCEL_SUCCESS, phpexcel_export(NULL, $data, $correct_path, array(
'ignore_headers' => TRUE,
)), t('Exported data to !path', array(
'!path' => $actual_path,
)));
$this
->assertTrue(filesize($actual_path) > 0, 'Filesize should be bigger than 0');
// Import, not keyed by headers.
$data = phpexcel_import($actual_path, FALSE);
// Debug data.
$this
->verbose(print_r($data, 1));
$this
->assertTrue(!!$data, 'Import succeeded');
// Should have 3 rows.
$count = !empty($data[0]) ? count($data[0]) : 0;
$this
->assertTrue($count === 3, t('!count rows, expect 3', array(
'!count' => $count,
)));
// Should only have 2 cells.
$count = !empty($data[0][0]) ? count($data[0][0]) : 0;
$this
->assertTrue($count === 2, t('!count cells, expect 2', array(
'!count' => $count,
)));
$header = !empty($data[0][0][0]) ? $data[0][0][0] : 'no';
$this
->assertTrue($header === 'Data 1.1.1', t('!data, Should be "Data 1.1.1"', array(
'!data' => $header,
)));
$header = !empty($data[1][1][1]) ? $data[1][1][1] : 'no';
$this
->assertTrue($header === 'Data 2.2.2', t('Should be "Data 2.2.2"', array(
'!data' => $header,
)));
}