C#

// Create new ExcelFile.
var ef = new ExcelFile();

// Imports all the tables from DataSet to new file.
foreach (DataTable dataTable in dataSet.Tables)
{
    // Add new worksheet to the file.
    var ws = ef.Worksheets.Add(dataTable.TableName);

    // Insert the data from DataTable to the worksheet starting at cell "A1".
    ws.InsertDataTable(dataTable, "A1", true);
}

// Save the file to XLS format.
ef.SaveXls("DataSet.xls");

Pete O'Hanlon wrote:

Regasm

sjs4u wrote:

DataSet ds3 = new DataSet();
dt.AcceptChanges(); // dt delcared globally
ds3 = dt.GetChanges();

DataSet ds = new DataSet("DateSet");
ds.Tables.Add(new DataTable());

LoadTable(ds.Tables[0]); //Add your dataadapter work here
ds.AcceptChanges(); //If Not done during loading. Otherwise remove.

ds.Tables[0].Rows.Add(50,20,10); //Replace with your code to edit a row.

DataTable changedTable = ds.Tables[0].GetChanges(); //Here you should get one row.