excel document

[niki_nilu]

how to create an excel document on the button click in asp.net2.0 Gayatri

[ShruthiLavan]

In visual studio 2005, Add the reference - Microsoft office 10.0 object Library to your project. Add the following code in button click event Dim excel As New Excel.Application Dim wbook As Excel.Workbook Dim wSheet As Excel.Worksheet wbook = excel.Workbooks.Add() wSheet = wbook.ActiveSheet() Dim strFileName As String = "The location to save the excel file" wbook.SaveAs(strFileName) excel.Workbooks.Open(strFileName) excel.Visible = True Try it and check whether its working. with regards, lavanya

[Paddy Boyd]

Or you can output your data to an HTML table in the page and then add headers to get explorer to open that item in Excel.