populate a datagridview from objects

[archuleta37]

I'm working on reading data from a spreadsheet and outputing it into a
datagridview in a windows form (.net 2.0). The problem I've found is that I'm
getting 84 rows where only one cell is populated, instead of 7 rows with with
12 cells populated. I think the problem is that I don't understand how to use
an ArrayList properly, or I need to use a more appropriate collection... but
then again it could be something completely different.
The key actions are these lines:

myList.Add(reco rd);
dgvSource.DataS ource = myList;

Could anyone give me some insight as to why my grid is not getting populated
correctly?

private void listWorksheets_ SelectedIndexCh anged(object sender, EventArgs e)
{
ArrayList myList = new ArrayList();
Int32 headerRow = 2;
dgvSource.DataS ource = "";
_sheet =
(Worksheet)_she ets.get_Item(li stWorksheets.Se lectedIndex + 1);
Object[,] saRet;
String valueString;
String myString = "";
for (int i = (headerRow + 1); i <= 10; i++)
{ // loop through 10 rows
Excel.Range range = _sheet.get_Rang e("A" + i.ToString(), "L"
+ i.ToString());

//Retrieve the data from the range.
saRet =
(System.Object[,])range.get_Valu e(System.Reflec tion.Missing.Va lue);
// another way to get the data that works also:
//System.Array myvalues = (System.Array)r ange.Cells.Valu e2;
//valueString = "Array Data\n";

for (int j = 1; j <= 12; j++)
{
//Write the next value into the string.
//valueString = String.Concat(v alueString, saRet[1,
j].ToString() + " | ");
MyItem record = new MyItem();
switch (j)
{
case 6:
record.typeCode = saRet[1, j].ToString();
break;
case 2:
record.acctNum = saRet[1, j].ToString();
break;
case 3:
//string
record.acctName = saRet[1, j].ToString();
break;
case 1:
record.dateOfRe port =
System.Convert. ToDateTime(saRe t[1, j].ToString());
break;
case 7:
record.postDate =
System.Convert. ToDateTime(saRe t[1, j].ToString());
break;
case 4:
record.effDate =
System.Convert. ToDateTime(saRe t[1, j].ToString());
break;
case 8:
record.beginBal ance = Decimal.Parse(s aRet[1,
j].ToString());
break;
case 9:
record.payment = Decimal.Parse(s aRet[1,
j].ToString());
break;
case 10:
record.origComm ission = Decimal.Parse(s aRet[1,
j].ToString());
break;
case 11:
record.calcComm ission = Decimal.Parse(s aRet[1,
j].ToString());
break;
case 12:
record.change = Decimal.Parse(s aRet[1,
j].ToString());
break;
default:
continue;
}
myList.Add(reco rd);
record = null;
}

//Write in a new line.
//valueString = String.Concat(v alueString, "\n");
//MessageBox.Show (valueString);
}
dgvSource.DataS ource = myList;
}