Вообщем формирую экселевский файлик из PHP с помощью сабжа. код:
require_once "Spreadsheet/Excel/Writer.php";
$xl = & new Spreadsheet_Excel_Writer();
$xl -> send("kod.xls");
$sheet =& $xl->addWorksheet(kod);
$xl->setVersion(8);
$sheet->setInputEncoding('CP1251');
$message = iconv("","cp1251","Отчет по реализации");
$titleFormat =& $xl-> addFormat();
$titleFormat->setFontFamily('Verdana');
$titleFormat->setBold();
$titleFormat->setSize('13');
$titleFormat->setColor('black');
$gTFormat =& $xl->addFormat();
$gTFormat->setFontFamily('Helvetica');
$gTFormat->setBorder(1);
$hgTFormat =& $xl->addFormat();
$hgTFormat->setFontFamily('Helvetica');
$hgTFormat->setBorder(1);
$hgTFormat->setBold();
$linkTFormat =& $xl->addFormat();
$linkTFormat->setFontFamily('Helvetica');
$linkTFormat->setBorder(1);
$sheet -> write(0,0,$message,$titleFormat);
$sheet -> write(3,0,iconv("","cp1251","номер п\п"));
$sheet -> write(3,1,iconv("","cp1251","Документ"));
$sheet -> write(3,2,iconv("","cp1251","Договор"));
$sheet -> write(3,3,iconv("","cp2151","Счет"));
$sheet -> write(3,4,iconv("","cp1251","Контрагент"));
$sheet -> write(3,5,iconv("","cp1251","Потребитель"));
$sheet -> write(3,6,iconv("","cp1251","Вид номенклатуры"));
$sheet -> write(3,7,iconv("","cp1251","Ед.изм"));
$sheet -> write(3,8,iconv("","cp1251","Кол-во"));
$sheet -> write(3,9,iconv("","cp1251","Ед.изм"));
$sheet -> write(3,10,iconv("","cp1251","Кол-во"));
$sheet -> write(3,11,iconv("","cp1251","Цех"));
$sheet -> write(3,12,iconv("","cp1251","Заказ"));
$sheet -> write(3,13,iconv("","cp1251","ЕНН"));
$sheet -> write(3,14,iconv("","cp1251","Продукция"));
$sheet -> write(3,15,iconv("","cp1251","Вес 1 шт."));
$sheet -> write(3,16,iconv("","cp1251","Кол-во"));
$sheet -> write(3,17,iconv("","cp1251","Сумма"));
$sheet -> write(3,18,iconv("","cp1251","НДС"));
$sheet -> write(3,19,iconv("","cp1251","Всего"));
$xl-> close();
Он отдает мне экселевский файл где все заголовки на месте но почему то оставляя столбец D пустым. Ничего не понимаю. Это сразу после $sheet -> write(3,2,iconv("",«cp1251»,«Договор»));
