PHPSpreadsheet 文本旋转到 90 不起作用

2024-04-29

我正在尝试使用文本旋转到 90 度来使单元格具有垂直文本,但它不起作用,所有文本都是水平显示的,也许我做错了什么? 这是我的 php 代码

$spreadsheet = new Spreadsheet();

// Create a new worksheet called "Technical Skills"
$technicalSkillsSheet = new Worksheet($spreadsheet, 'Technical Skills');
// Attach the "Technical Skills" worksheet as the first worksheet in the Spreadsheet object
$spreadsheet->addSheet($technicalSkillsSheet, TECHNICAL_SKILLS_INDEX);
$sheet = $spreadsheet->getSheet(TECHNICAL_SKILLS_INDEX);
foreach($term_sheet_array as $term_sheet){
    $sheet->setCellValue($term_sheet['cell'], $term_sheet['name']);
    $styleArray = array(
        'fill' => array(
            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
            'startColor' => array(
                'argb' => $term_sheet["color"],
            ),
        ),
        'alignment' => array(
            'wrapText' => TRUE,
            'textRotation' => 90,
            'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_BOTTOM,
        ),
    );
    $sheet->getStyle($term_sheet['cell'])->applyFromArray($styleArray);
    $color_key++;

    if($color_key >= count($sheetColors)){
       $color_key = 0;
    }
}

Simple:

$activeSheet->getStyle('A1')->getAlignment()->setTextRotation(90);
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

PHPSpreadsheet 文本旋转到 90 不起作用 的相关文章

随机推荐