asp.net 数据导成excel

2012-06-07 10:11:17 144 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

图数据挖掘 ECC K-core core number truss number clique K-core:什么叫k-core，给定一个正整数k（k>=0），k-core是一个G的最大子图（也就是说k-core是一个图的限制），将这个子图定义为Hk，对于Hk中的每个顶点v，他的度数都是大于等于k的。 k-core是内嵌的，如下图所示，集合{ABCD}是H3，也就是3-core的子图。而集合{ABCDE}是H2，也就是2-core的子图，集合{ABCDEGF}是H1，也就是1-core的子图，而从集合的角度来讲H3<H2<H1。 core number:什么叫kcor 阅读详情

在ASP.NET中如何将gridview控件中的数据导成excel中，希望附带代码谢谢

...全文

Uniapp H5端SEO优化全攻略：提升搜索引擎排名与流量在移动互联网时代，H5页面因其跨平台、低成本、易传播的特性，成为许多企业的首选。Uniapp作为一款优秀的前端跨端开发框架，能够快速开发H5、小程序、App等多端应用。然而，由于Uniapp默认采用SPA（单页应用）架构，H5端在SEO（搜索引擎优化）方面存在一定劣势，如爬虫难以抓取动态内容、页面标题和描述不易优化等。本文将系统性地介绍Uniapp H5端的SEO优化方案，涵盖基础优化、SPA优化策略、内容优化、技术优化、外部优化及监测分析，帮助开发者提升网站在搜索引擎中的排名，获取更多自然流量。阅读详情

tingliu13

.NET社区 62,272 成员 668,968 内容

+ 关注 + 加入社区

切换为时间正序

liue_0612 2012-06-07

打赏
举报

protected void Button1_Click(object sender, EventArgs e)
{
ExportExcelFromDataGrid("GridviewExcel.xls", GridView1);
}

private void ExportExcelFromDataGrid(string filename, System.Web.UI.WebControls.GridView ToExcelGrid)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(filename));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。

this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
ToExcelGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}

//如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内ITPUB个人空间 cB6w"i'J/n

public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
//里边不写任何的东西
}

专注研发ERP低代码开发平台 2012-06-07

打赏
举报

可以看一这个
GridView数据导出到Excel与Excel数据导入到GridView示例

z1041928903 2012-06-07

打赏
举报

//导出Excel
protected void ExportExcel(System.Data.DataTable dt)
{
if (dt == null || dt.Rows.Count == 0) return;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

if (xlApp == null)
{
return;
}
System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
Microsoft.Office.Interop.Excel.Range range;
long totalCount = dt.Rows.Count;
long rowRead = 0;
float percent = 0;
for (int i = 0; i < dt.Columns.Count; i++)
{
worksheet.Cells[1, i + 1] = dt.Columns[i].ColumnName;
range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[1, i + 1];
range.Interior.ColorIndex = 15;
range.Font.Bold = true;
}
for (int r = 0; r < dt.Rows.Count; r++)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
worksheet.Cells[r + 2, i + 1] = dt.Rows[r][i].ToString();
}
rowRead++;
percent = ((float)(100 * rowRead)) / totalCount;
}
xlApp.Visible = true;
}
//给DataTable赋值
public void GenerateExcel()
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Age", typeof(string));
DataRow dr = dt.NewRow();
dr["Name"] = "spring";
dr["Age"] = "20";
dt.Rows.Add(dr);
dt.AcceptChanges();
ExportExcel(dt);
}
protected void Button1_Click(object sender, EventArgs e)
{
GenerateExcel();
}

xpj044384444 2012-06-07

打赏
举报

string attachment = "attachment; filename=stuinfo.xls";
HttpResponse Response = HttpContext.Current.Response;
Response.ClearContent();
Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw); // Create a form to contain the grid
HtmlForm frm = new HtmlForm();

gdv_Data_HrMoonReport.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(gdv_Data_HrMoonReport);
frm.RenderControl(htw); //GridView1.RenderControl(htw);
Response.Charset = "UTF-8 ";
//Response.ContentEncoding =System.Test.Encoding.GetEncoding("UTF-8 ");
Response.Write(sw.ToString());
Response.End();

gdv_Data_HrMoonReport 是gridview的id

asp.net 数据导成excel

相关推荐