title: Php read excel file which have non english content using PHPExcel lib
body: <p>I have a xlsx file which contain non English content (Russian). I'm using PHPExcel lib to read it. When I read my file the out put is totally messed up ? is there any way to fix this ? I tried to convert utf8 but no luck. Any help would be appreciate . Here is my code.</p>
  
  <pre><code>&lt;?php 
  include_once 'Classes/PHPExcel.php';
  echo '&lt;pre&gt;';
  
  $excelFile = "test.xlsx";
  
  $objReader = PHPExcel_IOFactory::createReader('Excel2007');
  $objPHPExcel = $objReader-&gt;load($excelFile);
  
  //Itrating through all the sheets in the excel workbook and storing the array data
  foreach ($objPHPExcel-&gt;getWorksheetIterator() as $worksheet) {
      $arrayData[$worksheet-&gt;getTitle()] = $worksheet-&gt;toArray();
  }
  
  /* function utf8_converter($arrayData)
  {
      array_walk_recursive($array, function(&amp;$item, $key){
          if(!mb_detect_encoding($item, 'utf-8', true)){
              $item = utf8_encode($item);
          }
      });
  
          return $arrayData;
  }
  utf8_converter($arrayData);
   */
  
  print_r($arrayData);
  
  ?&gt;
  </code></pre>
  
  <p>My output is ,</p>
  
  <pre><code>[1] =&gt; Array
                  (
                      [0] =&gt; 199
                      [1] =&gt; Clothing
                      [2] =&gt; ru
                      [3] =&gt; T shirt
                      [4] =&gt; Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´Ñ‡Ð¸Ðº , Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´ , Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ ÑÐ»Ð¾Ð²Ð°Ñ€ÑŒ Ð˜Ð½Ñ‚ÐµÑ€Ð½ÐµÑ‚
                      [5] =&gt; Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´Ñ‡Ð¸Ðº , Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´ , Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ ÑÐ»Ð¾Ð²Ð°Ñ€ÑŒ Ð˜Ð½Ñ‚ÐµÑ€Ð½ÐµÑ‚
                  )
  
              [2] =&gt; Array
                  (
                      [0] =&gt; 203
                      [1] =&gt; Clothing
                      [2] =&gt; ru
                      [3] =&gt; pant
                      [4] =&gt; Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´Ñ‡Ð¸Ðº , Ð¿ÐµÑ€ÐµÐ²Ð¾Ð´ , Ð‘ÐµÑÐ¿Ð»Ð°Ñ‚Ð½Ñ‹Ð¹ ÑÐ»Ð¾Ð²Ð°Ñ€ÑŒ Ð˜Ð½Ñ‚ÐµÑ€Ð½ÐµÑ‚
                      [5] =&gt; This test Short des
                  )
  </code></pre>
  
  <p>But the original value is like,</p>
  
  <pre><code>Бесплатный переводчик , перевод , Бесплатный словарь Интернет
  </code></pre>