PHPOffice / PhpSpreadsheet

     * @param   string                      $sheetState         Sheet state (visible, hidden, veryHidden)

     * @throws     \PhpSpreadsheet\Writer\Exception

     */

    private function writeSheet(\PhpSpreadsheet\Shared\XMLWriter $objWriter, $pSheetname = '', $pSheetId = 1, $pRelId = 1, $sheetState = 'visible')

    {

        if ($pSheetname != '') {

            // Write sheet

            $objWriter->startElement('sheet');

            $objWriter->writeAttribute('name', $pSheetname);

            $objWriter->writeAttribute('sheetId', $pSheetId);

            if ($sheetState != 'visible' && $sheetState != '') {

                $objWriter->writeAttribute('state', $sheetState);

            }

            $objWriter->writeAttribute('r:id', 'rId' . $pRelId);

            $objWriter->endElement();

        } else {

            throw new \PhpSpreadsheet\Writer\Exception('Invalid parameters passed.');

        }

    }

    /**

     * Write Defined Names

     * @param     string                         $pTargetMode    Relationship target mode

     * @throws     \PhpSpreadsheet\Writer\Exception

     */

    private function writeRelationship(\PhpSpreadsheet\Shared\XMLWriter $objWriter = null, $pId = 1, $pType = '', $pTarget = '', $pTargetMode = '')

    {

        if ($pType != '' && $pTarget != '') {

            // Write relationship

            $objWriter->startElement('Relationship');

            $objWriter->writeAttribute('Id', 'rId' . $pId);

            $objWriter->writeAttribute('Type', $pType);

            $objWriter->writeAttribute('Target', $pTarget);

            if ($pTargetMode != '') {

                $objWriter->writeAttribute('TargetMode', $pTargetMode);

            }

            $objWriter->endElement();

        } else {

            throw new \PhpSpreadsheet\Writer\Exception('Invalid parameters passed.');

        }

    }

}