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();
?>

Retrieve the worksheet name. This is usefull when creating worksheets (Previous) Set this worksheet as a selected worksheet, i.e. the worksheet has its tab (Next)

Last updated: Sat, 16 Feb 2019 — Download Documentation

Do you think that something on this page is wrong? Please file a bug report.

View this page in:

User Notes:

Note by: alvaro@demogracia.com

2012-07-12 10:18 UTC

Seems to require BIFF8 (has no apparent effect otherwise). So don't omit this:

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

Note by: user@example.com

2010-02-04 09:36 UTC

When i do

require_once( 'Spreadsheet/Excel/Writer.php' );
$o_book = new Spreadsheet_Excel_Writer();
$o_book->setVersion( 8 );
$o_book->send( 'report.xls' );
$o_ws =& $o_book->addWorksheet( @iconv( 'UTF-8', 'WINDOWS-1251', '????' ) );
$o_ws->setInputEncoding( 'UTF-8' );

Added worksheet have title with incorrectly displayed characters (when passed with UTF-8 cyrillic string). After that when i use write method, all is ok.

Note by: oleoo@mail.ru

2010-01-27 10:10 UTC

use like:

# $newExcelbook = new Spreadsheet_Excel_Writer("sheets/test.xls");
# $newExcelbook->setVersion(8);
# $newExcelsheet =& $newExcelbook->addWorksheet("????1");
# $newExcelsheet->setInputEncoding("UTF-8");

not 'utf-8' !!!