Creating an Excel Spreadsheet programmatically using VB.NET

You can create nicely formatted Excel files using this library: http://officehelper.codeplex.com/documentation Important note: Microsoft Office does not need to be installed!

I have deploy the above code but in the line: range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, Nothing, range1, args1) returns me an error: Exception has been thrown by the target of an invocation. Why is that?

Hi, To create excel without ADO and MS Excel automation in VB.NET you need .NET component. Excel Jetcell .NET component allows to read write excel spreadsheet in VB.NET. To visit Excel Jetcell .NET homepage you will find many VB.NET and C# examples how to create excel files XLSX XLS CSV. For example see VB.NET code to create excel spreadsheet from array: Imports DTG.Spreadsheet ... Dim WBook = New ExcelWorkbook() WBook.Worksheets.Add("ArrayValues") For i As Short = 0 To 10 For j As Short = 0 To 10 WBook.Worksheets(0).Cells[i,j].Value = arr(i,j) j = j + 1 Next j i = i + 1 Next i WBook.WriteXLSX("ExcelSpreadsheet.xlsx")

For source code of excel connection creation function with vb.net,visit: http://bitsbyta.blogspot.com/2011/01/how-to-create-excel-connection-vbnet.html

I getting the Err of ISAM , how solve this Error , please check and do needful ........ Dim Conn As New OleDbConnection Dim Comm As New OleDbCommand Conn.ConnectionString = CreateConnString("C:\Documents and Settings\Administrator\Desktop\utility_template_vilas\New Folder\test.xls") Comm.Connection = Conn Comm.CommandText = _ "select * from [CD$] where IsNull(Jt_Itm_Num)" ' '"select * from [CD$] where Not(IsNull(Jt_Itm_Num))" '''''''''''''''add new for testing ................ Dim oleda As OleDbDataAdapter = New OleDbDataAdapter() oleda.SelectCommand = Comm Dim ds As DataSet = New DataSet() ' Fill the DataSet from the data extracted from the worksheet. oleda.Fill(ds, "Employees") please check and do needful Thanks and regards vilas

If you need to create Excel 2007/2010 files then give this open source a try: http://closedxml.codeplex.com

can access data or record from my bv .net project to word? if yes kindly help me how?

Is it possible to accomplish Excel automation without having the Excel app itself installed?

There is other way to read and write Excel c#, vb.net excel, asp.net excel, just use Spire.XLS, without ole excel automation need. http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

Goooooooood job

it is well understandable and easy to use code. thanks

I want to export Data in Excel in web application.

How to add ASPNET in DCOMCNFG but we don't use the step, instead we use the code to auto add ASPNET value in DCOM. because if we upto the host, we don't change the property of DCOM. Please help me Thanhk so much

How add excel object to windows vbnet form. thank you sample http://www.karpodinis.gr/Image1.jpg Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim EXL As Object EXL = CreateObject("Excel.Application") EXL.Workbooks.Open(Application.StartupPath & "\sample.xls", , , , , , , , True) End Sub