12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 |
- <?php
- namespace Tests\Exporters\CSV;
- use Dcat\EasyExcel\Excel;
- use Tests\Exporters\Exporter;
- use Tests\TestCase;
- class WithArrayTest extends TestCase
- {
- use Exporter;
- /**
- * @group exporter
- */
- public function testStore()
- {
- $users = include __DIR__.'/../../resources/users.php';
- $storePath = $this->generateTempFilePath('csv');
- // 保存
- Excel::export($users)->store($storePath);
- // 读取
- $this->assertSingleSheet($storePath, 0, $users);
- /*
- |---------------------------------------------------------------
- | 测试多个sheet
- |---------------------------------------------------------------
- */
- $users1 = array_slice($users, 0, 30);
- $users2 = array_values(array_slice($users, 30, 30));
- $storePath = $this->generateTempFilePath('csv');
- // 保存
- Excel::export(['sheet1' => $users1, 'sheet2' => $users2])->store($storePath);
- $this->assertSingleSheet($storePath, 0, $users);
- }
- /**
- * @group exporter
- */
- public function testRaw()
- {
- $users = include __DIR__.'/../../resources/users.php';
- $storePath = $this->generateTempFilePath('csv');
- // 获取内容
- $contents = Excel::csv($users)->raw();
- $this->assertIsString($contents);
- // 保存文件内容
- file_put_contents($storePath, $contents);
- // 判断内容是否正确
- $this->assertSingleSheet($storePath, 0, $users);
- /*
- |---------------------------------------------------------------
- | 测试多个sheet
- |---------------------------------------------------------------
- */
- $users1 = array_slice($users, 0, 30);
- $users2 = array_values(array_slice($users, 30, 30));
- $storePath = $this->generateTempFilePath('csv');
- // 获取内容
- $contents = Excel::csv(['sheet1' => $users1, 'sheet2' => $users2])->raw();
- $this->assertIsString($contents);
- // 保存文件内容
- file_put_contents($storePath, $contents);
- // 判断内容是否正确
- $this->assertSingleSheet($storePath, 0, $users);
- }
- }
|