Excel可以自訂欄位的文字樣式,那叫Rich-Text
然而匯入資料的時候,我不需要用到Rich-Text
所以用了getFormattedValue()這個函式
它可以將 Rich-Text 去除
getValue();
[0] => 2 | |
[1] => D221789341 | |
[2] => 王大華 | |
[3] => 女 | |
[4] => 1981-02-02 | |
[5] => 07-3456789 | |
[6] => 07-55667788 | |
[7] => 0922334455 | |
[8] => def@gmail.com | |
[9] => 高雄市 | |
[10] => 高雄市楠梓區中山路69號 | |
[11] => 812 | |
[12] => 學者 | |
[13] => | |
[14] => 中山大學 | |
[15] => 資訊工程系 | |
[16] => 研究所 | |
[17] => 商學類 | |
[18] => 國際貿易 | |
[19] => C0200 | |
[20] => 專業2 | |
[21] => 衛生學類 | |
[22] => 公共衛生 | |
[23] => I0100 | |
[24] => 專業5 | |
[25] => PHPExcel_RichText Object | |
( | |
[_richTextElements:private] => Array | |
( | |
[0] => PHPExcel_RichText_Run Object | |
( | |
[_font:private] => PHPExcel_Style_Font Object | |
( | |
[_name:private] => 新細明體 | |
[_size:private] => 10 | |
[_bold:private] => | |
[_italic:private] => | |
[_superScript:private] => | |
[_subScript:private] => | |
[_underline:private] => none | |
[_strikethrough:private] => | |
[_color:private] => PHPExcel_Style_Color Object | |
( | |
[_argb:private] => FF333333 | |
[_isSupervisor:private] => | |
[_parent:private] => | |
[_parentPropertyName:private] => | |
) | |
[_parentPropertyName:private] => | |
[_isSupervisor:private] => | |
[_parent:private] => | |
[colorIndex] => 63 | |
) | |
[_text:private] => 中國鋼鐵 | |
) | |
) | |
) |
getFormattedValue();
[0] => 2 | |
[1] => D221789341 | |
[2] => 王大華 | |
[3] => 女 | |
[4] => 1981-02-02 | |
[5] => 07-3456789 | |
[6] => 07-55667788 | |
[7] => 0922334455 | |
[8] => def@gmail.com | |
[9] => 高雄市 | |
[10] => 高雄市楠梓區中山路69號 | |
[11] => 812 | |
[12] => 學者 | |
[13] => | |
[14] => 中山大學 | |
[15] => 資訊工程系 | |
[16] => 研究所 | |
[17] => 商學類 | |
[18] => 國際貿易 | |
[19] => C0200 | |
[20] => 專業2 | |
[21] => 衛生學類 | |
[22] => 公共衛生 | |
[23] => I0100 | |
[24] => 專業5 | |
[25] => 中國鋼鐵 |