数据导出excel 无反应

illoveyou 2012-08-10 03:52:30

在导出时，点击导出按钮刷新一下，不导出，无反应，咋回事，请教各位大侠，源码如下：

//建立Excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
excel.Visible = isShowExcle;
Microsoft.Office.Interop.Excel.Range range;

//生成字段名称
for (int c = 0; c < columnNumber; c++)
{
if (c != 11 && c != 12)
{
colIndex++;
excel.Cells[1, colIndex] = gvData.Columns[c].HeaderText;
}
}

object[,] objData = new object[rowNumber, 13];

for (int r = 0; r < rowNumber; r++)
{
//for (int c = 0; c < columnNumber; c++)
//{
objData[r, 0] = (gvData.Rows[r].FindControl("Label_xh") as Label).Text;
objData[r, 1] = (gvData.Rows[r].FindControl("Label1") as Label).Text;
objData[r, 2] = (gvData.Rows[r].FindControl("Label2") as Label).Text;
objData[r, 3] = (gvData.Rows[r].FindControl("Label3") as Label).Text;
objData[r, 4] = (gvData.Rows[r].FindControl("Label4") as Label).Text;
objData[r, 5] = (gvData.Rows[r].FindControl("Label5") as Label).Text;
objData[r, 6] = (gvData.Rows[r].FindControl("Label6") as Label).Text;
objData[r, 7] = (gvData.Rows[r].FindControl("Label7") as Label).Text;
objData[r, 8] = (gvData.Rows[r].FindControl("Label8") as Label).Text;
objData[r, 9] = gvData.Rows[r].Cells[9].Text;
objData[r, 10] = (gvData.Rows[r].FindControl("Label9") as Label).Text;
objData[r, 11] = "";
objData[r, 12] = "";
//}
}

// 写入Excel
range = worksheet.get_Range(excel.Cells[2, 1], excel.Cells[rowNumber + 1, 13]);
//range.NumberFormat = "@";//设置单元格为文本格式
range.Value2 = objData;
return true;

...全文

1156 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

net5354 2012-08-13

打赏
举报

首先导出到服务器上的EXCEL模板上，再链接该模板文件，就可以下载了

jdc71264 2012-08-13

打赏
举报

其实NPOI用起来会更舒服一点。。。有时间了研究下吧

jdc71264 2012-08-13

打赏
举报

从别处给你摘了点例子，看样子你也是gridview导出



private void Export(string FileType, string FileName)

    {

        Response.Clear();

        Response.Charset = "Big5";

        string s = HttpUtility.UrlEncode(System.Text.UTF8Encoding.UTF8.GetBytes(FileName));

        Response.AppendHeader("Content-Disposition", "attachment;filename="+s);    

        Response.AddHeader("Content-type", "application/x-msdownload");

        Response.ContentType = "application/octet-stream";

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

        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringwrite);

        GridView1.AllowPaging = false;

        this.DataBinds();

        GridView1.RenderControl(htmlWrite);

        Response.Write(stringwrite.ToString());

        Response.End();

        GridView1.AllowPaging = true;

        this.DataBinds();



    }