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