作者aleck945 (总是不知所措)
看板PHP
标题Re: [请益] 存成 txt 档
时间Wed Jul 9 18:14:09 2008
※ 引述《Joe8 (Beautiful Stranger)》之铭言：
: 谢谢提供经验！
: 在下上网查了一下方法2:Spreadsheet_Excel_Writer
: 并取用了一个小范例程式，可是发生错误！ 还请高手帮忙看一下，谢谢
: <?php
: require_once 'Spreadsheet/Excel/Writer.php';
: // We give the path to our file here
: $workbook = new Spreadsheet_Excel_Writer('test.xls');
: $worksheet =& $workbook->addWorksheet('My first worksheet');
: $worksheet->setInputEncoding('utf-8');
: $worksheet->write(0, 0, 'Name');
: $worksheet->write(0, 1, 'Age');
: $worksheet->write(1, 0, '剣');
: $worksheet->write(1, 1, 30);
: $worksheet->write(2, 0, 'Johann Schmidt');
: $worksheet->write(2, 1, 31);
: $worksheet->write(3, 0, 'Juan Herrera');
: $worksheet->write(3, 1, 32);
: // We still need to explicitly close the workbook
: $workbook->close();
: ?>
: 这样在test.xls档案中只有英文显示得出来， 那个剑字变成问号... 请问该何解呢？
看你的情形应该是你的编辑器是 big5, 所以才会看不到.
帮你修一下:
<?php
require_once 'Spreadsheet/Excel/Writer.php';
// We give the path to our file here
$workbook = new Spreadsheet_Excel_Writer();
$workbook->setVersion(8);
$workbook->send("test.xls");
$worksheet =& $workbook->addWorksheet('My first worksheet');
$worksheet->setInputEncoding('utf-8');
$worksheet->write(0, 0, 'Name');
$worksheet->write(0, 1, 'Age');
$worksheet->write(1, 0, iconv('big5','utf-8','剑'));
$worksheet->write(1, 1, 30);
$worksheet->write(2, 0, 'Johann Schmidt');
$worksheet->write(2, 1, 31);
$worksheet->write(3, 0, 'Juan Herrera');
$worksheet->write(3, 1, 32);
// We still need to explicitly close the workbook
$workbook->close();
?>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 122.116.190.50
1F：→ bcse :如果是因为编码问题，不需用到iconv，将档案储存为 07/09 19:28
2F：→ bcse :UTF-8编码，应该就可以了吧？ 07/09 19:29
3F：→ bcse :附带一提，其实原文中的「剑」是日文 XD 07/09 19:30
4F：→ aleck945 :推楼上, 因为我也看不到那个 剑 字. 07/10 01:06