0
Answer

how to read excel file from the data base

suresh babu

suresh babu

19y
1.5k
1

how to read excel from the database.


Dim ExcelObj As New Excel.ApplicationClass
ExcelObj.Visible = True

Dim wb As Excel.Workbook = ExcelObj.Workbooks.Add(XlWBATemplate.xlWBATWorksheet)

ElseIf strVal = "xls" Then
                            wb = ExcelObj.Workbooks.Open(FILENAME)
                           ExcelObj.Workbooks(1).Activate()
                           EntireFile = wb.ReadOnly


IT SHOW THE ERROR " System.Runtime.InteropServices.COMException: Old format or invalid type library."

plz tell me