Skip to content
Advertisement

Tag: excel

phpexcel -How to change data type for whole column of an excel

I’m trying to change the datatype for a whole column (for eg: i need to change for “M” Column to general format). Its displaying as 2.00 in quantity field,I need to change this whole column to general format ie. display as “2”. But its not changing the datatype. Here is the code: How to do for the whole column “M”

Export CSV for Excel

I’m writing a CSV file in PHP using fputcsv($file, $data). It all works, however I can’t just open it in Excel but have to import it and specify the encoding and which delimiter to use (in a wizard). …

Excel output with codeigniter

I’m trying to get a report from my codeigniter project in excel, but I am at a complete loss on how to do it. It already works well, just would like the output in excel rather then a page. Any tips/pointers/explanations? thanks! Answer I’ll refer you to this wiki article from the codeIgniter site, or to this tutorial

Advertisement