ASP.NET

ContentType = "application/vnd.xls";

public static DataTable GetDataTableFromExcel(string SourceFilePath)
{
    string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                                        "Data Source=" + SourceFilePath + ";" +
                                                        "Extended Properties=Excel 8.0;";

    using (OleDbConnection cn = new OleDbConnection(ConnectionString))
    {
        cn.Open();

        DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        if (dbSchema == null || dbSchema.Rows.Count < 1)
        {
                throw new Exception("Error: Could not determine the name of the first worksheet.");
        }

        string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();

        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + WorkSheetName + "]", cn);
        DataTable dt = new DataTable(WorkSheetName);

        da.Fill(dt);

        return dt;
    }
}

indSoftware wrote:

how can host that console in the same project

app.Context.Response.StatusCode = 301;
app.Context.Response.Status = "301 Moved Permanently";
app.Context.Response.AddHeader("Location", urlRouteResult.RoutedUrl);

TableRow tr = new TableRow();

TableCell tbcell = new TableCell();
tr.Controls.Add(tbcell);

tblData.Controls.Add(tr);