How to write a formula into a cell in the Excel spreadsheet generated by Bytescout Spreadsheet SDK

This source code sample demonstrates how to write formula into a cell in a new excel spreadsheet made with Bytescout Spreadsheet SDK for .NET

Download example source code: (2 KB)

formula in a cell was automatically calculated and displayed in Excel

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

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”;

// save generated XLS document into new file

// open generated document in Excel (if installed)


Download example source code: (2 KB)