Excel calculation engine in VB.NET and C# - ByteScout

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