How can i pass numeric vales to the excel sheet from c#

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi,
Here is a problem when i am passing values to the excel spread sheet from the c# application through the SQL, the values which i am passing are not showing as it is in the excel spread sheet i.e, numbers for example 65234451254 is the number, but it's showing in the excel sheet(in a cell) as 6.52E+10. Without making any modifications in the excel sheet how can i get the same value(65234451254).

If we send alphanumeric value to the excel sheet it is showing as it is the value which is passed from the application. But i don't want to pass the vales like that, i just want numeric values as it is.

Please tell me the solution.
Thank you...
in advance..

Posted 23-May-12 8:38am

anilkumar.6714

Updated 23-May-12 8:53am

v2

Add a Solution

1 solution

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)

Clifford Nelson · Answer 1 · 2012-05-23T09:21:00

Solution 1

When you open the Excel Sheet, you should be able to expand the excel column to show the whole number. I you want more control on Excel (Column width), you will need to use the Excel Interopt, or a third party control such as ExcelWriter. I know that if you are using ASP.NET, or doing this on a server, you cannot open an excel spreadsheet in Excel.

Posted 23-May-12 9:21am

Clifford Nelson

Comments

anilkumar.6714 23-May-12 21:23pm

After expanding the excel column also it's showing like that only(6.52E+10),if my value is more than 11 digits i am getting this problem,without making any modifications in excel sheet please tell me the solution from c# application

Clifford Nelson 24-May-12 0:03am

Maybe what you will need to do is use the Excel Interopt to create the Excel spreadsheet instead of using SQL.

pietvredeveld 25-May-12 16:33pm

The SQL approach is not the problem. It is the way Excel displays numeric values.
Don't know how hard the 'without making any modifications in excel sheet' requirement is. When only values may be added, then the best guess is to find a Excel option to change the default display numeric values behaviour.
When no calculations are involved you can parse the values as alphanumeric values.

With the interop assemblies you are able to add some formatting to the numeric cells. But that is modifying the excel sheet. Probably no one will notice it, but still...