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