asp.netÀïµ¼³öexcel±í·½·¨»ã×Ü

 1¡¢ÓÉdatasetÉú³É
public void CreateExcel(DataSet ds,string typeid,string FileName) 
  {
   HttpResponse resp;
   resp = Page.Response;
   resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
   resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);   
   string colHeaders= "", ls_item="";
   int i=0;
 
   //¶¨Òå±í¶ÔÏóÓëÐжÔÏñ£¬Í¬Ê±ÓÃDataSet¶ÔÆäÖµ½øÐгõʼ»¯
   DataTable dt=ds.Tables[0];
   DataRow[] myRow=dt.Select(""); 
   // typeid=="1"ʱµ¼³öΪEXCEL¸ñʽÎļþ£»typeid=="2"ʱµ¼³öΪXML¸ñʽÎļþ
   if(typeid=="1")
   {
    //È¡µÃÊý¾Ý±í¸÷ÁбêÌ⣬¸÷±êÌâÖ®¼äÒÔ\t·Ö¸î£¬×îºóÒ»¸öÁбêÌâºó¼Ó»Ø³µ·û
    for(i=0;i     colHeaders+=dt.Columns[i].Caption.ToString()+"\t";
    colHeaders +=dt.Columns[i].Caption.ToString() +"\n";   
    //ÏòHTTPÊä³öÁ÷ÖÐдÈëÈ¡µÃµÄÊý¾ÝÐÅÏ¢
    resp.Write(colHeaders); 
    //ÖðÐд¦ÀíÊý¾Ý  
    foreach(DataRow row in myRow)
    {
     //ÔÚµ±Ç°ÐÐÖУ¬ÖðÁлñµÃÊý¾Ý£¬Êý¾ÝÖ®¼äÒÔ\t·Ö¸î£¬½áÊøʱ¼Ó»Ø³µ·û\n
     for(i=0;i      ls_item +=row[i].ToString() + "\t";     
     ls_item += row[i].ToString() +"\n";
     //µ±Ç°ÐÐÊý¾ÝдÈëHTTPÊä³öÁ÷£¬²¢ÇÒÖÿÕls_itemÒÔ±ãÏÂÐÐÊý¾Ý    
     resp.Write(ls_item);
     ls_item="";
    }
   }
   else
   {
    if(typeid=="2")
    { 
     //´ÓDataSetÖÐÖ±½Óµ¼³öXMLÊý¾Ý²¢ÇÒдµ½HTTPÊä³öÁ÷ÖÐ
     resp.Write(ds.