Aap表导出到excel [英] Aap table export to excel

问题描述

嗨我将asp表格导出为ex​​cel但我想让表格标题不可编辑，请指导我....

 Response.ClearContent（）; 
  string  filename =   FY15输入集合模板_  + ddlcity.SelectedItem.Text +  。xls; 
 Response.AddHeader（  content-disposition，  attachment; filename = + filename）; 
 Response.Charset =   UTF-8; 
 Response.ContentType =   application / vnd.ms-excel; 
 StringWriter tw =  new  StringWriter（）; 
 HtmlTextWriter hw =  new  HtmlTextWriter（tw）; 
 Microsoft.Office.Interop.Excel.ApplicationClass _ExcelApp =  new  Microsoft.Office.Interop.Excel.ApplicationClass（）; 
 _ExcelApp.DisplayAlerts =  false ; 
 tbcity.RenderControl（hw）; 
 tbannualpercent.RenderControl（hw）; 
 tblasm.RenderControl（hw）; 
 tbtwotable.RenderControl（hw）; 
 tbsectb.RenderControl（hw）; 
 tbthreetb.RenderControl（hw）; 
 tbthirdtb.RenderControl（hw）; 
  this  .EnableViewState =  false ; 
 Response.Write（tw.ToString（））; 
 Response.Flush（）; 
 Response.End（）; 

这就是我尝试将其导出为ex​​cel的方式但是如何在excel中将表格标题设置为不可编辑...我没有得到excel表格实例来锁定单元格请任何人帮助我...

解决方案

参考



导出Asp表格到Excel [ ^ ]



asp-table -to-excel [ ^

hi i am exporting asp tables to excel but i want to make table headers non-editable please guide me....

Response.ClearContent();
                string filename = "FY15 Input Collection Template_" + ddlcity.SelectedItem.Text + ".xls";
                Response.AddHeader("content-disposition", "attachment;filename=" + filename);
                Response.Charset = "UTF-8";
                Response.ContentType = "application/vnd.ms-excel";
                StringWriter tw = new StringWriter();
                HtmlTextWriter hw = new HtmlTextWriter(tw);
                Microsoft.Office.Interop.Excel.ApplicationClass _ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
                _ExcelApp.DisplayAlerts = false;
                tbcity.RenderControl(hw);
                tbannualpercent.RenderControl(hw);
                tblasm.RenderControl(hw);
                tbtwotable.RenderControl(hw);
                tbsectb.RenderControl(hw);
                tbthreetb.RenderControl(hw);
                tbthirdtb.RenderControl(hw);
                this.EnableViewState = false;
                Response.Write(tw.ToString());
                Response.Flush();
                Response.End();

this is how i tried its exporting to excel but how can i make table headers as non-editable in excel...i am not getting excel sheet instance to lock cells please any one help me...

解决方案

Refer

Export Asp Table to Excel[^]

asp-table-to-excel[^]

这篇关于Aap表导出到excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！