get the sheet name in excel mvc 5 c# .net

get the sheet name in excel mvc 5 c# .net

We can find the sheet name of excel file in MVC 5 C#.Net. The below code-sample is might help you to get sheet name.

private void GetSheetNameFromExcelFiles(string savedExcelFiles, List<UploadExcel> uploadExl, int CompanyID, int TenantID)
     //Create connectionString using OleDbConnection
    OleDbConnection connectionString = new       OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(savedExcelFiles) + ";Extended Properties='Excel 12.0 xml;HDR=YES;'");


            DataTable Sheets = connectionString.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            foreach (DataRow dataR in Sheets.Rows)
                string sheetStr = dataR[2].ToString().Replace("'", "");
                OleDbDataAdapter dataAdapter = new OleDbDataAdapter("select * from [" + sheetStr + "]", connectionString);

                var ds = new DataSet();
                dataAdapter.Fill(ds, "DataTable");
                DataTable data = ds.Tables["DataTable"]; 


Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions