ByteScout Spreadsheet SDK – VB.NET – Read Formula From Cell

Home
/
Articles
/
ByteScout Spreadsheet SDK – VB.NET – Read Formula From Cell

printable version:
ByteScout-Spreadsheet-SDK-VB-NET-Read-Formula-From-Cell.pdf

How to read formula from cell in VB.NET and ByteScout Spreadsheet SDK

This tutorial will show how to read formula from cell in VB.NET

On this page you will learn from code samples for programming in VB.NET.Writing of the code to read formula from cell in VB.NET can be done by developers of any level using ByteScout Spreadsheet SDK. Want to read formula from cell in your VB.NET app? ByteScout Spreadsheet SDK is designed for it. ByteScout Spreadsheet SDK is the library (SDK) that is capable of writing, reading, modifying and calculating Excel and CSV spreadsheets. Most popular formulas can be calculated and reculculated with Excel installed. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays.

VB.NET code samples for VB.NET developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. This VB.NET sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Enjoy writing a code with ready-to-use sample VB.NET codes.

Our website provides trial version of ByteScout Spreadsheet SDK for free. It also includes documentation and source code samples.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Module1.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