php - Yii2 always set header to "UTF-8 with BOM" for saving files -


in yii2 have controller save texts database .csv file. contains russian (cyrillic) language. problem when open file in excel, has bad charset: грузовÐ

for mac os , windows users excel charset result same. opening in notepad okey. notepad says has coding "utf-8 bom". if save "utf-8" notepad, excel reads .csv file.

code:

yii::$app->response->format = \yii\web\response::format_raw; yii::$app->response->charset = 'utf-8'; yii::$app->response->headers->set('content-type', 'text/csv; charset=utf-8'); yii::$app->response->headers->add('content-disposition', 'attachment; filename="myfile.csv"'); // header('content-type: text/plain; charset=utf-8',true);

any ideas might wrong? tried lot of charsets (windows-1251, cp1251), text/plain -- no results. moreover, strange chars same if set charset chinese or other.

it headers charset not changed , "utf-8 bom".

yii::$app->charset 'utf-8', changing text/csv text/plain or text/json, or saving .txt , open in excel - same results.


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more