从gridview转换Excel工作表时，数字列显示#######，为什么? [英] When converting a excel sheet from gridview a numeric column shows #######,why?

问题描述

我必须将excelSheet列存储为与My gridview中的列相同(以数字表示，例如0010023900，而不是#########)我必须一次以数字形式完全查看该列，任何编码为此吗?

请帮助我先生.....！

I have to store a excelSheet column as same as in My gridview(in numeric like 0010023900,not like #########)I have to view it fully in Numeric that column at a time,any coding for that?

pls help me sir.....!

推荐答案

这可能是由于excel的列大小太小，增加了列大小，希望它会显示实际值.

It may be due to small size of column of excel, increase the size of column,Hope it will shows actual values.

只需扩展列的大小.那应该可以解决这个问题.
您也可以通过代码执行此操作-使用ASP.NET操纵Excel [ ^ ]可能会给您一些想法.

Just expand the size of the column. That should fix the issue.
You can do this via code as well - Manipulate Excel with ASP.NET[^] may give you some idea.

我已经解释了为什么会发生这种情况以及如何解决(请参见此处 [ ^ ]).请停止重复同样的问题，然后尝试提出建议.

I have already explained why this happens and how to fix it (see here[^] and here[^]). Please stop repeating this same question and go and try what was suggested.

这篇关于从gridview转换Excel工作表时，数字列显示#######，为什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！