Download in excel format - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Download in excel format (/showthread.php?tid=18055) Pages:
1
2
|
Download in excel format - El Forum - 04-24-2009 [eluser]Tamilmani[/eluser] Hi Anybody tell to me .. How i download the datas(retrieve from DB) in excel format using CI and Database. Please Urgent for me ... Give me the idea or example link Download in excel format - El Forum - 04-24-2009 [eluser]Thorpe Obazee[/eluser] Code: <?php if (!defined('BASEPATH')) exit('No direct script access allowed'); Plugin from Bamboo Invoice Download in excel format - El Forum - 04-24-2009 [eluser]Tamilmani[/eluser] Thanks dude i ill try that Download in excel format - El Forum - 04-24-2009 [eluser]Thorpe Obazee[/eluser] It should probably work since I've used it a couple of times. Download in excel format - El Forum - 04-24-2009 [eluser]Tamilmani[/eluser] Hey dude i am installed the bamboo invoice but i didn't seen any functionality for excel download . Here avilable for generate pdf Download in excel format - El Forum - 04-24-2009 [eluser]Thorpe Obazee[/eluser] Errmm... did the plugin wok for you or not? Download in excel format - El Forum - 04-24-2009 [eluser]Tamilmani[/eluser] not work Download in excel format - El Forum - 04-24-2009 [eluser]Thorpe Obazee[/eluser] show your code. I might be out in a minute. Download in excel format - El Forum - 04-24-2009 [eluser]Tamilmani[/eluser] Controller function ---------------------- function dump(){ $this->load->plugin('to_excel'); $this->db->use_table('users'); $this->db->select('user_name', 'first_name'); // run joins, order by, where, or anything else here $query = $this->db->get(); to_excel($query); } This is my plugin file <?php if (!defined('BASEPATH')) exit('No direct script access allowed'); function to_excel($query, $filename='exceloutput') { $headers = ''; // just creating the var for field headers to append to below $data = ''; // just creating the var for field data to append to below $obj =& get_instance(); $fields = $query->field_data(); if ($query->num_rows() == 0) { echo '<p>The table appears to have no data.</p>'; } else { foreach ($fields as $field) { $headers .= $field->name . "\t"; } foreach ($query->result() as $row) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "\t"; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . "\t"; } $line .= $value; } $data .= trim($line)."\n"; } $data = str_replace("\r","",$data); header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=$filename.xls"); echo "$headers\n$data"; } } ?> Download in excel format - El Forum - 04-24-2009 [eluser]Thorpe Obazee[/eluser] I believe you need an actual query and not the result set in to_excel(); |