ByteScout Barcode Suite – VB.NET – Read formula from cell with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – VB.NET – Read formula from cell with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-VB-NET-Read-formula-from-cell-with-spreadsheet-sdk.pdf

How to read formula from cell with spreadsheet sdk in VB.NET with ByteScout Barcode Suite

Continuous learning is a crucial part of computer science and this tutorial shows how to read formula from cell with spreadsheet sdk in VB.NET

Read formula from cell with spreadsheet sdk is simple to apply in VB.NET if you use these source codes below. ByteScout Barcode Suite can read formula from cell with spreadsheet sdk. It can be applied from VB.NET. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK.

This prolific sample source code in VB.NET for ByteScout Barcode Suite contains various functions and other necessary options you should do calling the API to read formula from cell with spreadsheet sdk. Just copy and paste the code into your VB.NET application’s code and follow the instructions. Enjoy writing a code with ready-to-use sample VB.NET codes.

You can download free trial version of ByteScout Barcode Suite from our website to see and try many others source code samples for VB.NET.

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