Hi,

it pretty much depends on the format of your 'spreadsheet'. If it's a CSV file then things are quite easy, you could do something like:

StreamReader streamReader = File.OpenText(_sImportFilePath);

string sFileContents = streamReader.ReadToEnd();

string[] sArrRowDelimeter = new string[] { "\r\n" };

string[] sArrFileRows = sFileContents.Split(sArrRowDelimeter, StringSplitOptions.RemoveEmptyEntries);

int iResultCount = sArrFileRows.Length;

if (iResultCount > 1)
{

    for (int i = 1; i < sArrFileRows.Length; i++)
    {

        string[] sArrRowColumns = sArrFileRows[i].Split(',');

        //do something with the data; you most likely have to clean up the input a bit

    }

}

For anything more complicated (e.g. Excel format 2007/2010) I would probably spend some money on one of the out-of-the-box .Net dlls like the one you have linked above, it's money well spend IMO.

Cheers, Sascha

is working on a reply...