网页中的数据导出问题(word文档等格式)

川长思鸟来 2021-11-26 20:04 333阅读 0赞

方法一：  
![None.gif][]

![None.gif][] HttpContext.Current.Response.AppendHeader( " Content-Disposition " ,  " attachment;filename= "   \+  filename);  
![None.gif][]HttpContext.Current.Response.Charset  =   " UTF-8 " ;  
![None.gif][]HttpContext.Current.Response.ContentEncoding  =  System.Text.Encoding.Default;  
![None.gif][]  HttpContext.Current.Response.ContentType  =  filetype;  
![None.gif][]  // HttpContext.Current.Response.ContentType = "application/ms-excel"; // image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword   
![None.gif][] HttpContext.Current.Response.Buffer  =   true   
![None.gif][]System.IO.StringWriter tw  =   new  System.IO.StringWriter();  
![None.gif][]System.Web.UI.HtmlTextWriter hw  =   new  System.Web.UI.HtmlTextWriter(tw);  
![None.gif][]gv.RenderControl(hw);  
![None.gif][]  
![None.gif][]HttpContext.Current.Response.Write(tw.ToString());  
![None.gif][]HttpContext.Current.Response.End();

方法二：

![None.gif][] private     void    ExportWord\_Click( object    sender,   System.EventArgs   e)    
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]   ![dot.gif][] \{    
![InBlock.gif][]  try    
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]  ![dot.gif][]\{    
![InBlock.gif][]  string   savepath   =   "";    
![InBlock.gif][]  FolderBrowserDialog   folderBrowserDialog1   =   new   FolderBrowserDialog();    
![InBlock.gif][]  if   (folderBrowserDialog1.ShowDialog()   ==   DialogResult.OK)      
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]  ![dot.gif][]\{    
![InBlock.gif][]  savepath   =   folderBrowserDialog1.SelectedPath;    
![ExpandedSubBlockEnd.gif][]  \}    
![InBlock.gif][]     
![InBlock.gif][]  Object   Nothing=System.Reflection.Missing.Value;    
![InBlock.gif][]  object   filename   =   savepath   \+   "/"   \+   StoreNum.Text   \+   "库存报表";    
![InBlock.gif][]  Word.Application   WordApp=new   Word.ApplicationClass();    
![InBlock.gif][]  Word.Document   WordDoc=WordApp.Documents.Add(ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing);    
![InBlock.gif][]     
![InBlock.gif][]  WordDoc.Paragraphs.First.Range.Text   =   "库存报表       \[共有："   \+   storedt.Rows.Count.ToString()   \+   "本书\]";    
![InBlock.gif][]  WordDoc.Paragraphs.First.Alignment   =   Word.WdParagraphAlignment.wdAlignParagraphCenter;    
![InBlock.gif][]     
![InBlock.gif][]  Word.Table   table=WordDoc.Tables.Add(WordApp.Selection.Range,storedt.Rows.Count\+1,6,ref   Nothing,ref   Nothing);    
![InBlock.gif][]  table.Cell(1,1).Range.Text="ISBN号";    
![InBlock.gif][]  table.Cell(1,2).Range.Text="书名";    
![InBlock.gif][]  table.Cell(1,3).Range.Text="总库存";    
![InBlock.gif][]  table.Cell(1,4).Range.Text="借书库存";    
![InBlock.gif][]  table.Cell(1,5).Range.Text="可借数量";    
![InBlock.gif][]  table.Cell(1,6).Range.Text="已借数量";    
![InBlock.gif][]     
![InBlock.gif][]  for   (   int   i=0;i<storedt.Rows.Count;i\++   )    
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]  ![dot.gif][]\{    
![InBlock.gif][]  table.Cell(i\+2,1).Range.Text   =   storedt.Rows\[i\]\["Book\_ISBN"\].ToString();    
![InBlock.gif][]  table.Cell(i\+2,2).Range.Text   =   storedt.Rows\[i\]\["Book\_Name"\].ToString();    
![InBlock.gif][]  table.Cell(i\+2,3).Range.Text   =   storedt.Rows\[i\]\["Store\_Num"\].ToString();    
![InBlock.gif][]  table.Cell(i\+2,4).Range.Text   =   storedt.Rows\[i\]\["CanBorrow\_Num"\].ToString();    
![InBlock.gif][]  table.Cell(i\+2,5).Range.Text   =   storedt.Rows\[i\]\["InShop\_Num"\].ToString();    
![InBlock.gif][]  table.Cell(i\+2,6).Range.Text   =   storedt.Rows\[i\]\["OutShop\_Num"\].ToString();    
![ExpandedSubBlockEnd.gif][]  \}    
![InBlock.gif][]     
![InBlock.gif][]  WordDoc.SaveAs(ref   filename,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing,ref   Nothing);    
![InBlock.gif][]  WordDoc.Close(ref   Nothing,   ref   Nothing,   ref   Nothing);    
![InBlock.gif][]  WordApp.Quit(ref   Nothing,   ref   Nothing,   ref   Nothing);    
![InBlock.gif][]  parent.statusBar1.Panels\[0\].Text   =   "操作提示：库存报表导出成功";    
![ExpandedSubBlockEnd.gif][]  \}    
![InBlock.gif][]  catch    
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]  ![dot.gif][]\{    
![InBlock.gif][]  parent.statusBar1.Panels\[0\].Text   =   "操作提示：库存报表导出失败";    
![ExpandedSubBlockEnd.gif][]  \}    
![ExpandedBlockEnd.gif][]  \}     
![None.gif][]     
![None.gif][]  注意要引用Interop.Word.dll，并且在机器上安装Word2002，否则导出将失败

转载于:https://www.cnblogs.com/zjx-sir/archive/2008/07/09/1238960.html

[None.gif]: /images/20211126/5669fd24a51040348049b00562b06d7f.png
[ExpandedBlockStart.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif
[ContractedBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif
[dot.gif]: /images/20211126/9c77d43240bc44838a83f91e611509d1.png
[InBlock.gif]: /images/20211126/87580ddc90d4416e9021f977f4a273dc.png
[ExpandedSubBlockStart.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif
[ContractedSubBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif
[ExpandedSubBlockEnd.gif]: /images/20211126/bbb154d2b3fd460c98d112ba112c5613.png
[ExpandedBlockEnd.gif]: /images/20211126/1c3a5fe012f046948717b1e54e700b9b.png