create a excel worksheet in asp.net

Question

hi friends, i want to create an excel worksheet in asp.net using vb.net after editing in the cell the details are stored in mysql database.can anybody help me. thaks and regards, thoufi

Raj Kumar · Answer

This code shows how to create excel sheet in vb.net Public Class Tyburn1 Private missing As Object = Type.Missing Public Sub New() Dim oXL As New Excel.Application() oXL.Visible = False Dim oWB As Excel.Workbook = oXL.Workbooks.Add(missing) Dim oSheet As Excel.Worksheet = TryCast(oWB.ActiveSheet, Excel.Worksheet) oSheet.Name = "The first sheet" oSheet.Cells(1, 1) = "Something" Dim oSheet2 As Excel.Worksheet = TryCast(oWB.Sheets.Add(missing, missing, 1, missing), Excel.Worksheet) oSheet2.Name = "The second sheet" oSheet2.Cells(1, 1) = "Something completely different" Dim fileName As String = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) & "\SoSample.xlsx" oWB.SaveAs(fileName, Excel.XlFileFormat.xlOpenXMLWorkbook, missing, missing, missing, missing, _ Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing) oWB.Close(missing, missing, missing) oXL.UserControl = True oXL.Quit() End Sub End Class Dim oSheet2 As Excel.Worksheet = TryCast(oWB.Sheets.Add(missing, missing, 1, missing), Excel.Worksheet)

create a excel worksheet in asp.net

Answers (1)