<?php

namespace PhpOffice\PhpSpreadsheet\Writer;

use PhpOffice\PhpSpreadsheet\Spreadsheet;

interface IWriter
{
    public const SAVE_WITH_CHARTS = 1;

    public const DISABLE_PRECALCULATE_FORMULAE = 2;

    /**
     * IWriter constructor.
     *
     * @param Spreadsheet $spreadsheet The spreadsheet that we want to save using this Writer
     */
    public function __construct(Spreadsheet $spreadsheet);

    /**
     * Write charts in workbook?
     *        If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.
     *        If false (the default) it will ignore any charts defined in the PhpSpreadsheet object.
     *
     * @return bool
     */
    public function getIncludeCharts();

    /**
     * Set write charts in workbook
     *        Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
     *        Set to false (the default) to ignore charts.
     *
     * @param bool $includeCharts
     *
     * @return IWriter
     */
    public function setIncludeCharts($includeCharts);

    /**
     * Get Pre-Calculate Formulas flag
     *     If this is true (the default), then the writer will recalculate all formulae in a workbook when saving,
     *        so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet
     *        viewer when opening the file
     *     If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower
     *        when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.
     *
     * @return bool
     */
    public function getPreCalculateFormulas();

    /**
     * Set Pre-Calculate Formulas
     *        Set to true (the default) to advise the Writer to calculate all formulae on save
     *        Set to false to prevent precalculation of formulae on save.
     *
     * @param bool $precalculateFormulas Pre-Calculate Formulas?
     *
     * @return IWriter
     */
    public function setPreCalculateFormulas($precalculateFormulas);

    /**
     * Save PhpSpreadsheet to file.
     *
     * @param resource|string $filename Name of the file to save
     * @param int $flags Flags that can change the behaviour of the Writer:
     *            self::SAVE_WITH_CHARTS                Save any charts that are defined (if the Writer supports Charts)
     *            self::DISABLE_PRECALCULATE_FORMULAE   Don't Precalculate formulae before saving the file
     *
     * @throws Exception
     */
    public function save($filename, int $flags = 0): void;

    /**
     * Get use disk caching where possible?
     *
     * @return bool
     */
    public function getUseDiskCaching();

    /**
     * Set use disk caching where possible?
     *
     * @param bool $useDiskCache
     * @param string $cacheDirectory Disk caching directory
     *
     * @return IWriter
     */
    public function setUseDiskCaching($useDiskCache, $cacheDirectory = null);

    /**
     * Get disk caching directory.
     *
     * @return string
     */
    public function getDiskCachingDirectory();
}

• [D] Ods
• [D] Pdf
• [D] Xls
• [D] Xlsx
• [F] BaseWriter.php
  Delete
• [F] Csv.php
  Delete
• [F] Exception.php
  Delete
• [F] Html.php
  Delete
• [F] IWriter.php
  Delete
• [F] Ods.php
  Delete
• [F] Pdf.php
  Delete
• [F] Xls.php
  Delete
• [F] Xlsx.php
  Delete
• [F] ZipStream0.php
  Delete
• [F] ZipStream2.php
  Delete
• [F] ZipStream3.php
  Delete

Developer

• Support

Back to Home page