Export to excel issue...........

views:

answers:

Export to excel issue...........

I have a asp.net page in which i am exporting gridview records to the excel files. But in some records only ############# is displayed in the excel file & when i view that record in function bar of the excel i am able to view correct record. So what can be the problem?

Waiting for your reply.Thanks a lot in advance.

Thanks Mehul Thakkar

+2 A:

Make the columns wide enough so that the entire number can be displayed.

0xA3 2010-09-28 10:54:12

I have done that but still it's ######## is there any other way in which i can avoid such ### programatically while doing export to excel

2010-09-28 10:57:04

is it a value or a date?

Grumpy 2010-09-28 11:01:57

Actually it's type is value so when we change it's type to general in excel it's shown properly. But is there any way we can accomplish this programmatically in c# side?

2010-09-29 03:53:47

####### in the cell only means that the cell is too narrow to fit the value (for some data types). If you make it wider the problem will disappear.

Grzenio 2010-09-28 10:55:52

ansaurus

tags:

views:

answers:

Export to excel issue...........

related questions