phpexcel 自动换行符


phpexcel line break automatically

我提到了这个问题如何设置自动换行符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);