Snippets

INTRODUCTION

PRACTICAL PHPXLSX

CONVERSION PLUGIN

COOKBOOK

SNIPPETS

API DOCUMENTATION

Empty header and footer in the first page

To hide the default header and footer in the first page, empty contents must be added in the first target. MS Excel also requires adding contents in more than one page to display a first page.

// sample contents
$content = array(
    'text' => 'A1 content',
);
$xlsx->addCell($content, 'A1');
$content = array(
    'text' => 'J1 content',
);
$xlsx->addCell($content, 'J1');

// headers

// empty content
$headerContentFirst = array(
    'text' => '',
);
// first header
$xlsx->addHeader(array('center' => $headerContentFirst), 'first');

$headerContentDefault = array(
    'text' => 'Default content header',
);
// default header
$xlsx->addHeader(array('center' => $headerContentDefault));

// footers

// empty content
$footerContentFirst = array(
    'text' => '',
);
// first footer
$xlsx->addFooter(array('center' => $footerContentFirst), 'first');

$footerContentDefault = array(
    'text' => 'Default content footer',
);
// default footer
$xlsx->addFooter(array('center' => $footerContentDefault));