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
Set Cell Formula | C#
Program.cs:
C#
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"); } } }