C#

for (int i = 0; i < UsingGrid.Cols; i++)
{
    for (int j = 0; j < UsingGrid.Rows; j++)
    {
        worksheet.Cells[j + 1, i + 1] = ConvertToExcelFormat(Convert.ToString(UsingGrid[j, i]));
    }
}

Mschauder wrote:

Office Excel 2007 can hold 1.048.576 rows.

Mschauder wrote:

Should have a .xls or .xlsx format and should can autosize cols and edit backcolor from the header

Mschauder wrote:

There must be an another way...

Mschauder wrote:

//Application.DoEvents();

// 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.