PHPExcel — Color part of XLSX table

by

To colour the rows:

$objPHPExcel->getActiveSheet()->getStyle('A1000:IV2000')
    ->getFill()
    ->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1000:IV2000')
    ->getFill()
    ->getStartColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE);

To format dates:

Make sure that you’re setting your date values as an Excel serialized timestamp

$myDate = "21/12/2014 15:08:23";
$myDateValue = DateTime::createFromFormat('d/m/Y H:i:s', $myDate);
$excelTimeStamp = PHPExcel_Shared_Date::PHPToExcel($myDateValue);

$objPHPExcel->getActiveSheet()
    ->setCellValue('A1', $excelTimeStamp);
$objPHPExcel->getActiveSheet()
    ->getStyle('C9')
    ->getNumberFormat()
    ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY);

All of this is covered in the documentation and in the examples provided with the PHPExcel package

More Related Contents:

  1. Alternative for PHP_excel
  2. PHPExcel runs out of 256, 512 and also 1024MB of RAM
  3. phpexcel to download
  4. How to fix memory getting exhausted with PHPExcel?
  5. PHPExcel auto size column width
  6. PHPExcel download using ajax call
  7. How to convert Excel XLS to CSV using PHP
  8. Ignore empty cells PHPExcel
  9. How to use phpexcel to read data and insert into database?
  10. How to read large worksheets from large Excel files (27MB+) with PHPExcel?
  11. How to generate an .xlsx using php
  12. Correct format for strings / numbers beginning with zero?
  13. phpexcel Allowed memory size of 134217728 bytes exhausted [duplicate]
  14. How can I with mysqli make a query with LIKE and get all results?
  15. Insert new item in array on any position in PHP
  16. Associative array, sum values of the same key
  17. Show a PDF files in users browser via PHP/Perl
  18. how to delete all cookies of my website in php
  19. php link to image file outside default web directory
  20. PHP E-Mail Encoding?
  21. How to join two tables with ssp.class.php
  22. Is there a built-in function or plugin to handle date formatting in JavaScript?
  23. Convert clickable anchor tags to plain text in html document
  24. How can I add all of my array values together in PHP?
  25. Timeout a function in PHP
  26. comma-separated string to array
  27. How to remove all numbers from string?
  28. MP4 plays when accessed directly, but not when read through PHP, on iOS
  29. Dynamically bind mysqli_stmt parameters and then bind result
  30. How can you use php in a javascript function [duplicate]

Leave a Comment