Error While read cell value from excel file. RSS

• • Reply
  

  hspatil

  Member

  97 Points

  156 Posts

  Error While read cell value from excel file.

  Jul 29, 2011 10:01 AM|LINK

  Dear All,

   

  I am using following code line for reading cell value from excel file, but when if the cell value is blank then its giving error, can anybody tell me how to resolve this issue ?

  string strGetPhysicalCellValue = ((Microsoft.Office.Interop.Excel.Range)oWorkSheet.Cells[Row, intAnsValue]).Value2.ToString();

  Error:

  "'oWorkSheet.Cells' threw an exception of type 'System.Runtime.InteropServices.COMException' string
  "

  For check the null value i tried if condition therefore also it's giving error,

  if(((Microsoft.Office.Interop.Excel.Range)oWorkSheet.Cells[Row, intAnsValue]).Value2.ToString() != null )

   {

      strGetPhysicalCellValue = ((Microsoft.Office.Interop.Excel.Range)oWorkSheet.Cells[Row, intAnsValue]).Value2.ToString();

   }

  Thanks and Regard's

  Harish Patil

  • Moved by mbanavige on Jul 29, 2011 02:21 PM
• • Reply
  

  chandrasheka...

  Star

  10258 Points

  1760 Posts

  Re: Error While read cell value from excel file.

  Jul 29, 2011 10:35 AM|LINK

  Try, Check for the given row and intAnsValue returns the cell or range.

  if(((Microsoft.Office.Interop.Excel.Range)oWorkSheet.Cells[Row, intAnsValue]).Value2 != null )
  
   {
  
  strGetPhysicalCellValue = ((Microsoft.Office.Interop.Excel.Range)oWorkSheet.Cells[Row, intAnsValue]).Value2.ToString();
  
   }

  YCS
  Please try the answer for the post and finally Don't forget to click “Mark as Answer” on the post that helped you.
  
  • Edited by hspatil on Jul 29, 2011 11:42 AM
  • Edited by hspatil on Jul 29, 2011 11:43 AM
  • Marked as answer by hspatil on Jul 29, 2011 11:43 AM
• • Reply
  

  hspatil

  Member

  97 Points

  156 Posts

  Re: Error While read cell value from excel file.

  Jul 29, 2011 11:43 AM|LINK

  Thnks. I solved the issue.