将网格视图数据导出到Excel文件 [英] exporting grid view data to excel file

问题描述

我正在使用以下代码将gridview数据导出到Excel工作表中

i am exporting gridview data to excel sheet using following code

using (StreamWriter sw = new StreamWriter(Server.MapPath("excel.xls")))
        {
            using (HtmlTextWriter hw = new HtmlTextWriter(sw))
            {
                grid.RenderControl(hw);
            }
        }

但是问题是当条目像0123234

它只在excel工作表中存储123234而不是0
它将如何显示原始数据

but problem is that when an entry is like 0123234

it store only 123234 in excel sheet not 0
how will it show original data

推荐答案

尝试用适当的屏幕截图对此进行解释.

对GridView导出到Excel的广泛研究 [

Try this one which is explained with appropriate screen-shots.

Extensive Study of GridView Export to Excel[^]

这篇关于将网格视图数据导出到Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！