PHP Excel 访问样式数组键在 applyFromArray 中

Question

>我正在尝试创建一个包含所有设计的数组，并applyFromArray()访问数组键：

$styleArray = array(
    'font'  => array(
        'bold'  => true,
        'color' => array('rgb' => '000000'),
        'size'  => 11,
        'name'  => 'Verdana'
    ),
    'alignment' => array(
        'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
    )
);
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->applyFromArray($styleArray['font']);

Answer 1

对于您的样式数组：

$styleArray = array(
        'font'  => array(
            'bold'  => true,
            'color' => array('rgb' => '000000'),
            'size'  => 11,
            'name'  => 'Verdana'
        ),
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )
);

在应用字体样式之前调用getFont()

$objPHPExcel->getActiveSheet()
            ->getStyle('A1:D1')
            ->getFont() //Add this call to get the font object
            ->applyFromArray($styleArray['font']);

如果你想使用你所有的样式数组：

$objPHPExcel->getActiveSheet()
            ->getStyle('A1:D1')
            ->applyFromArray($styleArray); // Remove the 'font' index