Click here to Skip to main content
Rate this: bad
good
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 at 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 at 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)



Advertise | Privacy | Mobile
Web02 | 2.8.150129.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