php去除excel换行符,php – 如何解析包含数据中的换行符的Excel数据？

根据PHP

fgetcsv功能文档中的评论者aleske的说法：

The PHP’s CSV handling stuff is non-standard and contradicts with RFC4180, thus fgetcsv() cannot properly deal with files [that contain line breaks] …

他提供了以下功能来解决这个限制：

function csvstring_to_array(&$string, $CSV_SEPARATOR = ';', $CSV_ENCLOSURE = '"', $CSV_LINEBREAK = "\n") {

$o = array();

$cnt = strlen($string);

$esc = false;

$escesc = false;

$num = 0;

$i = 0;

while ($i < $cnt) {

$s = $string[$i];

if ($s == $CSV_LINEBREAK) {

if ($esc) {

$o[$num] .= $s;

} else {

$i++;

break;

}

} elseif ($s == $CSV_SEPARATOR) {

if ($esc) {

$o[$num] .= $s;

} else {

$num++;

$esc = false;

$escesc = false;

}

} elseif ($s == $CSV_ENCLOSURE) {

if ($escesc) {

$o[$num] .= $CSV_ENCLOSURE;

$escesc = false;

}

if ($esc) {

$esc = false;

$escesc = true;

} else {

$esc = true;

$escesc = false;

}

} else {

if ($escesc) {

$o[$num] .= $CSV_ENCLOSURE;

$escesc = false;

}

$o[$num] .= $s;

}

$i++;

}

// $string = substr($string, $i);

return $o;

}

看起来它会成功.