PHP Spreadsheet_Excel_Writer setTextWrap() Function

Situatie

The setTextWrap() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set text wrapping for text in spreadsheet.

Solutie

<?php
// require_once ‘Spreadsheet/Excel/Writer.php’;

// Add Workbook
$workbook = new Spreadsheet_Excel_Writer();

// Add Format to spreadsheet
$format_textwrap =& $workbook->addFormat();

// Set TextWrap
$format_textwrap->setTextWrap();

// Add Worksheet to Sprerdsheet
$worksheet =& $workbook->addWorksheet();

// Write to Worksheet
$worksheet->write(0, 0, “Test test test test test”, $format_textwrap);
$worksheet->write(1, 0, “ceva”, $format_textwrap);
$worksheet->write(1, 1, “ceva1”, $format_textwrap);
$worksheet->write(2, 0, “altceva”, $format_textwrap);
$worksheet->write(2, 1, “altceva2”, $format_textwrap);

// Send .xlsx file to header
$workbook->send(‘gfg1.xls’);

// Close Workbook Object
$workbook->close();
?>

Tip solutie

Permanent

Follow Us