Export data to excel.

  • Thread starter Thread starter Anil
  • Start date Start date
A

Anil

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!
 
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
 
Back
Top