Snippets

INTRODUCTION

Learn phpxlsx in 5 minutes

PRACTICAL PHPXLSX

CONVERSION PLUGIN

COOKBOOK

SNIPPETS

API DOCUMENTATION

Contents with line breaks

To add a line break in a cell content, "\n" must be added and the cell style 'wrapText' must be set to true.

$content = array(
    'text' => "Lorem ipsum dolor\nsit amet",
);
$cellStyles = array(
    'wrapText' => true,
);
$xlsx->addCell($content, 'A1', $cellStyles);
$xlsx->setColumnSettings('A', array('width' => 50));
$xlsx->setRowSettings(1, array('height' => 50));

​x
 
$content = array(
    'text' => "Lorem ipsum dolor\nsit amet",
);
$cellStyles = array(
    'wrapText' => true,
);
$xlsx->addCell($content, 'A1', $cellStyles);
$xlsx->setColumnSettings('A', array('width' => 50));
$xlsx->setRowSettings(1, array('height' => 50));
​