Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
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