I would like to add the borders to the rows with records, everything is based on date ranges so there may be 5, 6, 10 rows with information.
As you can see only the columns with titles have borders, but where the information is not, that's where I need to know how to put borders for each row that is generated.
Code:
//TODOS LOS TEXTOS CENTRADOS
$objPHPExcel->getDefaultStyle()->applyFromArray($style);
//ANCHO DE COLUMNAS
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(30);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A7', 'DESCRIPTION');
$objPHPExcel->getActiveSheet()->getStyle("A7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('A7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B7', 'OUTPUT QTY');
$objPHPExcel->getActiveSheet()->getStyle("B7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('B7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C7', 'R.LEVEL');
$objPHPExcel->getActiveSheet()->getStyle("C7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('C7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D7', 'T.STOCK');
$objPHPExcel->getActiveSheet()->getStyle("D7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('D7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E7', 'AREA');
$objPHPExcel->getActiveSheet()->getStyle("E7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('E7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F7', 'CATEGORY');
$objPHPExcel->getActiveSheet()->getStyle("F7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('F7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G7', 'EMPLOYEE');
$objPHPExcel->getActiveSheet()->getStyle("G7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('G7')->applyFromArray($BStyle);//celdas a nombres de columnas
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H7', 'OBSERVATIONS');
$objPHPExcel->getActiveSheet()->getStyle("H7")->getFont()->setBold(true);//letras en negrita
$objPHPExcel->getActiveSheet()->getStyle('H7')->applyFromArray($BStyle);//celdas a nombres de columnas
$arraycount=count($result);
$i=0;
$total=0;
while ($i < $arraycount)
{
$j=$i+8;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$j, $result[$i]['description_item']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$j, $result[$i]['quantity_s']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$j, $result[$i]['reorder_level']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$j, $result[$i]['target_Stock']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E'.$j, $result[$i]['name_location']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F'.$j, $result[$i]['name_category']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('G'.$j, $result[$i]['employee']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('H'.$j, $result[$i]['observations']);
$i++;
}
For the edges I'm using this:
$objPHPExcel->getActiveSheet()->getStyle('')->applyFromArray($BStyle);