Export data to excel.

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!
 
M

mortb

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top