is it possible to put bottom border of a merged cell in phpexcel?

Question

 $objectSheet->setCellValue($c[$current_col].$current_row, 'Civil Status:');

 $objectSheet->mergeCells($c[$current_col].$current_row.':'.$c[$current_col + $width -1].$current_row);

 $current_col += $width;

I want to put bottom border in the merged cell, how can i do this?

possible duplicate of [PHPEXCEL set border and format for all sheets in spreadsheet](http://stackoverflow.com/questions/19397953/phpexcel-set-border-and-format-for-all-sheets-in-spreadsheet) — Rajeev Ranjan, Aug 18 '15 at 06:30

score 0 · Accepted Answer · edited May 23 '17 at 11:54

0

Check out this thread

$objPHPExcel->getDefaultStyle()
->getBorders()
->getTop()
    ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

$objPHPExcel->getDefaultStyle()
->getBorders()
->getBottom()
    ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

$objPHPExcel->getDefaultStyle()
->getBorders()
->getLeft()
    ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

$objPHPExcel->getDefaultStyle()
->getBorders()
->getRight()
    ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

edited May 23 '17 at 11:54

Community

1
1

answered Aug 18 '15 at 06:26

reignsly

502
4
10

$objPHPExcel->getActiveSheet()->getStyle('B'.$cellnumber)-> applyFromArray($style); – chemalarrea May 27 '19 at 22:34

is it possible to put bottom border of a merged cell in phpexcel?

1 Answers1