如何用PHP将MySql中的数据导如Excle

Question

简单点的办法。将mysql中的数据倒出成固定格式的文本在用excel倒入。

Answer 1

1. mysql output .cvs
2. excel load .cvs

Answer 2

给你段我用过的代码，你慢慢研究一下<?
Header("Content-type: application/octet-stream");
Header("Accept-Ranges: bytes");
Header("Content-Disposition: attachment; filename=" . $file_name.".csv"); //header("Content-type:application/vnd.ms-excel");
//header("Content-Disposition:filename=test.xls");require ("../include/common.inc.php");$db  = new DB_test;$today = gmdate("M d Y ") ;
$number = "baojiadan";
echo "\" \",\"Wintop Office  \",\"Wenzhou-China\",\" \",\"Customer\",\"ALL\",\" \",\"Date\",\"$today\",\"\"\n";
echo "\" \",\"Wintop Staff  \",\"Zhu Yongbin\",\" \",\"Customer Ref\",\" \",\" \",\"No.\",\"$number\",\"\"\n\n";if(!empty($qtatnid)){
$query = "select * from tb_quotation where fd_qtatn_id = $qtatnid ";
$db->query($query);
if($db->nf()){                                //判断查询到的记录是否为空
   $db->next_record();                           //读取记录数据 
$no                   = $db->f(fd_qtatn_no             ) ;         //编号          
$date                 = $db->f(fd_qtatn_date           ) ;         //报价日期      
$cusid                = $db->f(fd_qtatn_cusid          ) ;         //客户ID        
$pricement            = $db->f(fd_qtatn_pricement      ) ;         //价格条款      
$memo                 = $db->f(fd_qtatn_memo           ) ;         //备注          
$man                  = $db->f(fd_qtatn_man            ) ;         //报价人        
$org                  = $db->f(fd_qtatn_org            ) ;         //报价机构      
$enddate              = $db->f(fd_qtatn_enddate        ) ;         //截止日期      
$consignmentdate      = $db->f(fd_qtatn_consignmentdate) ;         //交货期        
$payment              = $db->f(fd_qtatn_payment        ) ;         //付款方式说明  
$memocus              = $db->f(fd_qtatn_memocus        ) ;         //备注(客户可见)
}

echo "\"编号\",";
echo "\"类别\",";
echo "\"名称\",";
echo "\"规格\",";
echo "\"颜色\",";
echo "\"Corton\",";
echo "\"单位\",";
echo "\"认证\",";
echo "\"包装\",";
echo "\"币别\",";
echo "\"报价\" \n";

$query = "select * from tb_quotation_x
left join tb_commodity on fd_commo_id = fd_qtatnx_commid
where fd_qtatnx_qtatnid = $qtatnid ";
$db->query($query);
$count = 0 ;
while($db->next_record()){
$commcat      = $db->f(fd_commo_catalog  );       //商品类别
$commno         = $db->f(fd_commo_no       );       //商品编号
$commname      = $db->f(fd_commo_ename    );       //商品名称
$commspec     = $db->f(fd_commo_spec     );       //商品规格
$commcorton     = $db->f(fd_commo_trunksize);       //外箱尺寸
$communit      = $db->f(fd_commo_unit     );       //单位
$commpacktype = $db->f(fd_commo_packtype);       //商品数量
$commquantity = $db->f(fd_salex_quantity);       //内包装数量
$commtrunknum = $db->f(fd_commo_trunknum);       //外包装数量

echo "\"$commno\",";
echo "\"$commcat\",";
echo "\"$commname\",";
echo "\"$commspec\",";
echo "\" \",";
echo "\"$commcorton\",";
echo "\"$communit\",";
echo "\" \",";
echo "\"包装\",";
echo "\"币别\",";
echo "\"报价\" \n";
}
}?>