Cell value types

The following example shows you how to create cells with different value types: string, integer, double, boolean, date and formula.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();
            sheet.Name = "Values";

            sheet["A1"] = new Cell("Text value");
            sheet["A2"] = new Cell(42);
            sheet["A3"] = new Cell(3.14159);
            sheet["A4"] = new Cell(true);
            sheet["A5"] = new Cell(DateTime.Now);

            Cell formulaCell = new Cell();
            formulaCell.Formula = new Formula("SUM(A2:A3)");
            sheet["A6"] = formulaCell;

            sheet["B1"] = new Cell("String");
            sheet["B2"] = new Cell("Integer");
            sheet["B3"] = new Cell("Double");
            sheet["B4"] = new Cell("Boolean");
            sheet["B5"] = new Cell("DateTime");
            sheet["B6"] = new Cell("Formula");

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet As New Worksheet()
        sheet.Name = "Values"

        sheet("A1") = New Cell("Text value")
        sheet("A2") = New Cell(42)
        sheet("A3") = New Cell(3.14159)
        sheet("A4") = New Cell(True)
        sheet("A5") = New Cell(DateTime.Now)

        Dim formulaCell As New Cell()
        formulaCell.Formula = New Formula("SUM(A2:A3)")
        sheet("A6") = formulaCell

        sheet("B1") = New Cell("String")
        sheet("B2") = New Cell("Integer")
        sheet("B3") = New Cell("Double")
        sheet("B4") = New Cell("Boolean")
        sheet("B5") = New Cell("DateTime")
        sheet("B6") = New Cell("Formula")

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

Spreadsheet .NET > Tutorial > Cell value types

Need help? Ask our developers: