Click here to Skip to main content
12,621,302 members (32,728 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
Comments
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
 
good
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)

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

Solution 3

  Permalink  

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
Web02 | 2.8.161128.1 | Last Updated 25 Jun 2012
Copyright © CodeProject, 1999-2016
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