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] => 中國鋼鐵 |