Excel PIA returning null for a cell with a number in

Question

I have a problem in that using the following code

var num = sheet.Cells[row, col].Value;

or

var num = sheet.Cells[row, col].Value2;

will not return a value if the cell contains only a number. Am I missing something silly here? I also ought to mention that I am doing this with a csv file and office 2010.

Thanks all.

var num is declared as what? number or string? Try FormulaR1C1 to get the value — manuerumx, Oct 22 '12 at 16:09
Please put this as an answer so I can accept it and give you the rep. FormulaR1C1 solved it for me! — ridecar2, Oct 22 '12 at 16:30

score 1 · Accepted Answer · answered Oct 22 '12 at 16:33

1

var num is declared as what? number or string? Try FormulaR1C1 to get the value. Works sometimes. :)

answered Oct 22 '12 at 16:33

manuerumx

1,230
14
28

Excel PIA returning null for a cell with a number in

1 Answers1