I have a form from where user want to connect to a DB and fill a spread sheet (excel). This is supported in vb.net. Below syntax gives me error in asp. Below is my code. Thanks.
Dim xlApp As Excel.Application = New Excel.ApplicationClass
Dim xlBook As Excel.Workbook
Dim xlSheet1 As Excel.Worksheet = CType(xlBook.Worksheets(1), Excel.Worksheet)