execl template:How to iterate excel sheet cell & columns

Ok,Let clarify my problem.
I want two or more range(combination of rows and columns) on the same sheet of the excel workbook. I want the two range to be filled by data coming from dataset

Writing through XML is one of option available but my requirement is generate Excel in which data are coming from dataset. And i want to separate data by keeping them in differnt "range" of excel worksheet.
Let me know if some sample code can help us in better understanding of problem. Because i have developed a soltution which alredy working fine with one dataset and writing it on excel. but wat my requirement is data from two or more SPs should be dumbped on same excel sheet partioning with header and all. For that i simply want to know that how to iterate the excel cell or any better idea.
Reagrds.

Check out this article.

con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp1_test";
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cmd.ExecuteNonQuery();
con.Close();


*********************************************************
oXL = new Excel.Application();
oXL.Visible = true;
oXL.DisplayAlerts = false;

oWB = oXL.Workbooks.Add(Missing.Value);
Microsoft.Office.Interop.Excel.Style objStyle = oWB.Styles.Add("new", Missing.Value);
//Column names Color
objStyle.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.DeepSkyBlue);

// Get the active sheet
oSheet = (Excel.Worksheet)oWB.ActiveSheet;
oSheet.Name = "Effort";
// Process the DataTable

System.Data.DataTable dt = ds.Tables[0];
int rowCount = 1;
foreach (DataRow dr in dt.Rows)
{
rowCount += 1;
for (int i = 1; i < dt.Columns.Count + 1; i++)
{
// Add the header the first time through
if (rowCount == 2)
{
oSheet.Cells[1, i] = dt.Columns[i - 1].ColumnName;
}
oSheet.Cells[rowCount, i] = dr[i - 1].ToString();
}
}
// Resize the columns
oRange = oSheet.get_Range(oSheet.Cells[1, 1],oSheet.Cells[rowCount, dt.Columns.Count]);
oRange.EntireColumn.AutoFit();
Range oRange2 = oSheet.get_Range(oSheet.Cells[1, 1], oSheet.Cells[1, dt.Columns.Count]);
oRange2.Style = objStyle;
oRange.Font.Bold = true;
//objRange.Value2 = Value1;
//oRange.Value2 = "35";
// Save the sheet and close
oSheet = null;
oRange = null;
oWB.SaveAs("testing1.xls", Excel.XlFileFormat.xlWorkbookNormal,Missing.Value, Missing.Value, Missing.Value, Missing.Value,Excel.XlSaveAsAccessMode.xlExclusive,Missing.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value);
//oWB.Close(Missing.Value, Missing.Value, Missing.Value);
//oWB = null;
//oXL.Quit();
// Clean up
// NOTE: When in release mode, this does the trick
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
}


this my sample code. i hope,it will help us for better understanding of the problem.

"At the same time" would indicate doing this on multiple threads, but I suspect that that simply changing the 2 in the same <cod>for loop would suffice.

If you have the option to use the new office XML files (which would create an Office 2007 or better file), I would use that. That way it wouldn't require Excel to be deployed on the same machine, and you can use the Xml objects in System.Xml to create/edit the file.