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();