I am debugging an application developed by another programmer. AxInterop OCW11 excel component is used. The following code is giving an error "Input string was not in a correct format", "object reference was not set to an instance of an object".
strTest = axSpreadsheetASCIIop.ActiveCell.get_Range(
(Convert.ToChar(Col1)).ToString() + longRow1.ToString(), (Convert.ToChar(Col1)).ToString() + longRow1.ToString()).Value2.ToString();
The above piece is within a loop, just before the exception I see that strTest= " ..." something like that and next time it causes exception at the above line.
Any inputs will be helpful.
BTW this is in a C# windows application.