Unable export the data to excel in the expected format

Question

0.00/5 (No votes)

See more:

I wanted to export data from asp.net page to excel, where i have export the data with particular format eg 00110, But when i export the specific format to excel. By default it will be converted to number eg 110, but I wanted to have the data in original format.

Any suggestions around this will really appreciated!!

Thank in advance

Posted 31-Jul-13 1:54am

murugesan.velusamy

Add a Solution

Comments

kishore sharma 31-Jul-13 7:56am

00110 in int it is equal to 110
but if "00110" in string is "00110" only just check if any type is used

murugesan.velusamy 31-Jul-13 7:59am

Have checked the type, It is char.

kishore sharma 31-Jul-13 8:02am

change to string

murugesan.velusamy 31-Jul-13 8:05am

I am fetching the data from database. where the type is char. i had tried with varchar as well but it is not working

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Joezer BH** · Answer 1 · 2013-07-31T01:59:00

Solution 1

See examples
Format an Excel column (or cell) as Text in C#[^]
and
Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#[^]

Cheers,
Edo

Posted 31-Jul-13 1:59am

Joezer BH

murugesan.velusamy · Answer 2 · 2013-07-31T19:18:00

Solution 2

use ="0100" to get the expected output

Posted 31-Jul-13 19:18pm

murugesan.velusamy