how to get excel sheet name in c#

Question

can you tell me how to find a excel sheet name validation?

Jack Breg · Answer

Hello, I have tried to find same solutions that you are searching for. I have tried different websites and software. You can visit zetexcel.com. They develop high performance applications to Create, Edit, Convert or Print Excel spreadsheet file formats without requiring Microsoft Excel.

Leon D · Answer

You can install Free Spire.XLS library from nuget to get the name of an excel sheet. Below code for your reference: Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets[0]; string sheetName = worksheet.Name;

Mageshwaran R · Answer

Hi Nandha, Please try below code, it is given detailed solution of your problem Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook excelBook = xlApp.Workbooks.Open( "D:\Book1.xlsx" ); String[] excelSheets = new String[excelBook.Worksheets.Count]; int i = 0; foreach (Microsoft.Office.Interop.Excel.Worksheet wSheet in excelBook.Worksheets) { excelSheets[i] = wSheet.Name; i++; }

Rajanikant Hawaldar · Answer

https://social.msdn.microsoft.com/Forums/vstudio/en-US/05c92891-b839-45c8-80df-eb35e2d68258/how-to-get-the-sheet-name-from-an-excel-file-in-cnet?forum=csharpgeneral https://stackoverflow.com/questions/17358801/how-to-get-sheetname-of-the-uploaded-excel-file-using-c https://stackoverflow.com/questions/47576634/get-excel-worksheets-name-to-c-sharp

Laxmidhar Sahoo · Answer

Hi there are so many examples .Please look the url https://www.c-sharpcorner.com/article/validation-excel-data-in-c-sharp/