在asp.net中导出到excel? [英] Export to excel in asp.net?

问题描述

Hii ......

导出到excel中的对齐问题?

我列出了我使用的代码，

Hii......

alignment problem in export to excel?

i listing the codes i used,

private void ExportGridView()
    {
        //To make the last row unbold//
        //int j = gvScoreList.Rows[0].Cells.Count;
        int i = gvMark.Rows.Count;
        //foreach (GridViewRow row in gvSalaryStatement.Rows)
        //{
        //gvFeeReport.Rows[i - 1].Cells[j - 2].Text = "Total";
        //}
        if (i > 0)
        {
            btnExportToWord.Visible = true;
            btnExportToExcel.Visible = true;
            string attachment = "attachment; filename=File.xls";
            Response.ClearContent();
            Response.AddHeader("content-disposition", attachment);
            Response.ContentType = "application/ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            //gvScoreList.RenderControl(htw);
            //lblFailed.RenderControl(htw);
            pnlExport.RenderControl(htw);
            Response.Write(sw.ToString());
            Response.End();
        }
        else
        {
            btnExportToWord.Visible = false;
            btnExportToExcel.Visible = false;
        }
    }

推荐答案

正确设置Gridview宽度.设置相同的gridview宽度后，您会在Excel中看到

Set Gridview Width Proper. after setting gridview width same u see in the Excel

这篇关于在asp.net中导出到excel?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！