### Excel 導出數據首位不去0的方法 Excel 表格導出在我們的項目開發中是比較多常用的一種使用場景，但是由于Excel 軟件自身的原因會對首位有0的數據自動去0操作，為了使數據的完整性得到保證，我們可以利用PHP代碼來解決這個問題。 **解決方法：** 只要在利用PHP代碼對數據進行一個簡單的處理，在首位有0的數據前加上“\t”，那么這個問題就完美解決了。  **完整代碼：** ~~~ <?php /** * * Werp/報表/倉庫、店鋪實時統計 * Lanson * 2017-03-05 * */ namespace Werp\Controller\Report; use Werp\Controller\IndexController; use Werp\Model\Report\GoodsCountInfoModel; class StockalllattestdataController extends IndexController { public function export_excel_data() { $params = I('param.'); $params = $this->get_search_to_array($params); $allGoods = new GoodsCountInfoModel(); $allGoods->setWhere($params); $no = $allGoods->getGoodsInfo(); $allGoods->setArray($no); $res = $allGoods->getGoodsMenu(2); $this->title = array("圖片","唯一碼","系統款號","國際碼","商品名稱","大類名稱","年季","品牌","品牌線","中類名稱","小類名稱","性別","執行標準","安全級別","等級","產地","顏色","顏色名稱","尺碼","號型規格","面料","里料","輔料","填充物","折扣","吊牌價","位置"); $this->fileName = '庫存信息'.date('Y-M-D',time()); foreach ($res as $k => $v) { if (!empty($res[$k]['image'])) { if ($res[$k]['image_status'] != 1) { $res[$k]['image'] = C('IMAGE_OSS_URL').$res[$k]['image']; } else { $res[$k]['image'] = 'http://work.coscia.com.cn'.$res[$k]['image']; } } if (isset($res[$k]['image_status'])) { unset($res[$k]['image_status']); } //循環處理數據，在首位有0的數據都加上“\t”符號 $res[$k]['color'] = "\t".$v['color']; unset($res[$k]['id']); } $this->data = array_values($res); $this->export_excel(); } ~~~