user460485
user460485

Reputation: 1

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

Upvotes: 0

Views: 113

Answers (2)

Grzenio
Grzenio

Reputation: 36649

####### 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.

Upvotes: 0

Dirk Vollmar
Dirk Vollmar

Reputation: 176169

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

Upvotes: 2

Related Questions