SqlConnection connex = new SqlConnection(); SqlCommand command = new SqlCommand("spTest", con) { CommandType = System.Data.CommandType.StoredProcedure }; SqlDataAdapter sda = new SqlDataAdapter(); command.Connection = con; sda.SelectCommand = command; command.CommandTimeout = 600; DataSet ds = new DataSet(); sda = new SqlDataAdapter("spTest", con); sda.Fill(ds); //Set Name of DataTables. ds.Tables[0].TableName = "Bencount"; ds.Tables[1].TableName = "Wages"; ds.Tables[3].TableName = "BeneficiariestobeExctracted"; ds.Tables[4].TableName = "benificiarieswithnoAccNo"; ds.Tables[5].TableName = "account number>11 characters/wages<100"; ds.Tables[6].TableName = "beneficiary appear on more than project"; ds.Tables[7].TableName = "Duplications by account number"; ds.Tables[8].TableName = "Check Missing Beneficiaries"; if (ds.Tables.Count > 0) { MemoryStream ms = new MemoryStream(); int i = 1; using (ExcelPackage package = new ExcelPackage(ms)) { foreach (DataTable table in ds.Tables) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(table.TableName); worksheet.Cells["A2"].LoadFromDataTable(table, true); } Response.Clear(); package.SaveAs(Response.OutputStream); Response.AddHeader("content-disposition", "attachchment; filename=Example.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; Response.End(); } } } }
if (worksheet.Name == "sheet1") { worksheet.Name = "Bencount"; }.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)