1. Einführung
  2. Tutorial über
    Formatierungen
  3. Workbook::close
  4. Workbook::&addWorksheet
  5. Workbook::&addFormat
  6. Workbook::&setTempDir
  7. Workbook::setCustomColor
  8. Worksheet::getName
  9. Worksheet::
    setInputEncoding
  10. Worksheet::select
  11. Worksheet::activate
  12. Worksheet::setFirstSheet
  13. Worksheet::protect
  14. Worksheet::setColumn
  15. Worksheet::setSelection
  16. Worksheet::freezePanes
  17. Worksheet::thawPanes
  18. Worksheet::setPortrait
  19. Worksheet::setLandscape
  20. Worksheet::setPaper
  21. Worksheet::setHeader
  22. Worksheet::setFooter
  23. Worksheet::
    centerHorizontally
  24. Worksheet::
    centerVertically
  25. Worksheet::setMargins
  26. Worksheet::setMargins_LR
  27. Worksheet::setMargins_TB
  28. Worksheet::setMarginLeft
  29. Worksheet::
    setMarginRight
  30. Worksheet::setMarginTop
  31. Worksheet::
    setMarginBottom
  32. Worksheet::repeatRows
  33. Worksheet::repeatColumns
  34. Worksheet::printArea
  35. Worksheet::hideGridlines
  36. Worksheet::
    printRowColHeaders
  37. Worksheet::fitToPages
  38. Worksheet::
    setHPagebreaks
  39. Worksheet::
    setVPagebreaks
  40. Worksheet::setZoom
  41. Worksheet::setPrintScale
  42. Worksheet::write
  43. Worksheet::writeNumber
  44. Worksheet::writeString
  45. Worksheet::writeNote
  46. Worksheet::writeBlank
  47. Worksheet::writeFormula
  48. Worksheet::writeUrl
  49. Worksheet::setRow
  50. Worksheet::mergeCells
  51. Worksheet::insertBitmap
  52. Worksheet::setOutline
  53. Spreadsheet_Excel_Writer
  54. send
  55. rowcolToCell
  56. Format::setAlign
  57. Format::setVAlign
  58. Format::setHAlign
  59. Format::setMerge
  60. Format::setBold
  61. Format::setBottom
  62. Format::setTop
  63. Format::setLeft
  64. Format::setRight
  65. Format::setBorder
  66. Format::setBorderColor
  67. Format::setBottomColor
  68. Format::setTopColor
  69. Format::setLeftColor
  70. Format::setRightColor
  71. Format::setFgColor
  72. Format::setBgColor
  73. Format::setColor
  74. Format::setPattern
  75. Format::setUnderline
  76. Format::setItalic
  77. Format::setSize
  78. Format::setTextWrap
  79. Format::setTextRotation
  80. Format::setNumFormat
  81. Format::setStrikeOut
  82. Format::setOutLine
  83. Format::setShadow
  84. Format::setScript
  85. Format::setFontFamily

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(00$greek);
$worksheet->setInputEncoding('utf-8');
$worksheet->write(10$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: Sun, 19 Dec 2010 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report or add a note.
View this page in:

User Notes:

Note by: alvaro@demogracia.com
Seems to require BIFF8 (has no apparent effect otherwise). So don't omit this:

$worksheet->setInputEncoding('utf-8');
Note by: user@example.com
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
use like:

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

not 'utf-8' !!!