private void button1_Click(object sender, EventArgs e)
{
// Import DataTable according to the selected cell
Worksheet activeWorksheet = workbook.Worksheets.ActiveWorksheet;
CellRange selection = activeWorksheet.SelectedCell;
spreadsheetControl1.BeginUpdate();
activeWorksheet.Import(ManualDataSet.CreateData().Tables[0], true, selection.TopRowIndex, selection.LeftColumnIndex);
spreadsheetControl1.EndUpdate();
}
public static ManualDataSet CreateData()
{
ManualDataSet ds = new ManualDataSet();
DataTable table = ds.Tables["table"];
table.Rows.Add(new object[] { 0, DateTime.Today, "A", 103 });
table.Rows.Add(new object[] { 1, DateTime.Today, "B", 200 });
table.Rows.Add(new object[] { 2, DateTime.Today, "C", 446 });
return(ds);
}