http://pear.php.net/package-info.php?pacid=156
Spreadsheet_Excel_Writer-0.3.tgz
$ pear install Spreadsheet_Excel_Writer-0.3.tgz install ok: Spreadsheet_Excel_Writer 0.3 $
$workbook = new Spreadsheet_Excel_Writer();
$worksheet =& $workbook- >addWorksheet($tablename); �/span>@�/span>@�/span>@:
$format =& $workbook->addFormat(); $format->_font_name = mb_convert_encoding("MS ゴシック", "shift_jis"); �/span>@�/span>@�/span>@:
while(OCIFetch($stmt)) { $excelrow++; for ( $i = 1; $i <= $ncols; $ i++ ) { $worksheet->write( $excelrow, ($i - 1), mb_convert_encoding( OCIResult($stmt, OCIColumnName($stmt,$i)), "shift_jis")); } } �/span>@�/span>@�/span>@:
$workbook->send($filename);
$workbook->close(); ?>
http://www.excel.studio-kazu.jp/cgi-bin/kazuwiki2.cgi?mycmd=read&mypage=[[20060224233337]]&mytime=144826