Advanced Grouping with GemBox

//Loads a dataset from Excel WorkSheet into a complex Dictionary.
private static Dictionary<Tuple<string, string>, string> LoadDataSetFromExcelWorkSheet(ExcelWorksheet SourceWorkSheet, int RowStart, int ColumnStart, int ColumnEnd, bool HasHeaders)
{
    Dictionary<Tuple<string, string>, string> returnValue = new Dictionary<Tuple<string, string>, string>();
    Dictionary<int, string> headers = new Dictionary<int, string>();

    int rowCnt = RowStart;
    while (SourceWorkSheet.Cells[rowCnt, ColumnStart].Value != null)
    {
        string rowGUID = Guid.NewGuid().ToString();
        if ((rowCnt == RowStart) && (HasHeaders))
        {
            //Load proper header names
            for (int i = ColumnStart; i <= ColumnEnd; i++)
            {
                headers.Add(i, SourceWorkSheet.Cells[rowCnt, i].Value.ToString());
            }
        }
        else
        {
            if ((rowCnt == RowStart) && (!HasHeaders))
            {
                //Load generic header names
                for (int i = ColumnStart; i <= ColumnEnd; i++)
                {
                    headers.Add(i, System.Guid.NewGuid().ToString());
                }
            }
            //Load records
            for (int i = ColumnStart; i <= ColumnEnd; i++)
            {
                string cellValue = "";
                try { cellValue = SourceWorkSheet.Cells[rowCnt, i].Value.ToString(); } catch { cellValue = ""; };
                returnValue.Add(new Tuple<string, string>(rowGUID, headers[i]), cellValue);
            }
        }

        ////Move to next row
        rowCnt++;
    }

    return returnValue;
}

Select all Open in new window