Filed under C# ASP.NET and SQL SERVER

Excel To Database in C# & asp.net

Convert your excel to database table in c# using asp.net ,use microsoft Excel referencepublic partial class excel : System.Web.UI.Page{    public string filename1 { get; set; }    protected string UploadFolderPath = “~/Uploads/”;     DataSet ds = new DataSet();    //System.Web.HttpContext.Current.Server.MapPath(“Book12.xls”);    public DataSet GetExcel(string fileName)    {         Application oXL;        Workbook oWB;        Worksheet oSheet;        Range oRng;        try        {            //  … Continue reading