Downloading data in excel format with PHP And Unicode

--

public function _exportToCSV($status){
$columnHeader = "";

$setData = '';

$findAll = ImportUsers::model()->findAll("status = $status");
if(!empty($findAll)){
foreach($findAll as $objData){
$rowData = '';
$value = '"' . $objData->title1 . '"' . "\t";
$value .= '"' . $objData->title2 . '"' . "\t";
$value .= '"' . $objData->title3 . '"' . "\t";

$rowData .= $value;
$setData .= trim($rowData) . "\n";
}
}
$fileName = 'output.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename = $fileName");
header('Content-Transfer-Encoding: binary');
header("Pragma: no-cache");
header("Expires: 0");

echo chr(255).chr(254).iconv("UTF-8", "UTF-16LE//IGNORE", $setData . "\n");

exit();
}

Enjoy.

--

--