### 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(); } ~~~