我提到了这个问题如何设置自动换行符PhpExcel?
但我有点不清楚。所以问题来了。
我从$content
中得到一段
如果我直接执行$objPHPExcel->getActiveSheet()->setCellValue('A9', $content);
,则不会得到换行符,
我只是想让它像在05featureddemo.inc中所做的那样.php
它说要做$objPHPExcel->getActiveSheet()->setCellValue('A3', $sLloremIpsum);
但是我找不到给定的列的大小在哪里,即,
问是因为即使我从下面的数组中删除样式
$objPHPExcel->getActiveSheet()->getStyle('A3:E3')->applyFromArray(
array(
'font' => array(
'bold' => true
),
'alignment' => array(
'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_RIGHT,
),
'borders' => array(
'top' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN
)
),
'fill' => array(
'type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR,
'rotation' => 90,
'startcolor' => array(
'argb' => 'FFA0A0A0'
),
'endcolor' => array(
'argb' => 'FFFFFFFF'
)
)
)
);
$objPHPExcel->getActiveSheet()->getStyle('A3')->applyFromArray(
array(
'alignment' => array(
'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT,
),
'borders' => array(
'left' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN
)
)
)
);
并使其成为
$objPHPExcel->getActiveSheet()->getStyle('A3:E3')->applyFromArray(
array(
)
);
$objPHPExcel->getActiveSheet()->getStyle('A3')->applyFromArray(
array(
)
);
它有效,
所以问题是我如何为特定的列和 20px 的列组设置换行符,比如说)
完全取自05featureddemo.inc.php
:
// Set the cell (or group of cells) to enable text wrap in those cells
$objPHPExcel->getActiveSheet()
->getStyle('A3:A6')
->getAlignment()
->setWrapText(true);
// Set the column to a fixed width
$objPHPExcel->getActiveSheet()
->getColumnDimension('A')
->setWidth(80);