ByteScout Barcode Suite – C# – Read formula from cell with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Read formula from cell with spreadsheet sdk

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

How to read formula from cell with spreadsheet sdk in C# with ByteScout Barcode Suite

If you want to learn more then this tutorial will show how to read formula from cell with spreadsheet sdk in C#

These source code samples are assembled by their programming language and functions they apply. 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. It can be applied to read formula from cell with spreadsheet sdk using C#.

The SDK samples given below describe how to quickly make your application do read formula from cell with spreadsheet sdk in C# with the help of ByteScout Barcode Suite. IF you want to implement the functionality, just copy and paste this code for C# below into your code editor with your app, compile and run your application. Use of ByteScout Barcode Suite in C# is also described in the documentation included along with the product.

If you want to try other source code samples then the free trial version of ByteScout Barcode Suite is available for download from our website. Just try other source code samples for C#.

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

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

Program.cs

      using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;

namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();
	document.LoadFromFile("sample.xls");

            // get the very first worksheet
            Worksheet sheet = 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();
}
    }
}