$(document).ready(function () {
$("#btnExport").bind("click", function () {
$("#dataTable").tableExport({
type: 'excel',
escape: 'false',
filename: '(2016-02-29_2016-03-06)'
});
});
})
<input id="btnExport" name="" value="导 出" type="button" class="btn btn-primary btn2" />
<script src="../Scripts/jquery.base64.js"></script>
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType = "application/ms-excel";
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
tw.Write("用户名\t列明 ");
if (!string.IsNullOrEmpty(playerid))
{
string sql = "select * from RecordUserLeave where userid=" + playerid + " order by LeaveTime desc";
DataTable dtex = new DataTable();
SqlHelper.FillDataTable(6, sql, dtex); tw.Write("\n");
for (int i = 0; i < dtex.Rows.Count; i++)
{
tw.Write(accounts + "\t" + dtex.Rows[i]["Score"].ToString() + "\t" + dtex.Rows[i]["Revenue"].ToString() + "\t" + getGameNameByID(dtex.Rows[i]["kindid"].ToString()) + "\t" + dtex.Rows[i]["ServerID"].ToString() + "\t" + dtex.Rows[i]["PlayTimeCount"].ToString() + "\t" + dtex.Rows[i]["OnLineTimeCount"].ToString() + "\t" + dtex.Rows[i]["LeaveTime"].ToString() + "\t");
tw.Write("\n");
}
}
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
$("#btnExport").bind("click", function () {
$("#dataTable").tableExport({
type: 'excel',
escape: 'false',
filename: '(2016-02-29_2016-03-06)'
});
});
})
<input id="btnExport" name="" value="导 出" type="button" class="btn btn-primary btn2" />
<script src="../Scripts/jquery.base64.js"></script>
<script src="../Scripts/tableExport.js"></script>
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType = "application/ms-excel";
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
tw.Write("用户名\t列明 ");
if (!string.IsNullOrEmpty(playerid))
{
string sql = "select * from RecordUserLeave where userid=" + playerid + " order by LeaveTime desc";
DataTable dtex = new DataTable();
SqlHelper.FillDataTable(6, sql, dtex); tw.Write("\n");
for (int i = 0; i < dtex.Rows.Count; i++)
{
tw.Write(accounts + "\t" + dtex.Rows[i]["Score"].ToString() + "\t" + dtex.Rows[i]["Revenue"].ToString() + "\t" + getGameNameByID(dtex.Rows[i]["kindid"].ToString()) + "\t" + dtex.Rows[i]["ServerID"].ToString() + "\t" + dtex.Rows[i]["PlayTimeCount"].ToString() + "\t" + dtex.Rows[i]["OnLineTimeCount"].ToString() + "\t" + dtex.Rows[i]["LeaveTime"].ToString() + "\t");
tw.Write("\n");
}
}
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();