This repository has been archived by the owner on Jul 16, 2021. It is now read-only.
/
PHPExcelTest.php
103 lines (72 loc) · 2.49 KB
/
PHPExcelTest.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<?php
namespace Aimeos\MW\Container;
/**
* @license LGPLv3, http://www.gnu.org/licenses/lgpl.html
* @copyright Metaways Infosystems GmbH, 2013
* @copyright Aimeos (aimeos.org), 2015-2018
*/
class PHPExcelTest extends \PHPUnit\Framework\TestCase
{
protected function setUp()
{
if( !class_exists( '\PHPExcel' ) ) {
$this->markTestSkipped( 'PHPExcel not available' );
}
}
public function testExistingFile()
{
$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';
new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
}
public function testNewFile()
{
$filename = __DIR__ . DIRECTORY_SEPARATOR . 'tempfile';
$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
$container->close();
$result = file_exists( $container->getName() );
unlink( $container->getName() );
$this->assertTrue( $result );
$this->assertEquals( '.xls', substr( $container->getName(), -4 ) );
$this->assertFalse( file_exists( $container->getName() ) );
}
public function testFormat()
{
$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'Excel2007', [] );
$this->assertEquals( '.xlsx', substr( $container->getName(), -5 ) );
$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'OOCalc', [] );
$this->assertEquals( '.ods', substr( $container->getName(), -4 ) );
$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'CSV', [] );
$this->assertEquals( '.csv', substr( $container->getName(), -4 ) );
}
public function testAdd()
{
$filename = __DIR__ . DIRECTORY_SEPARATOR . 'tempfile';
$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
$container->add( $container->create( 'test' ) );
$result = 0;
foreach( $container as $content ) {
$result++;
}
$container->close();
unlink( $container->getName() );
$this->assertEquals( 1, $result );
}
public function testGet()
{
$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';
$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
$this->assertInstanceOf( '\\Aimeos\\MW\\Container\\Content\\Iface', $container->get( 'Sheet2' ) );
$this->setExpectedException( '\\Aimeos\\MW\\Container\\Exception' );
$container->get( 'abc' );
}
public function testIterator()
{
$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';
$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
$result = 0;
foreach( $container as $key => $content ) {
$result++;
}
$this->assertEquals( 3, $result );
}
}