Read Formula From Cell | VB.NETBytescout Spreadsheet SDK

Read Formula From Cell | VB.NET

Module1.vb:

VB
Imports Bytescout.Spreadsheet
Imports System.IO

Module Module1

    Sub Main()
        ' Create new Spreadsheet
        Dim document As New Spreadsheet()
        document.LoadFromFile("sample.xls")

        ' get the very first worksheet
        Dim sheet As Worksheet = document.Worksheet(0)

        Console.WriteLine("reading total price formula from cell B5")
        ' we use .Formula value to read from the B5 cell
        Console.WriteLine("Formula in B5 cell is: " + sheet.Cell("B5").Formula)
        Console.WriteLine("\npress any key to continue")
        Console.ReadKey()
    End Sub

End Module