How to read plain text values

Oct 2, 2012 at 6:45 PM



   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.



Nov 29, 2012 at 9: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 10: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.