Question

如何将button控件text文本内容写入到指定excel表格中去并生成表格。

c#如何将button和combox等控件text内容生成到excel文件中，即将其text内容写入到excel指定单元格中，还有用c#如何操作表格，比如生成表格等操作，最好求加qq具体指导
　　哪位大神可以在这直接回复吗，我想

实现以下功能





Answer 1

若想导缓盯闷出数据到Excel表，需扰弯要添加引用则租（项目-添加引用-Microsoft.Office.Interop.Excel).

Answer 2

在页面中加一个导出按钮
<asp:Button ID="btnInputExcel" runat="server" Width="50" Text="导 出" onclick="btnInputExcel_Click"/>
/// <summary>
/// 导出数据函数
/// </summary>
/// <param name="FileType">导出文件MIME类型</param>
/// <param name="FileName">导出文件的名称</param>
private void Export(String FileType, String FileName)
{
Response.Clear();
Response.BufferOutput = true;
//设定输出字符集
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename="
+ HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
//设置输出流HttpMiME类型(导出文件格式)
Response.ContentType = FileType;
//关闭ViewState
Page.EnableViewState = false;
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter stringWriter = new System.IO.StringWriter(cultureInfo);
HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter);
rpt_pro.RenderControl(textWriter);
//把HTML写回游览器
Response.Write(stringWriter.ToString());
Response.End();
Response.Flush();
}

//确认在运行时为指定的信稿 ASP.NET 服务器控件呈现在 HtmlForm 控槐颂件中。
//(检验Asp.Net服务器空间是否呈现在滑明孝HTMLForm控件中)
public override void VerifyRenderingInServerForm(System.Web.UI.Control control)
{
}

#region 导出成Excel
protected void btnInputExcel_Click(object sender, EventArgs e)
{
Export("application/ms-excel", "员工评分表.xls");
}
#endregion

导出成word的话，可以另外加一个按钮
#region 导出成Excel
protected void btnInputWord_Click(object sender, EventArgs e)
{
Export("application/ms-word", "员工评分表.doc");
}
#endregion