I am reading in a spreadsheet and calling the method IWorksheet.GetText( row, col ); When it encounters a cell containing only numeric data it returns a null. If I call IWorksheet.GetNumber( row, col ) instead against that same row and col, it returns the value as a double which makes sense.
However if I call the method GetValueRowCol( row, col ), it returns and C# Object and its type is string, with a value of "11"
I have 2 questions:
Is it possible to get the values inside of a cell always as a string ?
Why does GetValueRowCol( row, col ) return an object with a type of string when it is a number, but GetText( row, col ) returns a null ?