我对PEAR有问题，这个问题看起来很奇怪。
我正在用php生成一个电子表格，在这里我循环几个段落来创建一个大小表。只要我在图表中只使用一些细节，脚本就会被执行，但似乎有限制。一旦超过这个数字，我就会收到一条致命错误消息。
这是我在工作簿中使用的代码：
require_one'/电子表格/Excel/Writer.php'；
$workbook = new Spreadsheet_Excel_Writer('sizecharts/'.$file.'.xls');
$worksheet =& $workbook->addWorksheet('NL Worksheet '.$itemname);
$workbook->setVersion(8);
$format_top =& $workbook->addFormat();
$format_top->setAlign('top');
$format_top->setTextWrap(1);
$format_center =& $workbook->addFormat();
$format_center->setAlign('center');
$format_heading1 =& $workbook->addFormat();
$format_heading1->setAlign('center');
$format_heading1->setBold(1);
$format_heading1->setSize(16);
$format_info =& $workbook->addFormat();
$format_info->setAlign('center');
$format_info->setBold(1);
$format_info->setSize(12);
$bold =& $workbook->addFormat();
$bold->setBold(1);
$details =& $workbook->addFormat();
$details->setBorder(1);
$details_header =& $workbook->addFormat();
$details_header->setBold(1);
$details_header->setBorder(1);
$details_cell =& $workbook->addFormat();
$details_cell->setBorder(1);
$details_cell->setAlign('center');
$details_cell_header =& $workbook->addFormat();
$details_cell_header->setBold(1);
$details_cell_header->setBorder(1);
$details_cell_header->setAlign('center');
$details_num =& $workbook->addFormat();
$details_num->setBold(1);
$details_num->setBorder(1);
$details_num->setAlign('right');
$worksheet->setMerge(1,0,1,$size_count-1);
$worksheet->setMerge(3,0,3,$size_count-1);
$worksheet->setMerge(5,0,5,$size_count-1);
$worksheet->setInputEncoding('utf-8');
$worksheet->write(1, 0, 'MYCOMPANY', $format_heading1);
$worksheet->write(3, 0, '耐斯德克服饰(上海)有限公司', $format_heading1);
$worksheet->write(5, 0, 'Measurements '.$itemname, $format_info);
$worksheet->setInputEncoding('ISO-8859-7');
$worksheet->write(7, $size_count-2, 'File#:');
$worksheet->write(7, $size_count-1, $file);
$worksheet->write(8, 0, 'Date:');
$worksheet->write(8, 1, $date);
$worksheet->write(9, 0, 'Customer:');
$worksheet->write(9, 1, $customer);
$worksheet->write(10, 0, 'Item Type:');
$worksheet->write(10, 1, $type);
$worksheet->write(11, 0, 'Units:');
$worksheet->write(11, 1, $unit);
$worksheet->setColumn(0,0,10);
$worksheet->setColumn(0,1,30);
$worksheet->write(13, 0, '#',$details_num);
$worksheet->write(13, 1, 'Details:',$details_header);
for($k=1;$k<($size_count-1);$k++){
$size_collect_xls = $sizes_arr[$k];
$worksheet->setInputEncoding('utf-8');
$worksheet->write(13,$k+1, $size_collect_xls,$details_cell_header);
$worksheet->setInputEncoding('ISO-8859-7');
}
for($i=0;$i<$count;$i++){
if(isset($_POST['details'][$i])){
$detail = $_POST['details'][$i];
$worksheet->write(14+$i, 0, ($i+1).'.',$details_num);
$worksheet->write(14+$i, 1, $detail,$details);
$det_collect = "";
for($k=1;$k<($size_count-1);$k++){
$key = "det".$k;
$det_collect_val = $_POST[$key][$i];
$worksheet->write(14+$i,$k+1, $det_collect_val,$details_cell);
}
}
}
// We still need to explicitly close the workbook
$workbook->close();
?>
我正在用这个来写文件。
我后来得到的是这个错误消息
<b>Fatal error</b>: Call to undefined method PEAR_Error::setInputEncoding() in <b>/home/MYCOMPANY/www/www/quotbot/sizechartinput.php</b> on line <b>740</b><br />
指的是这一行代码：
$worksheet->setMerge(1,0,1,$size_count-1);
如果我用交换这条线
$worksheet->setInputEncoding('utf-8');
我的错误消息更改为：
<b>Fatal error</b>: Call to undefined method PEAR_Error::setInputEncoding()
在这种情况下，错误报告存在编码问题，而不是单元格问题。因此，这意味着该命令没有问题。这更像是生成的工作表中数据量的问题。
那么，excel工作表中插入的数据量有什么限制吗？
这是不相关的。
线路
$worksheet =& $workbook->addWorksheet('NL Worksheet '.$itemname);
可以返回"成功时引用工作表对象，失败时返回PEAR_Error"（此处引用）。错误消息告诉您正在调用PEAR_error上的未定义方法，这意味着您的调用失败。
您需要在该行之后检查addWorksheet是否成功。文件中的简单示例：
// Make sure the worksheet name is less than 31 characters
$worksheet =& $workbook->addWorksheet(substr('NL Worksheet '.$itemname, 0, 31));
if (PEAR::isError($worksheet)) {
die($worksheet->getMessage());
}