Microsoft.net

This is my Blog dedicated to my work in the .NET Framework.

Thursday, May 26, 2005

Exporting DataGrid to excel and keeping the format intact

I had to export datagrid to excel which is a pretty simple task. The problem was that excel was formatting the numbers in its own format. Meaning that 09898987 in the datagrid is written as 9898987. There is a way to fix this problem.

Follow the link below (Thanks to Sonu kapoor and juss55) :

http://forums.asp.net/893621/ShowPost.aspx
Posted by azamsharp at 3:44 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2005 (54)
    • ▼  May (13)
      • O/R Mapping with NHibernate
      • Exporting DataGrid to excel and keeping the format...
      • Numbering Column when returned from Database
      • MSDN Event in Houston
      • Migration from independent data access blocks to E...
      • Enterprise Library Caching Application Block
      • Populating multiple dropdownlists using one data a...
      • Displaying Messages to the user
      • Using FxCop in your .NET Applications
      • Using View State or Caching
      • Event Calendar User Control
      • Scroll Bar in the datagrid control
      • Updating multiple records in the database
    • ►  April (25)
    • ►  March (10)
    • ►  February (2)
    • ►  January (4)
  • ►  2004 (29)
    • ►  December (11)
    • ►  November (7)
    • ►  October (5)
    • ►  September (6)

About Me

My photo
azamsharp
:)
View my complete profile
Awesome Inc. theme. Powered by Blogger.