开发者

How can I read German characters (äöü߀) in Excel via PHPExcel?

I'm reading this Excel file:

How can I read German characters (äöü߀) in Excel via PHPExcel?

with PHPExcel but it looks like this:

How can I read German characters (äöü߀) in Excel via PHPExcel?

I am using this code:

$objReader = PHPExcel_IOFactory::createReaderForFile("data/".$file_name);
$objReader->setLoadSheetsOnly(array(0));
$objPHPExcel = $objReader->load("data/".$file_name);开发者_StackOverflow

echo '<table border="1">';
for ($row = 1; $row < $number_of_rows; $row++) {
    echo '<tr>';
    for ($column = 0; $column < $number_of_columns; $column++) {
        $value = $objPHPExcel->setActiveSheetIndex(0)->getCellByColumnAndRow($column, $row)->getValue();
        echo '<td>';
        $newValue = iconv("ISO-8859-1", "UTF-8", $value); //has no effect
        // echo $newValue . '&nbsp;';
        echo $value . '&nbsp;';
        echo '</td>';
    }
    echo '</tr>';
}
echo '</table>';
die; 

How can I read in the German characters from the Excel sheet correctly?


PHPExcel uses UTF-8 internally, so it will render all characters correctly if your html page is set as UTF-8

$newValue = iconv("ISO-8859-1", "UTF-8", $value); //has no effect 

won't work, because the characters are already UTF-8 and you're assuming they're ISO-8859-1

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