• PHPExcel

    
    
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10');
    $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
    $objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setWrapText(true); 
    $activeSheet->getStyle('A')->getFill()->setFillType('solid')->getStartColor()->setARGB('00FF0000'); 
    $activeSheet->getStyle('A')->getAlignment()->setHorizontal('right'); 
    $activeSheet->getStyle("E")
                     ->getAlignment()
                     ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
    setVERTICAL(PHPExcel_Style_Alignment::PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->mergeCells('A1:B1');
     $styleArray = array(
      'borders' => array(
        'allborders' => array(
          'style' => PHPExcel_Style_Border::BORDER_THIN
        )
      )
    );
    
    $sheet->getStyle('A1:P3')->applyFromArray($styleArray);
    unset($styleArray);
  • 0 comments:

    Post a Comment

    FAVOURITE LINE

    To steal ideas from one is plagiarism. To steal from many is Research.

    ADDRESS

    Mumbai , Maharashtra

    EMAIL

    shikha.pathak6@gmail.com
    shikha.the.swt.pari@gmail.com

    Skype

    shikha_pari