This method is just to save the ASP.NET page as an HTML page just to change the suffix to XLC but Excel can read, and let me see that there is another way to export data and use template build.
Below is the code
The TWEB application of the county new ASP.NE will paste the code into it.
HTML page code
<% @ Page language = "c #" codebehind = "outexcel.aspx.cs" autoeventwireup = "false" inherits = "EMENG.EXAM.OUTPUTEXCEL"%>
OutputExcel </ title> </ head> <body> <form id =" form1 "method =" post "runat =" server "> <asp: datagrid id = "DataGrid1" Runat = "Server"> <column> <asp: boundcolumn> </ asp: boundcolumn> </ columns> <asp: datagrid> <p> <asp: label id = "label1" runat = "server" > File Name: </ asp: label> <ask: textbox id = "textbox1" runat = "server"> </ asp: textbox> <ask: button id = "button1" runat = "text =" output to Excel "> </ asp: button> </ p> </ form> </ body> </ html></p>
<p>Next is the code in the CS page.</p>
<p>using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls Using system.Web.ui.htmlcontrols; using system.data.sqlclient;</p>
<p>Summary description of Namespace Emeng.exam {/// <summary> /// OutputExcel. /// </ summary> public class OutPutExcel: System.Web.UI.Page {protected System.Web.UI.WebControls.Button Button1; protected System.Web.UI.WebControls.DataGrid DataGrid1; protected System.Web.UI. WebControls.TextBox TextBox1; protected system.web.ui.webcontrols.label label1; private dataset myds = new dataset ();</p>
<p>Private void Page_load (Object Sender, System.EventArgs E) {// Place the user code here to initialize the page if (! page.ispostback) {data_load (); // call method fill the table}} /// <Summary> /// Create a data source /// </ summary> /// <returns> DataView </ RETURns> Private void data_load () {// Database connection string catalog for the specified database name, DataSource is the SQL server to connect Name string myconn = "user ID = sa; password = sa; initial catalog = test; data source = zxb; connect timeout = 20"; // Query string string mysqlstr = "select * from fy"; // Connect database operation SqlConnection myConnection = new SqlConnection (myConn); // execute SQL statements operation SqlDataAdapter myDataAdapter = new SqlDataAdapter (mySQLstr, myConnection); // open the database myConnection.Open (); // the DataSet padding data is filled in the test library database server FY Table MyDataAdapter.Fill (MyDS, "FY"); // Plip the data to Dastagrid Data DataGrid1.DataSource = MyDs; DataGrid1.Database ();} /// <summary> /// output to excel /// </ Summary> /// <param name = "sender"> </ param> /// <param name = "e"> </ param> private void button1_click (ibject sender, system.eventargs e) {i (TextBox1.text == "") {respon SE.WRITE ("<script language = javascript>); response.write (" WINDOW.Alert ('Please enter the file name'); "); response.write (" </ script> ");} else {response .Clear (); response.buffer = true; response.charset = "gb2312"; // Setting the type of Chinese to prevent garbled with Response.Appendheader ("Content-Disposition", "Attachment; FileName =" TextBox1.text ".xls"); // Define output file and file name response.contentencoding = system.text.Encoding.Getencoding ("GB2312"); // Set the output stream to Simplified Chinese response.contentType = "</p>
<p>Application / MS-Excel "; // Set the output file type to Excel file. this.enableviewState = false; system.globalization.cultureInfo mycitrad = new system.globalization.cultureInfo (" en-cn ", true); system.io. StringWriter oStringWriter = new System.IO.StringWriter (myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter (oStringWriter); this.DataGrid1.RenderControl (oHtmlTextWriter); Response.Write (oStringWriter.ToString ()}} #Region Web Form Designer Generated Code Override Protected Void OnNit (Eventargs E) {// // Codegen: This call is necessary for the ASP.NET Web Form Designer. // InitializationComponent Base.onit (E);</p>
<p>/// <summary> /// Designer supports the required method - do not use the code editor to modify the // / this method. /// </ summary> private void InitializeComponent () {this.DataGrid1.ItemDataBound = new System.Web.UI.WebControls.DataGridItemEventHandler (this.DataGrid1_ItemDataBound); this.Button1.Click = new System.EventHandler (this. Button1_click; this.load = new system.eventhandler (this.page_load);</p>
<p>} #Endregion</p>
<p>private void DataGrid1_ItemDataBound (object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) {if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) {e.Item.Cells [0] .attributes.add ("style", "vnd.ms-excel.numberformat: @"); E.Item.cells [3] .attributes.add ("style", "vnd.ms-excel.numberformat : ¥ #, ###. 00 ");}}}}</p>
<p>Still continuing to study other ways</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-47101.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="47101" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.053</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'SYeIzC54PS_2BlQNv5P4Ez6rVgraEtoMAX_2FGVfRImFh_2B9x3SUWXRK8STO15QCajPCAtVtyBpqNjEirfJGX1l_2BArQ_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
