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;'");

            connectionString.Open();

            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"]; 
            }

}
ANIL SINGH

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 - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.