ByteScout Barcode Suite – C# – Set cell formula with spreadsheet sdk

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

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

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

This code in C# shows how to set cell formula with spreadsheet sdk with this how to tutorial

The documentation is designed for a specific purpose to help you to apply the features on your side. Want to set cell formula with spreadsheet sdk in your C# app? ByteScout Barcode Suite is designed for it. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK).

The SDK samples given below describe how to quickly make your application do set cell formula 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. Enjoy writing a code with ready-to-use sample codes in C#.

All these programming tutorials along with source code samples and ByteScout free trial version are available for download from our website.

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;
using System.Diagnostics;
using System.IO;

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

            // add new worksheet
            Worksheet Sheet = document.Workbook.Worksheets.Add("FormulaDemo");           

            // headers to indicate purpose of the column
            Sheet.Cell("A1").Value = "Formula (as text)";
            // set A column width
            Sheet.Columns[0].Width = 250;

            Sheet.Cell("B1").Value = "Formula (calculated)";
            // set B column width
            Sheet.Columns[1].Width = 250;


            // write formula as text 
            Sheet.Cell("A2").Value = "7*3+2";
            // write formula as formula
            Sheet.Cell("B2").Value = "=7*3+2";

            // delete output file if exists already
            if (File.Exists("Output.xls")){
                File.Delete("Output.xls");
            }

            // Save document
            document.SaveAs("Output.xls");

            // Close Spreadsheet
            document.Close();

            // open generated XLS document in default program
            Process.Start("Output.xls");

        }

    }
}