NineDigit.SpreadSheetLightExtensions 1.0.1

NineDigit Spread Sheet Light Extensions

Extensions for the spreadsheetlight library.

Fluent cell referencing

Type safe cell referencing (column name and row index)

var cell = CellReference.TopLeft // "A1"
    .AddLines(4) // "A5"
    .NextColumn() // "B5"
    .StartOfNextLine() // "A6"
    .NextColumn() // "B6"
    .StartOfLine() // "A6"
    .NextLine() // "A7"
    .NextColumn() // "B7"
    .StartOfColumn(); // "A7"

Table helper

// top-left cell of the thable
var topLeftCell = CellReference.TopLeft;

var tableColumnHeaders = new string[]
{
    "Foo",
    "Bar",
    "Baz",
};

// create the table factory
var table = doc.CreateTableFactory(topLeftCell, tableColumnHeaders);

// first cell of the first row - table.CurrentCell
doc.SetCellValue(table.CurrentCell, "foo1");
// other cells in same row - table.GetNextCell()
doc.SetNumericCellValue(table.GetNextCell(), 1.234M);
doc.SetNumericCellValue(table.GetNextCell(), 99.99M, "0.00%");

// move to next row
doc.SetCellValue(table.GetNextRow(), "foo2");
doc.SetNumericCellValue(table.GetNextCell(), 1.234M);
doc.SetNumericCellValue(table.GetNextCell(), 99.99M, "0.00%");

// right-bottom cell of the table
var rightBottomCell = table.CurrentCell;

var docTable = doc.CreateTable(topLeftCell, rightBottomCell);

docTable.HasTotalRow = true;
docTable.SetTotalRowLabel(1, "Total");
docTable.SetTotalRowFunction(2, SLTotalsRowFunctionValues.Sum);

doc.InsertTable(docTable);