How to read plain text values

Oct 2, 2012 at 5:45 PM

Hi,

 

   I have a problem, I only want the cell values as text, not as various objects, such as integer / float / datetime, etc.

 

    In EPPlus which I am using for 2007 and above formats, I can read a Cell.Text value, which gives me a string as displayed when opened in excel. This means I get the data how it looks.

 

At them moment I have all kinds of strange conversion going on, i,e, datetimes being converted to decimal values.

 

   Is there a way to modify your library to give me just the "display" text of a cell.

 

Hope someone can help.

 

Dan

Nov 29, 2012 at 8:19 AM

Hi Dan, GetValue() might support your needs. It returns an object (which you might have to check for null).

Nov 29, 2012 at 9:47 AM

I fixed this by taking the latest source code and compiling that. The last release is from 2009, while there have been changes since then.