Admin Nasledstvo
45 lines
1.1 KiB
PHP
45 lines
1.1 KiB
PHP
<?php
|
|
/**
|
|
* Created by PhpStorm.
|
|
* User: W10
|
|
* Date: 2/17/2021
|
|
* Time: 3:24 PM
|
|
*/
|
|
|
|
namespace app\widgets\services;
|
|
|
|
|
|
use app\extensions\simplex\SimpleXLSX;
|
|
use app\extensions\XLSXWriter;
|
|
use app\extensions\XLSXReader;
|
|
|
|
class XLSx
|
|
{
|
|
public static function toXlsWriter($data, $fileName, $sheet, $header)
|
|
{
|
|
$headerRow = [];
|
|
foreach ($header as $headerTitle => $headerElement) $headerRow[] = $headerTitle;
|
|
|
|
$filename = $fileName . '.csv';
|
|
header('Content-Type: text/csv');
|
|
header('Content-Disposition: attachment; filename="' . $filename . '"');
|
|
$dataAsString = implode(';', $headerRow) . "\r\n";
|
|
foreach ($data as $row) {
|
|
$dataAsString .= implode(';', $row) . "\r\n";
|
|
}
|
|
echo $dataAsString;
|
|
exit;
|
|
}
|
|
|
|
|
|
public static function toArrayWriter($targetFile, $sheet)
|
|
{
|
|
try {
|
|
$xlsx = new XLSXReader($targetFile);
|
|
return $xlsx->getSheetData($sheet);
|
|
} catch (\Exception $e) {
|
|
return ['error' => 'The Sheet not exists in this file'];
|
|
}
|
|
}
|
|
}
|