Csv.php

Go to the documentation of this file.

<?php
 
namespace PhpOffice\PhpSpreadsheet\Writer;
 
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
 
class Csv extends BaseWriter
{
    private $spreadsheet;
 
    private $delimiter = ',';
 
    private $enclosure = '"';
 
    private $lineEnding = PHP_EOL;
 
    private $sheetIndex = 0;
 
    private $useBOM = false;
 
    private $includeSeparatorLine = false;
 
    private $excelCompatibility = false;
 
    private $outputEncoding = '';
 
    public function __construct(Spreadsheet $spreadsheet)
    {
        $this->spreadsheet = $spreadsheet;
    }
 
    public function save($pFilename): void
    {
        // Fetch sheet
        $sheet = $this->spreadsheet->getSheet($this->sheetIndex);
 
        $saveDebugLog = Calculation::getInstance($this->spreadsheet)->getDebugLog()->getWriteDebugLog();
        Calculation::getInstance($this->spreadsheet)->getDebugLog()->setWriteDebugLog(false);
        $saveArrayReturnType = Calculation::getArrayReturnType();
        Calculation::setArrayReturnType(Calculation::RETURN_ARRAY_AS_VALUE);
 
        // Open file
        $this->openFileHandle($pFilename);
 
        if ($this->excelCompatibility) {
            $this->setUseBOM(true); //  Enforce UTF-8 BOM Header
            $this->setIncludeSeparatorLine(true); //  Set separator line
            $this->setEnclosure('"'); //  Set enclosure to "
            $this->setDelimiter(';'); //  Set delimiter to a semi-colon
            $this->setLineEnding("\r\n");
        }
 
        if ($this->useBOM) {
            // Write the UTF-8 BOM code if required
            fwrite($this->fileHandle, "\xEF\xBB\xBF");
        }
 
        if ($this->includeSeparatorLine) {
            // Write the separator line if required
            fwrite($this->fileHandle, 'sep=' . $this->getDelimiter() . $this->lineEnding);
        }
 
        //    Identify the range that we need to extract from the worksheet
        $maxCol = $sheet->getHighestDataColumn();
        $maxRow = $sheet->getHighestDataRow();
 
        // Write rows to file
        for ($row = 1; $row <= $maxRow; ++$row) {
            // Convert the row to an array...
            $cellsArray = $sheet->rangeToArray('A' . $row . ':' . $maxCol . $row, '', $this->preCalculateFormulas);
            // ... and write to the file
            $this->writeLine($this->fileHandle, $cellsArray[0]);
        }
 
        $this->maybeCloseFileHandle();
        Calculation::setArrayReturnType($saveArrayReturnType);
        Calculation::getInstance($this->spreadsheet)->getDebugLog()->setWriteDebugLog($saveDebugLog);
    }
 
    public function getDelimiter()
    {
        return $this->delimiter;
    }
 
    public function setDelimiter($pValue)
    {
        $this->delimiter = $pValue;
 
        return $this;
    }
 
    public function getEnclosure()
    {
        return $this->enclosure;
    }
 
    public function setEnclosure($pValue = '"')
    {
        $this->enclosure = $pValue;
 
        return $this;
    }
 
    public function getLineEnding()
    {
        return $this->lineEnding;
    }
 
    public function setLineEnding($pValue)
    {
        $this->lineEnding = $pValue;
 
        return $this;
    }
 
    public function getUseBOM()
    {
        return $this->useBOM;
    }
 
    public function setUseBOM($pValue)
    {
        $this->useBOM = $pValue;
 
        return $this;
    }
 
    public function getIncludeSeparatorLine()
    {
        return $this->includeSeparatorLine;
    }
 
    public function setIncludeSeparatorLine($pValue)
    {
        $this->includeSeparatorLine = $pValue;
 
        return $this;
    }
 
    public function getExcelCompatibility()
    {
        return $this->excelCompatibility;
    }
 
    public function setExcelCompatibility($pValue)
    {
        $this->excelCompatibility = $pValue;
 
        return $this;
    }
 
    public function getSheetIndex()
    {
        return $this->sheetIndex;
    }
 
    public function setSheetIndex($pValue)
    {
        $this->sheetIndex = $pValue;
 
        return $this;
    }
 
    public function getOutputEncoding()
    {
        return $this->outputEncoding;
    }
 
    public function setOutputEncoding($pValue)
    {
        $this->outputEncoding = $pValue;
 
        return $this;
    }
 
    private $enclosureRequired = true;
 
    public function setEnclosureRequired(bool $value): self
    {
        $this->enclosureRequired = $value;
 
        return $this;
    }
 
    public function getEnclosureRequired(): bool
    {
        return $this->enclosureRequired;
    }
 
    private function writeLine($pFileHandle, array $pValues): void
    {
        // No leading delimiter
        $delimiter = '';
 
        // Build the line
        $line = '';
 
        foreach ($pValues as $element) {
            // Add delimiter
            $line .= $delimiter;
            $delimiter = $this->delimiter;
            // Escape enclosures
            $enclosure = $this->enclosure;
            if ($enclosure) {
                // If enclosure is not required, use enclosure only if
                // element contains newline, delimiter, or enclosure.
                if (!$this->enclosureRequired && strpbrk($element, "$delimiter$enclosure\n") === false) {
                    $enclosure = '';
                } else {
                    $element = str_replace($enclosure, $enclosure . $enclosure, $element);
                }
            }
            // Add enclosed string
            $line .= $enclosure . $element . $enclosure;
        }
 
        // Add line ending
        $line .= $this->lineEnding;
 
        // Write to file
        if ($this->outputEncoding != '') {
            $line = mb_convert_encoding($line, $this->outputEncoding);
        }
        fwrite($pFileHandle, $line);
    }
}