export datagrid's data to excel

朱雀 2021-10-24 04:38 176阅读 0赞

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] 代码

protected   void  export\_Click( object  sender, EventArgs e)  
    \{  
        BusinessLayer bl  =   new  BusinessLayer();  
        DataTable dt  =  bl.GetAllUnpaidOrders().Tables\[ 0 \];  
         byte \[\] dataBuffer  =   GetTimesheetReporteStream(dt);  
         string  fileName  =   " TimesheetDefaulterReport.csv " ;  
         this .Response.Clear();  
         this .Response.Charset  =   " GB2312 " ;  
         this .Response.ContentEncoding  =  System.Text.Encoding.GetEncoding( " GB2312 " );  
         this .Response.ContentType  =   " application/vnd.ms-excel " ;  //  "application/octet-stream";  // "application/ms-excel";  // vnd.   
          this .Response.AppendHeader( " content-disposition " ,  " attachment; filename= "   \+  HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8).Replace( " \+ " ,  " %20 " ));  
         this .Response.OutputStream.Write(dataBuffer,  0 , dataBuffer.Length);  
         this .Response.Flush();  
         this .Response.End();  
    \}  
     public   byte \[\] GetTimesheetReporteStream(DataTable dt)  
    \{  
        StringBuilder builder  =   new  StringBuilder();  
         foreach  (DataColumn column  in  dt.Columns)  
        \{  
            builder.Append(column.ColumnName  \+   " , " );  
        \}  
        builder.Append(Environment.NewLine);  
         foreach  (DataRow row  in  dt.Rows)  
        \{  
             for  ( int  i  =   0 ; i  <  dt.Columns.Count; i \++ )  
            \{  
                builder.Append(ConvertToCsvCell(row\[i\].ToString())  \+   " , " );  
            \}  
            builder.Append(Environment.NewLine);  
        \}  
         byte \[\] dataBuffer  =  Encoding.Default.GetBytes(builder.ToString());  
         return  dataBuffer;  
    \}  
     public   static   string  ConvertToCsvCell( string  cell)  
    \{  
        cell  =  SBCToDBC(cell);  
         if  (cell.Contains( @" , " )  ||  cell.Contains( " \\ "" ))   
         \{  
            cell  =  cell.Replace( " \\ "" ,  " \\ " \\ "" );   
             cell  =   " \\ ""  + cell +  " \\ "" ;  
        \}  
         else   
        \{  
             if  (cell.Contains( " \\r " )  ||  cell.Contains( " \\n " ))  
            \{  
                cell  =   " \\ ""  + cell +  " \\ "" ;  
            \}  
        \}  
         return  cell;  
    \}  
     public   static   string  SBCToDBC( string  input)  
    \{  
         char \[\] cc  =  input.ToCharArray();  
         for  ( int  i  =   0 ; i  <  cc.Length; i \++ )  
        \{  
             if  (cc\[i\]  ==   8220   ||  cc\[i\]  ==   8221 )  
            \{  
                cc\[i\]  =  ( char ) 34 ;  
                 continue ;  
            \}  
             if  (cc\[i\]  ==   8216   ||  cc\[i\]  ==   8217 )  
            \{  
                cc\[i\]  =  ( char ) 39 ;  
                 continue ;  
            \}  
             if  (cc\[i\]  ==   12288 )  
            \{  
                cc\[i\]  =  ( char ) 32 ;  
                 continue ;  
            \}  
             if  (cc\[i\]  >   65280   &&  cc\[i\]  <   65375 )  
            \{  
                cc\[i\]  =  ( char )(cc\[i\]  \-   65248 );  
            \}  
  
        \}  
         return   new   string (cc);  
    \}

转载于:https://www.cnblogs.com/xpwilson/archive/2010/01/26/1656815.html

[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211023/d126e713c7444e098b0cabd5163c3e4f.png