Click here to Skip to main content
11,927,440 members (43,804 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
hello guys

my problem is basic but critical..

I am generating one excel sheet through c# console application which contain one table and one chart

the chart is created on the basic of table values.

Now issue is raised like that all the value which are stored in the table are storing as text. so the chart is not created on the basis of table.
in excel one tooltip get displayed on cell 'the cell is formatted as text'

i check :
datatype of cell : number
the values from console app : convert.toint32()

if any1 have solution then reply...
thank u in advance

let me know if u want 2 know more ...
Posted 14-Jun-12 0:59am
Sandeep Mewara 14-Jun-12 11:37am
Comment from Pratyush Tripathi:
hello dear

send the generating excel sheet,print preview of page and explain the problem
digimanus 21-Jun-12 8:42am
tried EPPLUS? Can do the same for you without having the text/integer problems
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

sorry guys to bother u
a Simple solution is here

if u want integer value in excel sheet cell then just pass convert.toint32(value)

Rate this: bad
Please Sign up or sign in to vote.

Solution 3


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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web03 | 2.8.151126.1 | Last Updated 25 Jun 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100