EasyXLS

How to add formulas in cells in VB.NET

'-------------------------------------------------------------------
' Tutorial 11
'
' This tutorial shows how to create an Excel file in VB.NET (1) that
' has a cell that contains SUM formula for a range of cells (2).
' ------------------------------------------------------------------
Click here to see the Excel file

Imports EasyXLS

Module Tutorial11

    Sub Main()

        Console.WriteLine("Tutorial 11" & vbCrLf & "----------" & vbCrLf)

        ' Create an instance of the class that exports Excel files (1)
        Dim workbook As New ExcelDocument

        ' Create a sheet
        workbook.easy_addWorksheet("Formula")

        ' Get the table of data for the sheet, add data in sheet and the formula (2)
        Dim xlsFirstTab As ExcelWorksheet = workbook.easy_getSheet("Formula")
        Dim xlsTable = xlsFirstTab.easy_getExcelTable()
        xlsTable.easy_getCell("A1").setValue("1")
        xlsTable.easy_getCell("A2").setValue("2")
        xlsTable.easy_getCell("A3").setValue("3")
        xlsTable.easy_getCell("A4").setValue("4")
        xlsTable.easy_getCell("A6").setValue("=SUM(A1:A4)")

        ' Export Excel file
        Console.WriteLine("Writing file C:\Samples\Tutorial11.xls.")
        workbook.easy_WriteXLSFile("C:\Samples\Tutorial11.xls")

        ' Confirm export of Excel file
        Dim sError As String = workbook.easy_getError()
        If (sError.Equals("")) Then
            Console.Write(vbCrLf & "File successfully created. Press Enter to Exit...")
        Else
            Console.Write(vbCrLf & "Error encountered: " & sError & vbCrLf & "Press Enter to Exit...")
        End If
        
        ' Dispose memory
        workbook.Dispose()
        
        Console.ReadLine()

    End Sub

End Module

EasyXLS Excel libraries:

.NET
Excel Library for VB.NET
full .NET version to import, export or convert Excel files
Excel Writer for VB.NET
.NET version to create and export Excel files
Download EasyXLS™ Excel Library for VB.NET

File formats:

MS Excel 97
MS Excel 2003
MS Excel 2007
MS Excel 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLS XLSX XLSM XLSB
XML HTML CSV TXT