python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions