• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
write and read excel files with codeigniter

Can anybody help me,

Is there any library or helper to write and read excel file in codeigniter?

You can use html tables as Excel documents.

[quote author="Sudhakar Prajapati" date="1303994788"]Is there any library or helper to write and read excel file in codeigniter?[/quote] No, but you can use PHPExcel http://phpexcel.codeplex.com/
CI wiki: http://codeigniter.com/wiki/PHPExcel/ and some tutorial: http://virusandlinux.baskoroadi.web.id/i...deigniter/

The user guide given on the previous post is a little bit deprecated for the current CI.

You can follow the directives at http://codeigniter.com/wiki/PHPExcel/ and then for example to generate XLSX on the fly :


$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'world!');

$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007');

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Filename.xlsx"');
header('Cache-Control: max-age=0');

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.