Excel calculation engine in VB.NET and C# - ByteScout
announcement
Our ByteScout SDK products are sunsetting as we focus on expanding new solutions.
Learn More show modal
X
Important Update
ByteScout SDK Sunsetting Notice
Our ByteScout SDK products are sunsetting as we focus on our new & improved solutions. Thank you for being part of our journey, and we look forward to supporting you in this next chapter!
show modal
Introducing PDF.Co
Try PDF.co for document processing & automation via Web APIs
Learn More show modal
show modal
Introducing MuPDF
Try MuPDF.NET for advanced document processing solutions in your .NET environment
Learn More show modal

Excel calculation engine in VB.NET and C#

Spreadsheet SDK provides Excel calculation engine for your desktop and web applications without Excel installed! Use Visual Basic .NET or C# source code below for Excel calculations.

VB.NET code
C# code


VB.NET

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports System.IO
Imports System.Diagnostics

Imports Bytescout.Spreadsheet

Module Module1
Sub Main()
‘ Create new spreadsheet
Dim spreadsheet As New Spreadsheet()

‘ Add new worksheet
Dim sheet As Worksheet = spreadsheet.Workbook.Worksheets.Add()

‘ Get decimal separator. Decimal separator depends from locale.
Dim dsep As String = spreadsheet.Workbook.Locale.NumberFormat.CurrencyDecimalSeparator

‘ Get list separator. List separator depends from locale.
Dim lsep As String = spreadsheet.Workbook.Locale.TextInfo.ListSeparator

‘ Set starting row
Dim rowNumber As Integer = 1

‘ Example on SIN() function in formula
sheet.Cell(rowNumber, 0).Value = “SIN(30)”
sheet.Cell(rowNumber, 1).Value = “=SIN(30)”

rowNumber += 2

‘ Example on COS() function in formula
sheet.Cell(rowNumber, 0).Value = “COS(30)”
sheet.Cell(rowNumber, 1).Value = “=COS(30)”

rowNumber += 2

‘ Example on TAN() function in formula
sheet.Cell(rowNumber, 0).Value = “TAN(30)”
sheet.Cell(rowNumber, 1).Value = “=TAN(30)”

rowNumber += 2

‘ Example on ATAN() function in formula
sheet.Cell(rowNumber, 0).Value = “ATAN(0” + dsep + “5)”
sheet.Cell(rowNumber, 1).Value = “=ATAN(0” + dsep + “5)”

rowNumber += 2

‘ Example on ATAN2() function in formula
sheet.Cell(rowNumber, 0).Value = “ATAN2(0” + dsep + “3” + lsep + “0.1)”
sheet.Cell(rowNumber, 1).Value = “=ATAN2(0” + dsep + “3” + lsep + “0.1)”

rowNumber += 2

‘ Example on ASIN() function in formula
sheet.Cell(rowNumber, 0).Value = “ASIN(0” + dsep + “5)”
sheet.Cell(rowNumber, 1).Value = “=ASIN(0” + dsep + “5)”

rowNumber += 2

‘ Example on ACOS() function in formula
sheet.Cell(rowNumber, 0).Value = “ACOS(0” + dsep + “5)”
sheet.Cell(rowNumber, 1).Value = “=ACOS(0” + dsep + “5)”

rowNumber += 2

‘ Example on EXP() function in formula
sheet.Cell(rowNumber, 0).Value = “EXP(5)”
sheet.Cell(rowNumber, 1).Value = “=EXP(5)”

rowNumber += 2

‘ Example on SQRT() function in formula
sheet.Cell(rowNumber, 0).Value = “SQRT(5)”
sheet.Cell(rowNumber, 1).Value = “=SQRT(5)”

rowNumber += 2

‘ Example on LN() function in formula
sheet.Cell(rowNumber, 0).Value = “LN(5)”
sheet.Cell(rowNumber, 1).Value = “=LN(5)”

rowNumber += 2

‘ Example on LOG10() function in formula
sheet.Cell(rowNumber, 0).Value = “LOG10(5)”
sheet.Cell(rowNumber, 1).Value = “=LOG10(5)”

