ByteScout Spreadsheet SDK – C# – Read Formula From Cell

Home
/
Articles
/
ByteScout Spreadsheet SDK – C# – Read Formula From Cell

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Read-Formula-From-Cell.pdf

How to read formula from cell in C# with ByteScout Spreadsheet SDK

Write code in C# to read formula from cell with this step-by-step tutorial

Read formula from cell is easy to implement in C# if you use these source codes below. What is ByteScout Spreadsheet SDK? It is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can help you to read formula from cell in your C# application.

You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Spreadsheet SDK for read formula from cell below and use it in your application. Follow the instructions from the scratch to work and copy the C# code. Code testing will allow the function to be tested and work properly with your data.

Free trial version of ByteScout Spreadsheet SDK is available for download from our website. Get it to 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();
}
    }
}