Author: yanku | Posted on: 1/13/2010 12:19:18 PM | Views : 360

 
 Hi All,
 
 I am writing data to Excel file using below code:
        Dim xlWorkBook As Excel.Workbook
        Dim xlWorkSheet As Excel.Worksheet
        xlWorkBook = New Excel.Application().Workbooks.Open("C:\Practice.xls")
        xlWorkSheet = xlWorkBook.ActiveSheet
        xlWorkSheet.Cells(1, 1) = "Hello world"
        xlWorkBook.Save()
        xlWorkBook.Close()
 I have included the Interop.Excel.dll and Interop dll as well in the bin folder.
 and have added the Reference of "Microsoft Excel 11.0 object Library".
 This code is working fine on the development machine. But on the server its giving belo ...

Go to the complete details ...