/home/bdqbpbxa/api-uniferx.goodface.com.ua/vendor/rap2hpoutre/fast-excel/tests/FastExcelTest.php
<?php
namespace Rap2hpoutre\FastExcel\Tests;
use OpenSpout\Common\Entity\Style\Color;
use OpenSpout\Common\Entity\Style\Style;
use OpenSpout\Reader\XLSX\Options;
use Rap2hpoutre\FastExcel\FastExcel;
use Rap2hpoutre\FastExcel\SheetCollection;
/**
* Class FastExcelTest.
*/
class FastExcelTest extends TestCase
{
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testImportXlsx()
{
$collection = (new FastExcel())->import(__DIR__.'/test1.xlsx');
$this->assertEquals($this->collection(), $collection);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testImportCsv()
{
$original_collection = $this->collection();
$collection = (new FastExcel())->import(__DIR__.'/test2.csv');
$this->assertEquals($original_collection, $collection);
$collection = (new FastExcel())->configureCsv(';')->import(__DIR__.'/test1.csv');
$this->assertEquals($original_collection, $collection);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
private function export($file)
{
$original_collection = $this->collection();
(new FastExcel(clone $original_collection))->export($file);
$this->assertEquals($original_collection, (new FastExcel())->import($file));
unlink($file);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testExportXlsx()
{
$this->export(__DIR__.'/test2.xlsx');
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testExportCsv()
{
$this->export(__DIR__.'/test3.csv');
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testExcelImportWithCallback()
{
$collection = (new FastExcel())->import(__DIR__.'/test1.xlsx', function ($value) {
return [
'test' => $value['col1'],
];
});
$this->assertEquals(
collect([['test' => 'row1 col1'], ['test' => 'row2 col1'], ['test' => 'row3 col1']]),
$collection
);
$collection = (new FastExcel())->import(__DIR__.'/test1.xlsx', function ($value) {
return new Dumb($value['col1']);
});
$this->assertEquals(
collect([new Dumb('row1 col1'), new Dumb('row2 col1'), new Dumb('row3 col1')]),
$collection
);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
public function testExcelExportWithCallback()
{
(new FastExcel(clone $this->collection()))->export(__DIR__.'/test2.xlsx', function ($value) {
return [
'test' => $value['col1'],
];
});
$this->assertEquals(
collect([['test' => 'row1 col1'], ['test' => 'row2 col1'], ['test' => 'row3 col1']]),
(new FastExcel())->import(__DIR__.'/test2.xlsx')
);
unlink(__DIR__.'/test2.xlsx');
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
public function testExportMultiSheetXLSX()
{
$file = __DIR__.'/test_multi_sheets.xlsx';
$sheets = new SheetCollection([clone $this->collection(), clone $this->collection()]);
(new FastExcel($sheets))->export($file);
$this->assertEquals($this->collection(), (new FastExcel())->import($file));
unlink($file);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
public function testImportMultiSheetXLSX()
{
$collections = [
collect([['test' => 'row1 col1'], ['test' => 'row2 col1'], ['test' => 'row3 col1']]),
$this->collection(),
];
$file = __DIR__.'/test_multi_sheets.xlsx';
$sheets = new SheetCollection($collections);
(new FastExcel($sheets))->export($file);
$sheets = (new FastExcel())->importSheets($file);
$this->assertInstanceOf(SheetCollection::class, $sheets);
$this->assertEquals($collections[0], collect($sheets->first()));
$this->assertEquals($collections[1], collect($sheets->all()[1]));
unlink($file);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
public function testImportMultiSheetWithSheetNamesXLSX()
{
$collections = [
'Sheet with name A' => collect([['test' => 'row1 col1'], ['test' => 'row2 col1'], ['test' => 'row3 col1']]),
'Sheet with name B' => $this->collection(),
];
$file = __DIR__.'/test_multi_sheets_with_sheets_names.xlsx';
$sheets = new SheetCollection($collections);
(new FastExcel($sheets))->export($file);
$sheets = (new FastExcel())->withSheetsNames()->importSheets($file);
$this->assertInstanceOf(SheetCollection::class, $sheets);
$this->assertEquals($collections['Sheet with name A'], collect($sheets->get('Sheet with name A')));
$this->assertEquals($collections['Sheet with name B'], collect($sheets->get('Sheet with name B')));
unlink($file);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\InvalidArgumentException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
* @throws \OpenSpout\Writer\Exception\WriterNotOpenedException
*/
public function testExportWithHeaderStyle()
{
$original_collection = $this->collection();
$style = new Style();
$style->setFontBold();
$style->setFontSize(15);
$style->setFontColor(Color::BLUE);
$style->setShouldWrapText();
$style->setBackgroundColor(Color::YELLOW);
$file = __DIR__.'/test-header-style.xlsx';
(new FastExcel(clone $original_collection))
->headerStyle($style)
->export($file);
$this->assertEquals($original_collection, (new FastExcel())->import($file));
unlink($file);
}
/**
* @throws \OpenSpout\Common\Exception\IOException
* @throws \OpenSpout\Common\Exception\UnsupportedTypeException
* @throws \OpenSpout\Reader\Exception\ReaderNotOpenedException
*/
public function testImportXlsxWithCustomDateOption()
{
// Default options, dates will end parsed
$collection = (new FastExcel())->import(__DIR__.'/test-dates.xlsx');
$this->assertEquals(collect([
['col1' => new \DateTimeImmutable('2022-01-02 00:00:00.000000')],
['col1' => new \DateTimeImmutable('2022-01-03 00:00:00.000000')],
]), $collection);
$collection = (new FastExcel())
->configureOptionsUsing(function ($options) {
if ($options instanceof Options) {
$options->SHOULD_FORMAT_DATES = true;
}
})
->import(__DIR__.'/test-dates.xlsx');
$this->assertEquals(collect([
['col1' => '1/2/2022'],
['col1' => '1/3/2022'],
]), $collection);
}
}