Excel CSV helper for CodeIgniter

Hey can you please help me get the titles for array to csv. I wanna use the array keys as the title (like they do in the query to csv). Can you please tell me how to do it with your helper? mmarcus44@gmail.com

This was a big help to get me going, thanks! In the future I may add in the CI Download Helper usage if anything. @Michael and for anyone else: You can use array_keys and array_values if you need to pull out those pieces of information as a "regular" array with numeric indexes.

Searching something like this. Thanks Joshua for this great help. :-D

Thanks for this helper. It saved me a lot of work and it's very robust and yet simple to use. I truly appreciate it. Keep up the good work mate!

//function that convert an object to an array was useful for mi function objectToArray( $object ) { if( !is_object( $object ) && !is_array( $object ) ) { return $object; } if( is_object( $object ) ) { $object = get_object_vars( $object ); } return array_map( 'objectToArray', $object ); } //hope it helps

Hi can i use this helper and call directly the model function and export it to csv? Thanks please send me to coder5@ymail.com

Beautifully simple, and still works!! Thank you

thank you, very simple and very very useful..

Thaks for your helper, it's very simple to use and very useful.

Bur i wonder if i can export the data in a xls format directly. Currently (i implemented this into a client's application), my client has to export the data, open excel, choose import data from file, and select comma separated value.

Anyway, amazing simple helper.

Thanks again

great

I use this

amazing

great

I use this

amazing

Many thanks! Very handy, saves quite a bit of time! :)

Thanks for this helper.But I have some problem when I convert to csv file my session have been not exist I want my session to be alive. How I can do?.

compress output = FALSE

otherwise you will loose hours trying to see where the problem starts

This method exhausts an unusually high amount of RAM and does not work for me for anything over 1,500 lines or so. Any ideas to fix it?

Here's how I'm using it:

// Export all locations for the specified account
// Will provide a CSV file to download
function export_all($id) {
$this->config->set_item('compress_output', FALSE);
$this->load->helper('csv');

// Get all locations
$query = $this->locations_m->get_all($id);
$this->db->select('*');
$this->db->from('locations');
$this->db->where('account_id', $id);
#$this->db->limit(1000);

$query = $this->db->get();
#$array = $query->result_array();

query_to_csv($query, TRUE, 'export_all.csv');
}

I receive an error when I use the array_to_csv function

This webpage is not found.

No webpage was found for the web address:

It doesn't seem to like the stdClass Object being used as the array. Any thoughts on resolving this issue?

Works like a charm! Nice work and thanks for sharing with the community.

I am trying to exports csv/xls using this helper.

That works fine with every browsers except IE. Every time i export csv files it resets IE session.

Any help will appreciable.

Very nice :)

Thanks man!!!.

Very useful.

$%$%#$%#%
yes ,it can work,but when it export a chinese record to a .csv file, they are the wrong characters like that '#%#%%@#'.Why? What can i do? waiting for Online!!!!

thanks..
successfull

Hi bit of a glitch for me.

my query is as follows

"
$query = $this->db->where(array('Dial_Up' => '0', 'Language' => 'English', 'Membership_Status' => 'Active'));
$query = $this->db->like('Email', '@');
$query = $this->db->get('Membership');
return $query->result();
"

I would like the csv file to contain only two fields, ID and Email.

How would I go about that?

Nevermind, Got it, just had to use select commands!

HOW CAN I FIX THE COLUMN SIZE OF CSV FILE ...?

there's an error A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /Applications/XAMPP/xamppfiles/htdocs/csv/system/application/models/csv_model.php:27)

Filename: helpers/csv_helper.php

Line Number: 27

i dont know how to solve it..please help me guys!! thanks a lot in advance

Same issue here with the headers... I disabled the profiler, and I don't have anything else being sent to the browser that I know of. Help?

I used .htaccess to set output_buffering to on, and it worked.

Only problem I'm having now is that there's a bunch of carriage returns at the top of the file... anyone else experiencing this?

Very userful. Thanx

Had written my whole code and then stumbled on this one. Ended up using this one !!!! nice work.

hi,, can i set the delimiter with this helper??

Thanks ... Its very usefull ..

when send the csv to file too send the html file

Thanx...its very usefull for me..

but how to set delimiter with ";" ?