Interop Excel C#: Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))

on May 25, 2016 02:30 AM

i try to get lat and long values in excel 

there is a function in form1 

Public Function GetLine1() As List(Of PointLatLng)
        Return fparallelLines1
    End Function
    Public Function GetLine2() As List(Of PointLatLng)
        Return fParallelLines2
    End Function


i call these in form 2

now when i use these like this

oExcel = CreateObject("Excel.Application")
        oBook = oExcel.Workbooks.Add
        oSheet = oBook.Worksheets(1)
        parallelLines3 = clsTest.gmap.GetLine1()
        parallelLines4 = clsTest.gmap.GetLine2()
        oSheet.Range("A1").Value = parallelLines3
        oSheet.Range("B1").Value = parallelLines4
        'dgv_Search.Rows("Latitude").Value(, dgv_Search.Rows("Longitude").Value())


this shows error

Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))

in this line

oSheet.Range("A1").Value = parallelLines3

how to solve this

Download FREE API for Word, Excel and PDF in ASP.Net: Download