Excellibrary documentation

Question

I found many recommendations here to use ExcelLibrary for editing excell files, but I can't find any documentation anywhere.

http://code.google.com/p/excellibrary/

Answer 1

Try this:

var workbook = Workbook.Load("spreadsheet.xls");
var worksheet = workbook.Worksheets[0]; // assuming only 1 worksheet
var cells = worksheet.Cells;
var dataTable = new DataTable("datatable");

// add columns
dataTable.Columns.Add("column1");
dataTable.Columns.Add("column2");
...

// add rows
for (int rowIndex = cells.FirstRowIndex + 1; rowIndex <= cells.LastRowIndex; rowIndex++)
{
    var values = new List<string>();
    foreach(var cell in cells.GetRow(rowIndex))
    {
        values.Add(cell.Value.StringValue);
    }

    dataTable.LoadDataRow(values.ToArray(), true);
}

It's not exactly the prettiest code but it returns a DataTable. I recommend that you just use the values directly if possible ie. instead of converting to a DataTable read the values directly and skip this conversion step.