php  excel导出 CVS格式  乐杨俊

      '651651616',            'pick_mode' => '1',            'auto_add_goods' => '0',            'type' => 'jit',            'schedule_time' => '20013-00-00',            'num' => '25045',            'sale_num' => '2054',            'unpick_num' => '6234',            'warehouse_name' => 'bj', );  $param [2] = array (   'po' => '651651612',            'pick_mode' => '1',            'auto_add_goods' => '0',            'type' => 'jit2',            'schedule_time' => '20013-00-002',            'num' => '2502',            'sale_num' => '20267',            'unpick_num' => '622',            'warehouse_name' => 'bj2',  );  $param [3] = array (   'po' => '651651613',            'pick_mode' => '1',            'auto_add_goods' => '0',            'type' => 'jit3',            'schedule_time' => '20013-00-003',            'num' => '2503',            'sale_num' => '203',            'unpick_num' => '6236',            'warehouse_name' => 'bj3',  );  $param [4] = array (   'po' => '651651614',            'pick_mode' => '1',            'auto_add_goods' => '0',            'type' => 'jit4',            'schedule_time' => '20013-00-004',            'num' => '2504',            'sale_num' => '204',            'unpick_num' => '6246',            'warehouse_name' => 'bj4',  );  $param [5] = array (   'po' => '812231134',            'pick_mode' => '0',            'auto_add_goods' => '1',            'type' => 'jit5',            'schedule_time' => '2013-00-004',            'num' => '8888',            'sale_num' => '8848',            'unpick_num' => '6000',            'warehouse_name' => 'BJ',  );  $name='leyangjun';  $filename = mb_convert_encoding($name, 'gb2312', 'utf-8');        $title = array(            'po' => 'PO单编号',            'pick_mode' => '拣货方式',            'auto_add_goods' => '自动补货',            'type' => '合作模式',            'schedule_time' => '档期时间',            'num' => '虚拟总库存',            'sale_num' => '销售数',            'unpick_num' => '未拣货',            'warehouse_name' => '仓库',        );       $ii = 0;        if (!empty($param)) {            foreach ($param as $key => $val) {                $val['type'] = isset($val['type']) ? $val['type'] : '';                $val['schedule_time'] = isset($val['sell_time_from']) || isset($val['sell_time_to']) ? ($val['sell_time_from'] . '—' . $val['sell_time_to']) : '';                $val['pick_mode'] = isset($val['pick_mode']) ? ($val['pick_mode'] > 1 ? '分类' : '普通') : '';                $val['auto_add_goods'] = isset($val['auto_add_goods']) ? ($val['auto_add_goods'] > 0 ? '开启' : '关闭') : '';                $val['schedule_time'] = isset($val['schedule_time']) ? ($val['schedule_time'] == '0000-00-00 00:00:00—0000-00-00 00:00:00' ? '' : $val['schedule_time']) : '';                foreach ($title as $tk => $tv) {                    if (!isset($val[$tk])) {                        $val[$tk] = '';                    }                    $list[$ii][] = $val[$tk];                }                $ii++;            }        }        //未设置给默认--防报错        if (!isset($list)) {            $list[0][0] = "";            $list[0][1] = "";            $list[0][2] = "";            $list[0][3] = "";            $list[0][4] = "";            $list[0][5] = "";            $list[0][6] = "";            $list[0][7] = "";            $list[0][8] = "";            $list[0][9] = "";            $list[0][10] = "";        }        //表头数据        $headerDate = array_values($title);        //内容体数据        $bodyData = $list;        //设置工作区名称        $sheetName = 'Jit_po列表详情';        //设置要导出的excel文件名          $fileName = $name;        //设置要导出的excel文件后缀名，支持xls和xlsx        $fileExt = 'xls';        //调用类库导出excel        //ini_set('memory_limit', '512M');        //cvs格式     to_csv($fileName, $headerDate, $bodyData, array(0, 10, 14, 15), $flag=1);      //CVS格式/*   function to_csv($file_name, $headerDate, $bodyData, $array_text, $flag) {        // 输出Excel文件头，可把user.csv换成你要的文件名         if (!headers_sent()) {            header('Content-Type: application/vnd.ms-excel');            header('Content-Disposition: attachment;filename="' . $file_name . '.csv"');            header('Cache-Control: max-age=0');        }        // 打开PHP文件句柄，php://output 表示直接输出到浏览器         $fp = fopen('php://output', 'a');        foreach ($headerDate as $i => $v) {            // CSV的Excel支持GBK编码，一定要转换，否则乱码             $headerDate[$i] = iconv('utf-8', 'gbk', $v);        }        // 将数据通过fputcsv写到文件句柄           if ($flag == 1) {            fputcsv($fp, $headerDate);        }        // 逐行取出数据，不浪费内存         foreach ($bodyData as $row) {            foreach ($row as $i => $v) {                $row[$i] = iconv('utf-8', 'gbk', $v);                if (in_array($i, $array_text)) {                    $row[$i] = "\t" . $row[$i];                }            }            fputcsv($fp, $row);        }    }*/  ?>

读取数据库

$param=array(); $i=0;$row=mysql_fetch_assoc($data);do{$param[$i]=$row;$i++;}while ($row=mysql_fetch_assoc($data));

 

 

原文地址：http://blog.csdn.net/leyangjun/article/details/19916385