Insert Row in Excel

[Andy]

I have a function that is populating an existing Excel spreadsheet with data, and as I go through the function I need to add a row. Can somebody help me out with code to insert a new row? I basically need to add a row, populate the row with data, and then move on to the next record in the dataset and add another row, etc

Thanks

 

[Nikerz Inc]

Hi Andy,

With your dataset you can add all the information first then export it out
to excel. The second option which I haven't done is inserting a row in the
excel sheet. This is a C# example but I think if you look up
datatable.rows.add you'll be able to find the information your looking for!
Holla back when you have a look at this if it fits your solution.

Datarow row = tableEmp.NewRow();
Row["ID"]=1;
Row["Name"] = "Joe User";
tableEmp.Rows.Add(row);

I have a function that is populating an existing Excel spreadsheet with

data, and as I go through the function I need to add a row. Can somebody
help me out with code to insert a new row? I basically need to add a row,
populate the row with data, and then move on to the next record in the
dataset and add another row, etc.