how to get excel sheet name in c#

Nandha Kumar Nagarajan

6y27k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jack Breg6y ago
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.
0
Leon D6y ago
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;
0
Mageshwaran R6y ago
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++;
}
0
Rajanikant Hawaldar6y ago
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
0
Laxmidhar Sahoo6y ago
Hi
there are so many examples .Please look the url
https://www.c-sharpcorner.com/article/validation-excel-data-in-c-sharp/
0