rowNumber += 2

‘ Example on SUM() function in formula
sheet.Cell(rowNumber, 0).Value = “SUM(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=SUM(5” + lsep + “3)”

rowNumber += 2

‘ Example on PRODUCT() function in formula
sheet.Cell(rowNumber, 0).Value = “PRODUCT(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=PRODUCT(5” + lsep + “3)”

rowNumber += 2

‘ Example on VAR() function in formula
sheet.Cell(rowNumber, 0).Value = “VAR(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=VAR(5” + lsep + “3)”

rowNumber += 2

‘ Example on VARP() function in formula
sheet.Cell(rowNumber, 0).Value = “VARP(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=VARP(5” + lsep + “3)”

rowNumber += 2

‘ Example on STDEV() function in formula
sheet.Cell(rowNumber, 0).Value = “STDEV(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=STDEV(5” + lsep + “3)”

rowNumber += 2

‘ Example on STDEVP() function in formula
sheet.Cell(rowNumber, 0).Value = “STDEVP(5” + lsep + “3)”
sheet.Cell(rowNumber, 1).Value = “=STDEVP(5” + lsep + “3)”

rowNumber += 2

‘ Example on AVERAGE() function in formula
sheet.Cell(rowNumber, 0).Value = “AVERAGE(50” + lsep + “30)”
sheet.Cell(rowNumber, 1).Value = “=AVERAGE(50” + lsep + “30)”

rowNumber += 2

‘ Example on MIN() function in formula
sheet.Cell(rowNumber, 0).Value = “MIN(50” + lsep + “30)”
sheet.Cell(rowNumber, 1).Value = “=MIN(50” + lsep + “30)”

rowNumber += 2

‘ Example on MAX() function in formula
sheet.Cell(rowNumber, 0).Value = “MAX(50” + lsep + “30)”
sheet.Cell(rowNumber, 1).Value = “=MAX(50” + lsep + “30)”

rowNumber += 2

‘ Example on PI() function in formula
sheet.Cell(rowNumber, 0).Value = “PI()”
sheet.Cell(rowNumber, 1).Value = “=PI()”

rowNumber += 2

‘ Example on ABS() function in formula
sheet.Cell(rowNumber, 0).Value = “ABS(-5)”
sheet.Cell(rowNumber, 1).Value = “=ABS(-5)”

rowNumber += 2

‘ Example on RAND() function in formula
sheet.Cell(rowNumber, 0).Value = “RAND()”
sheet.Cell(rowNumber, 1).Value = “=RAND()”

rowNumber += 2

‘ Example on MOD() function in formula
sheet.Cell(rowNumber, 0).Value = “MOD(10” + dsep + “8” + lsep + “2)”
sheet.Cell(rowNumber, 1).Value = “=MOD(10” + dsep + “8” + lsep + “2)”

rowNumber += 2

‘ Example on INT() function in formula
sheet.Cell(rowNumber, 0).Value = “INT(10” + dsep + “8)”
sheet.Cell(rowNumber, 1).Value = “=INT(10” + dsep + “8)”

rowNumber += 2

‘ Example on SIGN() function in formula
sheet.Cell(rowNumber, 0).Value = “SIGN(10” + dsep + “8)”
sheet.Cell(rowNumber, 1).Value = “=SIGN(10” + dsep + “8)”

rowNumber += 2

‘ Example on ROUND() function in formula
sheet.Cell(rowNumber, 0).Value = “ROUND(10” + dsep + “862456” + lsep + “4)”
sheet.Cell(rowNumber, 1).Value = “=ROUND(10” + dsep + “862456” + lsep + “4)”

rowNumber += 2

‘ Example on RADIANS() function in formula
sheet.Cell(rowNumber, 0).Value = “RADIANS(180)”
sheet.Cell(rowNumber, 1).Value = “=RADIANS(180)”

rowNumber += 2

‘ Example on DEGREES() function in formula
sheet.Cell(rowNumber, 0).Value = “DEGREES(3” + dsep + “14)”
sheet.Cell(rowNumber, 1).Value = “=DEGREES(3” + dsep + “14)”

rowNumber += 2

‘ Example on LEN() function in formula
sheet.Cell(rowNumber, 0).Value = “LEN(“”Bytescout””)”
sheet.Cell(rowNumber, 1).Value = “=LEN(“”Bytescout””)”

rowNumber += 2

‘ Example on MID() function in formula
sheet.Cell(rowNumber, 0).Value = “MID(“”Bytescout””” + lsep + “5” + lsep + “5)”
sheet.Cell(rowNumber, 1).Value = “=MID(“”Bytescout””” + lsep + “5” + lsep + “5)”

rowNumber += 2

‘ Example on NOW() function in formula
sheet.Cell(rowNumber, 0).Value = “NOW()”
sheet.Cell(rowNumber, 1).Value = “=NOW()”

rowNumber += 2

‘ Example on DATE() function in formula
sheet.Cell(rowNumber, 0).Value = “DATE(2009” + lsep + “1” + lsep + “2)”
sheet.Cell(rowNumber, 1).Value = “=DATE(2009” + lsep + “1” + lsep + “2)”

rowNumber += 2

‘ Example on TIME() function in formula
sheet.Cell(rowNumber, 0).Value = “TIME(1” + lsep + “1” + lsep + “2)”
sheet.Cell(rowNumber, 1).Value = “=TIME(1” + lsep + “1” + lsep + “2)”

rowNumber += 2

‘ Example on SECOND() function in formula
sheet.Cell(rowNumber, 0).Value = “SECOND(“”18:45:02″”)”
sheet.Cell(rowNumber, 1).Value = “=SECOND(“”18:45:02″”)”

rowNumber += 2

‘ Example on MINUTE() function in formula
sheet.Cell(rowNumber, 0).Value = “MINUTE(“”18:45:02″”)”
sheet.Cell(rowNumber, 1).Value = “=MINUTE(“”18:45:02″”)”

rowNumber += 2

‘ Example on HOUR() function in formula
sheet.Cell(rowNumber, 0).Value = “HOUR(“”18:45:02″”)”
sheet.Cell(rowNumber, 1).Value = “=HOUR(“”18:45:02″”)”

rowNumber += 2

‘ Example on WEEK() function in formula
sheet.Cell(rowNumber, 0).Value = “WEEK(NOW())”
sheet.Cell(rowNumber, 1).Value = “=WEEK(NOW())”

rowNumber += 2

‘ Example on YEAR() function in formula
sheet.Cell(rowNumber, 0).Value = “YEAR(NOW())”
sheet.Cell(rowNumber, 1).Value = “=YEAR(NOW())”

rowNumber += 2

‘ Example on MONTH() function in formula
sheet.Cell(rowNumber, 0).Value = “MONTH(NOW())”
sheet.Cell(rowNumber, 1).Value = “=MONTH(NOW())”

rowNumber += 2

‘ Example on DAY() function in formula
sheet.Cell(rowNumber, 0).Value = “DAY(NOW())”
sheet.Cell(rowNumber, 1).Value = “=DAY(NOW())”

rowNumber += 2

‘ Example on WEEKDAY() function in formula
sheet.Cell(rowNumber, 0).Value = “WEEKDAY(NOW())”
sheet.Cell(rowNumber, 1).Value = “=WEEKDAY(NOW())”

rowNumber += 2

‘ Example on FALSE in formula
sheet.Cell(rowNumber, 0).Value = “FALSE”
sheet.Cell(rowNumber, 1).Value = “=FALSE”

rowNumber += 2

‘ Example on TRUE in formula
sheet.Cell(rowNumber, 0).Value = “TRUE”
sheet.Cell(rowNumber, 1).Value = “=TRUE”

rowNumber += 2

‘ Example on AND() function in formula
sheet.Cell(rowNumber, 0).Value = “AND”
sheet.Cell(rowNumber, 1).Value = “=AND(10>1” + lsep + “10<100)" rowNumber += 2 ' Example on OR() function in formula sheet.Cell(rowNumber, 0).Value = "OR(10>1″ + lsep + “10<100)" sheet.Cell(rowNumber, 1).Value = "=OR(10>1″ + lsep + “10<100)" rowNumber += 2 ' Example on NOT() function in formula sheet.Cell(rowNumber, 0).Value = "NOT(1+1=2)" sheet.Cell(rowNumber, 1).Value = "=NOT(1+1=2)" rowNumber += 2 ' Example on ISNA() function in formula sheet.Cell(rowNumber, 0).Value = "ISNA(NA())" sheet.Cell(rowNumber, 1).Value = "=ISNA(NA())" rowNumber += 2 ' Example on NA() function in formula sheet.Cell(rowNumber, 0).Value = "NA()" sheet.Cell(rowNumber, 1).Value = "=NA()" rowNumber += 2 ' Example on ISERROR() function in formula sheet.Cell(rowNumber, 0).Value = "ISERROR(1/0)" sheet.Cell(rowNumber, 1).Value = "=ISERROR(1/0)" rowNumber += 2 ' Example on ROW() function in formula sheet.Cell(rowNumber, 0).Value = "ROW()" sheet.Cell(rowNumber, 1).Value = "=ROW()" rowNumber += 2 ' Example on COLUMN() function in formula sheet.Cell(rowNumber, 0).Value = "COLUMN()" sheet.Cell(rowNumber, 1).Value = "=COLUMN()" rowNumber += 2 ' Example on COUNT() function in formula sheet.Cell(rowNumber, 0).Value = "COUNT(B1:B10)" sheet.Cell(rowNumber, 1).Value = "=COUNT(B1:B10)" rowNumber += 2 ' Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "COUNTA(B1:B10)" sheet.Cell(rowNumber, 1).Value = "=COUNTA(B1:B10)" rowNumber += 2 ' Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "IF(1=1" + lsep + "TRUE" + lsep + "FALSE)" sheet.Cell(rowNumber, 1).Value = "=IF(1=1" + lsep + "TRUE" + lsep + "FALSE)" rowNumber += 2 ' Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)" sheet.Cell(rowNumber, 1).Value = "=NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)" Try System.IO.File.Delete("output.xls") Catch ex As Exception End Try spreadsheet.SaveAs("output.xls") spreadsheet.Close() System.Diagnostics.Process.Start("output.xls") End Sub End Module[/vbnet]



C#

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

using Bytescout.Spreadsheet;

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

// Add new worksheet
Worksheet sheet = spreadsheet.Workbook.Worksheets.Add();

// Get decimal separator. Decimal separator depends from locale.
string dsep = spreadsheet.Workbook.Locale.NumberFormat.CurrencyDecimalSeparator;

// Get list separator. List separator depends from locale.
string lsep = spreadsheet.Workbook.Locale.TextInfo.ListSeparator;

// Set starting row
int rowNumber = 1;

// Example on SIN() function in formula
sheet.Cell(rowNumber, 0).Value = “SIN(30)”;
sheet.Cell(rowNumber, 1).Value = “=SIN(30)”;

rowNumber += 2;

// Example on COS() function in formula
sheet.Cell(rowNumber, 0).Value = “COS(30)”;
sheet.Cell(rowNumber, 1).Value = “=COS(30)”;

rowNumber += 2;

// Example on TAN() function in formula
sheet.Cell(rowNumber, 0).Value = “TAN(30)”;
sheet.Cell(rowNumber, 1).Value = “=TAN(30)”;

rowNumber += 2;

// Example on ATAN() function in formula
sheet.Cell(rowNumber, 0).Value = “ATAN(0” + dsep + “5)”;
sheet.Cell(rowNumber, 1).Value = “=ATAN(0” + dsep + “5)”;

rowNumber += 2;

// Example on ATAN2() function in formula
sheet.Cell(rowNumber, 0).Value = “ATAN2(0” + dsep + “3” + lsep + “0.1)”;
sheet.Cell(rowNumber, 1).Value = “=ATAN2(0” + dsep + “3” + lsep + “0.1)”;

rowNumber += 2;

// Example on ASIN() function in formula
sheet.Cell(rowNumber, 0).Value = “ASIN(0” + dsep + “5)”;
sheet.Cell(rowNumber, 1).Value = “=ASIN(0” + dsep + “5)”;

rowNumber += 2;

// Example on ACOS() function in formula
sheet.Cell(rowNumber, 0).Value = “ACOS(0” + dsep + “5)”;
sheet.Cell(rowNumber, 1).Value = “=ACOS(0” + dsep + “5)”;

rowNumber += 2;

// Example on EXP() function in formula
sheet.Cell(rowNumber, 0).Value = “EXP(5)”;
sheet.Cell(rowNumber, 1).Value = “=EXP(5)”;

rowNumber += 2;

// Example on SQRT() function in formula
sheet.Cell(rowNumber, 0).Value = “SQRT(5)”;
sheet.Cell(rowNumber, 1).Value = “=SQRT(5)”;

rowNumber += 2;

// Example on LN() function in formula
sheet.Cell(rowNumber, 0).Value = “LN(5)”;
sheet.Cell(rowNumber, 1).Value = “=LN(5)”;

rowNumber += 2;

// Example on LOG10() function in formula
sheet.Cell(rowNumber, 0).Value = “LOG10(5)”;
sheet.Cell(rowNumber, 1).Value = “=LOG10(5)”;

rowNumber += 2;

// Example on SUM() function in formula
sheet.Cell(rowNumber, 0).Value = “SUM(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=SUM(5” + lsep + “3)”;

rowNumber += 2;

// Example on PRODUCT() function in formula
sheet.Cell(rowNumber, 0).Value = “PRODUCT(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=PRODUCT(5” + lsep + “3)”;

rowNumber += 2;

// Example on VAR() function in formula
sheet.Cell(rowNumber, 0).Value = “VAR(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=VAR(5” + lsep + “3)”;

rowNumber += 2;

// Example on VARP() function in formula
sheet.Cell(rowNumber, 0).Value = “VARP(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=VARP(5” + lsep + “3)”;

rowNumber += 2;

// Example on STDEV() function in formula
sheet.Cell(rowNumber, 0).Value = “STDEV(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=STDEV(5” + lsep + “3)”;

rowNumber += 2;

// Example on STDEVP() function in formula
sheet.Cell(rowNumber, 0).Value = “STDEVP(5” + lsep + “3)”;
sheet.Cell(rowNumber, 1).Value = “=STDEVP(5” + lsep + “3)”;

rowNumber += 2;

// Example on AVERAGE() function in formula
sheet.Cell(rowNumber, 0).Value = “AVERAGE(50” + lsep + “30)”;
sheet.Cell(rowNumber, 1).Value = “=AVERAGE(50” + lsep + “30)”;

rowNumber += 2;

// Example on MIN() function in formula
sheet.Cell(rowNumber, 0).Value = “MIN(50” + lsep + “30)”;
sheet.Cell(rowNumber, 1).Value = “=MIN(50” + lsep + “30)”;

rowNumber += 2;

// Example on MAX() function in formula
sheet.Cell(rowNumber, 0).Value = “MAX(50” + lsep + “30)”;
sheet.Cell(rowNumber, 1).Value = “=MAX(50” + lsep + “30)”;

rowNumber += 2;

// Example on PI() function in formula
sheet.Cell(rowNumber, 0).Value = “PI()”;
sheet.Cell(rowNumber, 1).Value = “=PI()”;

rowNumber += 2;

// Example on ABS() function in formula
sheet.Cell(rowNumber, 0).Value = “ABS(-5)”;
sheet.Cell(rowNumber, 1).Value = “=ABS(-5)”;

rowNumber += 2;

// Example on RAND() function in formula
sheet.Cell(rowNumber, 0).Value = “RAND()”;
sheet.Cell(rowNumber, 1).Value = “=RAND()”;

rowNumber += 2;

// Example on MOD() function in formula
sheet.Cell(rowNumber, 0).Value = “MOD(10” + dsep + “8” + lsep + “2)”;
sheet.Cell(rowNumber, 1).Value = “=MOD(10” + dsep + “8” + lsep + “2)”;

rowNumber += 2;

// Example on INT() function in formula
sheet.Cell(rowNumber, 0).Value = “INT(10” + dsep + “8)”;
sheet.Cell(rowNumber, 1).Value = “=INT(10” + dsep + “8)”;

rowNumber += 2;

// Example on SIGN() function in formula
sheet.Cell(rowNumber, 0).Value = “SIGN(10” + dsep + “8)”;
sheet.Cell(rowNumber, 1).Value = “=SIGN(10” + dsep + “8)”;

rowNumber += 2;

// Example on ROUND() function in formula
sheet.Cell(rowNumber, 0).Value = “ROUND(10” + dsep + “862456” + lsep + “4)”;
sheet.Cell(rowNumber, 1).Value = “=ROUND(10” + dsep + “862456” + lsep + “4)”;

rowNumber += 2;

// Example on RADIANS() function in formula
sheet.Cell(rowNumber, 0).Value = “RADIANS(180)”;
sheet.Cell(rowNumber, 1).Value = “=RADIANS(180)”;

rowNumber += 2;

// Example on DEGREES() function in formula
sheet.Cell(rowNumber, 0).Value = “DEGREES(3” + dsep + “14)”;
sheet.Cell(rowNumber, 1).Value = “=DEGREES(3” + dsep + “14)”;

rowNumber += 2;

// Example on LEN() function in formula
sheet.Cell(rowNumber, 0).Value = “LEN(“Bytescout”)”;
sheet.Cell(rowNumber, 1).Value = “=LEN(“Bytescout”)”;

rowNumber += 2;

// Example on MID() function in formula
sheet.Cell(rowNumber, 0).Value = “MID(“Bytescout”” + lsep + “5” + lsep + “5)”;
sheet.Cell(rowNumber, 1).Value = “=MID(“Bytescout”” + lsep + “5” + lsep + “5)”;

rowNumber += 2;

// Example on NOW() function in formula
sheet.Cell(rowNumber, 0).Value = “NOW()”;
sheet.Cell(rowNumber, 1).Value = “=NOW()”;

rowNumber += 2;

// Example on DATE() function in formula
sheet.Cell(rowNumber, 0).Value = “DATE(2009” + lsep + “1” + lsep + “2)”;
sheet.Cell(rowNumber, 1).Value = “=DATE(2009” + lsep + “1” + lsep + “2)”;

rowNumber += 2;

// Example on TIME() function in formula
sheet.Cell(rowNumber, 0).Value = “TIME(1” + lsep + “1” + lsep + “2)”;
sheet.Cell(rowNumber, 1).Value = “=TIME(1” + lsep + “1” + lsep + “2)”;

rowNumber += 2;

// Example on SECOND() function in formula
sheet.Cell(rowNumber, 0).Value = “SECOND(“18:45:02″)”;
sheet.Cell(rowNumber, 1).Value = “=SECOND(“18:45:02″)”;

rowNumber += 2;

// Example on MINUTE() function in formula
sheet.Cell(rowNumber, 0).Value = “MINUTE(“18:45:02″)”;
sheet.Cell(rowNumber, 1).Value = “=MINUTE(“18:45:02″)”;

rowNumber += 2;

// Example on HOUR() function in formula
sheet.Cell(rowNumber, 0).Value = “HOUR(“18:45:02″)”;
sheet.Cell(rowNumber, 1).Value = “=HOUR(“18:45:02″)”;

rowNumber += 2;

// Example on WEEK() function in formula
sheet.Cell(rowNumber, 0).Value = “WEEK(NOW())”;
sheet.Cell(rowNumber, 1).Value = “=WEEK(NOW())”;

rowNumber += 2;

// Example on YEAR() function in formula
sheet.Cell(rowNumber, 0).Value = “YEAR(NOW())”;
sheet.Cell(rowNumber, 1).Value = “=YEAR(NOW())”;

rowNumber += 2;

// Example on MONTH() function in formula
sheet.Cell(rowNumber, 0).Value = “MONTH(NOW())”;
sheet.Cell(rowNumber, 1).Value = “=MONTH(NOW())”;

rowNumber += 2;

// Example on DAY() function in formula
sheet.Cell(rowNumber, 0).Value = “DAY(NOW())”;
sheet.Cell(rowNumber, 1).Value = “=DAY(NOW())”;

rowNumber += 2;

// Example on WEEKDAY() function in formula
sheet.Cell(rowNumber, 0).Value = “WEEKDAY(NOW())”;
sheet.Cell(rowNumber, 1).Value = “=WEEKDAY(NOW())”;

rowNumber += 2;

// Example on FALSE in formula
sheet.Cell(rowNumber, 0).Value = “FALSE”;
sheet.Cell(rowNumber, 1).Value = “=FALSE”;

rowNumber += 2;

// Example on TRUE in formula
sheet.Cell(rowNumber, 0).Value = “TRUE”;
sheet.Cell(rowNumber, 1).Value = “=TRUE”;

rowNumber += 2;

// Example on AND() function in formula
sheet.Cell(rowNumber, 0).Value = “AND”;
sheet.Cell(rowNumber, 1).Value = “=AND(10>1” + lsep + “10<100)"; rowNumber += 2; // Example on OR() function in formula sheet.Cell(rowNumber, 0).Value = "OR(10>1″ + lsep + “10<100)"; sheet.Cell(rowNumber, 1).Value = "=OR(10>1″ + lsep + “10<100)"; rowNumber += 2; // Example on NOT() function in formula sheet.Cell(rowNumber, 0).Value = "NOT(1+1=2)"; sheet.Cell(rowNumber, 1).Value = "=NOT(1+1=2)"; rowNumber += 2; // Example on ISNA() function in formula sheet.Cell(rowNumber, 0).Value = "ISNA(NA())"; sheet.Cell(rowNumber, 1).Value = "=ISNA(NA())"; rowNumber += 2; // Example on NA() function in formula sheet.Cell(rowNumber, 0).Value = "NA()"; sheet.Cell(rowNumber, 1).Value = "=NA()"; rowNumber += 2; // Example on ISERROR() function in formula sheet.Cell(rowNumber, 0).Value = "ISERROR(1/0)"; sheet.Cell(rowNumber, 1).Value = "=ISERROR(1/0)"; rowNumber += 2; // Example on ROW() function in formula sheet.Cell(rowNumber, 0).Value = "ROW()"; sheet.Cell(rowNumber, 1).Value = "=ROW()"; rowNumber += 2; // Example on COLUMN() function in formula sheet.Cell(rowNumber, 0).Value = "COLUMN()"; sheet.Cell(rowNumber, 1).Value = "=COLUMN()"; rowNumber += 2; // Example on COUNT() function in formula sheet.Cell(rowNumber, 0).Value = "COUNT(B1:B10)"; sheet.Cell(rowNumber, 1).Value = "=COUNT(B1:B10)"; rowNumber += 2; // Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "COUNTA(B1:B10)"; sheet.Cell(rowNumber, 1).Value = "=COUNTA(B1:B10)"; rowNumber += 2; // Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "IF(1=1" + lsep + "TRUE" + lsep + "FALSE)"; sheet.Cell(rowNumber, 1).Value = "=IF(1=1" + lsep + "TRUE" + lsep + "FALSE)"; rowNumber += 2; // Example on COUNTA() function in formula sheet.Cell(rowNumber, 0).Value = "NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)"; sheet.Cell(rowNumber, 1).Value = "=NPV(10%" + lsep + "10000" + lsep + "1000" + lsep + "2000" + lsep + "300)"; try { System.IO.File.Delete("output.xls"); } catch (Exception ex) { } spreadsheet.SaveAs("output.xls"); spreadsheet.Close(); System.Diagnostics.Process.Start("output.xls"); } } }[/vb]

Tutorials:

prev
next