Worksheet::getName Worksheet::select
Spreadsheet_Excel_Writer
PEAR Manual

Worksheet::setInputEncoding

Worksheet::setInputEncoding -- Allow writing for different charsets.

Synopsis


      require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::setInputEncoding ( string $encoding )

Description

It allows writing for different charsets by setting the worksheet's "current" charset. It has been tested for UTF-8, ISO-8859-7. It requires iconv for any charset other than UTF-16LE.

Parameter

  • string $encoding - The encoding. It suports all encodings supported by php's iconv() function.

Note

This function can not be called statically.

Example

Using setInputEncoding()


     
<?php

require_once 'Spreadsheet/Excel/Writer.php';

$workbook = new Spreadsheet_Excel_Writer('test.xls');

$workbook->setVersion(8);

$worksheet =& $workbook->addWorksheet('International worksheet');



$russian = "\xD0\xBF\xD0\xBE\xD0\xBA\xD0\xB0";

$greek = "\342\345\353\355\341";



$worksheet->setInputEncoding('ISO-8859-7');

$worksheet->write(0, 0, $greek);

$worksheet->setInputEncoding('utf-8');

$worksheet->write(1, 0, $russian);

$workbook->close();

?>
Worksheet::getName Worksheet::select
Spreadsheet_Excel_Writer
PEAR Manual