Tutorial by Examples

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create a datatable DataTable dataTable = new DataTable(); //add three colums to the datatable dataTable.Columns.Add("ID", typeof(int)); dataTable.Columns.Add("Type"...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //the query or stored procedure name for the database string sqlQuery = "SELECT * FROM myTable"; //create a datatable DataTable dataTable = loadExternalDataSet(sqlQuery); //c...

Fill some cells with text. worksheet.Cells["A1"].Value = "Lorem ipsum"; worksheet.Cells["B2"].Value = "dolor sit amet"; worksheet.Cells["C3"].Value = "consectetur adipiscing"; worksheet.Cells["D4"].Value = "elit sed do ei...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create a WorkSheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //create a new list with books List<Book> books = new List<Book>(); ...