C#

<br />
    private void NullAndRelease(object runtimeObject)<br />
    {<br />
      try<br />
      {<br />
        System.Runtime.InteropServices.Marshal.FinalReleaseComObject(runtimeObject);<br />
      }<br />
      catch {}<br />
      finally<br />
      { <br />
        runtimeObject = null; <br />
      }<br />
    }<br />
    private void button1_Click(object sender, EventArgs e)<br />
    {<br />
      Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();<br />
      object NullParam = System.Reflection.Missing.Value;<br />
      Workbook Book = ExcelApp.Workbooks.Open(FileName, 0, true, NullParam, NullParam, NullParam,<br />
        true, NullParam, NullParam, false, false, NullParam, false, true, NullParam);<br />
      Worksheet Sheet = Book.Worksheets[1] as Worksheet;<br />
      Range UsedRange = Sheet.UsedRange;<br />
<br />
      Range Cell = null;<br />
      int RowCount = UsedRange.Rows.Count;<br />
      for (int i = 2; i <= RowCount; i++)<br />
      {<br />
        Cell = UsedRange.Cells[i, 1] as Microsoft.Office.Interop.Excel.Range;<br />
        Cell = UsedRange.Cells[i, 2] as Microsoft.Office.Interop.Excel.Range;<br />
        Cell = UsedRange.Cells[i, 3] as Microsoft.Office.Interop.Excel.Range;<br />
        Cell = UsedRange.Cells[i, 4] as Microsoft.Office.Interop.Excel.Range;<br />
        Cell = UsedRange.Cells[i, 5] as Microsoft.Office.Interop.Excel.Range;<br />
        Cell = UsedRange.Cells[i, 6] as Microsoft.Office.Interop.Excel.Range;<br />
        NullAndRelease(Cell); <br />
      }<br />
      NullAndRelease(Cell);<br />
      NullAndRelease(UsedRange);<br />
      NullAndRelease(Sheet);<br />
      if (Book != null)<br />
        Book.Close(false, NullParam, false);<br />
      NullAndRelease(Book);<br />
      ExcelApp.Quit();<br />
      NullAndRelease(ExcelApp);<br />
      GC.Collect();<br />
      GC.WaitForPendingFinalizers();       <br />
    }<br />

<br />
      Cell = UsedRange.Cells[i, 7] as Microsoft.Office.Interop.Excel.Range;<br />

List<string[]> salesPeriod = new List<string[]>();<br />
string[] totalPeriodNo = new string[3];<br />
<br />
<br />
totalPeriodNo[0] = "AA";<br />
totalPeriodNo[1] = "0.01";<br />
totalPeriodNo[2] = "0.02";<br />
totalPeriodNo[3] = "0.03";<br />
salesPeriod.Add(totalPeriodNo);<br />
<br />
<br />
totalPeriodNo[0] = "BB";<br />
totalPeriodNo[1] = "0.06";<br />
totalPeriodNo[2] = "0.07";<br />
totalPeriodNo[3] = "0.08";<br />
salesPeriod.Add(totalPeriodNo);<br />