Export data to excel.

Discussion in 'ASP .Net' started by Anil, Apr 2, 2004.

  1. Anil

    Anil Guest

    Hi ,
    I am exporting my data from the web datagrid to excel sheet using the
    rendercontrol method. but the problem is that here I do not have a control
    over the excel sheet, so cannot do any settings. All the leading zeros are
    being truncated. I want that all digits like 0099888 should remain as they
    are, and not become 99888, etc etc.

    If I am exporting data using COM interoperability and OWC , then there is a
    major performance issue.

    How can I use the rendercontrol method so that all leading zeros are
    preserved? Or is there any other alternative?

    Please help me.
    Thanks!
    Anil, Apr 2, 2004
    #1
    1. Advertising

  2. Anil

    Cor Guest

    1. Advertising

  3. Anil

    mortb Guest

    In excel you can put an apostrophe ' in front of a number to keep it
    formatted as text.
    I don't know about redering web controls, but if you can insert on infront
    of the number it might work.

    cheers,
    mortb
    mortb, Apr 2, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Deva

    Export data from grid to Excel

    Deva, Jan 13, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    2,334
  2. Joy
    Replies:
    2
    Views:
    2,648
    Sabre
    Aug 22, 2003
  3. =?Utf-8?B?U3JpZGhhcg==?=

    using Microsoft Excel image for Export to Excel button

    =?Utf-8?B?U3JpZGhhcg==?=, Dec 9, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    3,076
    =?Utf-8?B?U3JpZGhhcg==?=
    Dec 9, 2005
  4. =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?=

    Export to Excel (Default File Type - Excel)

    =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?=, Apr 24, 2006, in forum: ASP .Net
    Replies:
    15
    Views:
    17,461
    syed hassan
    May 21, 2009
  5. Grey
    Replies:
    4
    Views:
    1,936
    Mark Rae [MVP]
    Oct 17, 2007
Loading...

Share This Page