.NET导出EXCEL表格出现如下问题。力求帮忙啊，谢谢

butterNo1 2009-04-30 10:22:27

Server Error in '/' Application.
________________________________________
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.

Source Error:

Line 137: //创建一个Application对象并使其可见
Line 138: beforeTime = DateTime.Now;
Line 139: app = new Excel.ApplicationClass();
Line 140: //app.Visible = true; 不自动打开
Line 141: afterTime = DateTime.Now;

Stack Trace:

...全文

881 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

NeptuneGrass 2009-04-30

打赏
举报

看这里吧
C#导出Excel/Csv格式数据

dengxiao1981 2009-04-30

打赏
举报

直接用流输出速度超快

harderLi 2009-04-30

打赏
举报

http://topic.csdn.net/u/20090427/17/97421876-daf1-4c3c-9ef5-96449aa207e7.html

liuping234232783 2009-04-30

打赏
举报

public override void VerifyRenderingInServerForm(Control control)
{

}
//生成Excel
protected void Button2_Click(object sender, EventArgs e)
{
Response.Clear();

Response.Charset = "UTF8";

Response.AddHeader("content-disposition", "attachment;filename=shengchanpaicheng.xls");

Response.ContentEncoding = System.Text.Encoding.UTF7;

Response.ContentType = "application/ms-excel";

System.IO.StringWriter strw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmw = new HtmlTextWriter(strw);

GridView1.AllowPaging = false;

GridView1.DataSource = bindgrid();

GridView1.DataBind();

GridView1.RenderControl(htmw);

Response.Write(strw.ToString());

Response.End();

GridView1.AllowPaging = true;

bindgrid();
}

insus 2009-04-30

打赏
举报

参考:
http://www.cnblogs.com/insus/articles/1400266.html

llsen 2009-04-30

打赏
举报

最近怎么这么多导excel的

导出参考

llsen 2009-04-30

打赏
举报

可以把grid换位dataset,直接从dataset中导出

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridviewExportExcel.aspx.cs" Inherits="GridviewExcel" EnableEventValidation="false"  %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Gridview Excel</title>

    <link href="~/CSS/Gridview.css" type="text/css" rel="Stylesheet" />

</head>

<body>

    <form id="form1" runat="server">

    <div id="container">

        <asp:GridView ID="GridView1" BorderColor="Black" OnRowDataBound="GridView1_RowDataBound"   runat="server" AutoGenerateColumns="False"  Font-Size="12px" Width="530px" AllowSorting="True">

          <Columns>

            <asp:BoundField DataField="EmpID" HeaderText="编号"  />

            <asp:BoundField DataField="EmpRealName" HeaderText="姓名"  />

            <asp:BoundField DataField="EmpSex" HeaderText="性别"  />

            <asp:BoundField DataField="EmpAddress" HeaderText="住址"  />

          </Columns>

          <HeaderStyle BackColor="Azure" Font-Size="12px" HorizontalAlign="Center" />

            <RowStyle HorizontalAlign="Center" />

            <PagerStyle HorizontalAlign="Center" />

        </asp:GridView>

        <asp:Button ID="Button1" runat="server" Text="导 出 EXCEL 表 格" Height="34px" OnClick="Button1_Click" Width="263px" />

        <asp:Button ID="Button2" runat="server" Text="导 出 Word 文 档" Height="34px" OnClick="Button2_Click" Width="263px" /></div>

    </form>

</body>

</html>

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Drawing;

using System.IO;

using System.Text;

/// <summary>

/// Author:匆匆  Blog:http://www.cnblogs.com/huangjianhuakarl/

/// 将Gridview中的数据导出Excel表格

/// </summary>

public partial class GridviewExcel : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            bind();

        }

    }

    /// <summary>

    /// 数据绑定

    /// </summary>

    public void bind()

    {

        string sqlStr = "select * from Employee";

        DataSet myds = Common.dataSet(sqlStr);

        GridView1.DataSource = myds;

        GridView1.DataKeyNames = new string[] { "ID" };

        GridView1.DataBind();

    }

    /// <summary>

    /// 在 GridView 控件中的某个行被绑定到一个数据记录时发生。此事件通常用于在某个行被绑定到数据时修改该行的内容。

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        foreach (TableCell tc in e.Row.Cells)

        {

            tc.Attributes["style"] = "border-color:Black";

        }

        if (e.Row.RowIndex != -1)

        {

            int id = GridView1.PageIndex * GridView1.PageSize + e.Row.RowIndex + 1;

            e.Row.Cells[0].Text = id.ToString();

        }

    }

    /// <summary>

    /// 导出Excel

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void Button1_Click(object sender, EventArgs e)

    {

        Export("application/ms-excel", "Employee information.xls");

    }

    /// <summary>

    /// 定义导出Excel的函数

    /// </summary>

    /// <param name="FileType"></param>

    /// <param name="FileName"></param>

    private void Export(string FileType, string FileName)

    {

        Response.Charset = "GB2312";

        Response.ContentEncoding = System.Text.Encoding.UTF8;

        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

        Response.ContentType = FileType;

        this.EnableViewState = false;

        StringWriter tw = new StringWriter();

        HtmlTextWriter hw = new HtmlTextWriter(tw);

        GridView1.RenderControl(hw);

        Response.Write(tw.ToString());

        Response.End();

    }

    /// <summary>

    /// 此方法必重写，否则会出错

    /// </summary>

    /// <param name="control"></param>

    public override void VerifyRenderingInServerForm(Control control)

    {

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

        //Export("application/ms-excel", "Employee.doc");

        Export("application/ms-word", "员工信息.doc");//都可以

    }

}