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

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

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

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.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

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

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)

VIDEO

ON-PREMISE VERSION

Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation

WEB API

Sign Up for free Web API key

Explore Web API Documentation

Tutorials:

prev
next