How Populate Excel Worksheets name to dropdown

Bhavleen Singh

7y1.2kVisual Basic .NET

want to fetch Excel worksheet name and bind it to dropdown list, I've tried

try

{

var document = SpreadsheetDocument.Open(file.InputStream, false);

workbookPart = document.WorkbookPart;

var sheets = workbookPart.Workbook.Descendants();

var sheet = sheets.First();

data.SheetName = sheet.Name;

}

by this I get 1st sheet name in var sheet but excel file having multiple sheets and I want to get all

Help!

6 Replies

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

Faisal Pathan7y ago
Accepted answer
public ActionResult Index()

        {

            string path = "E:\\Book1.xlsx";

            var document = SpreadsheetDocument.Open(path, false);

            var workbookPart = document.WorkbookPart;

            var sheets = workbookPart.Workbook.Descendants();

            var sheet = sheets.First();

            var SheetNames = GetList(workbookPart);

            return View();

        }



        public List<string> GetList(WorkbookPart workbookPart)

        {

            int index = 0;

            var list = new List<string>();

            foreach (WorksheetPart worksheetpart in workbookPart.WorksheetParts)

            {

                Worksheet worksheet = worksheetpart.Worksheet;

                string sheetName = workbookPart.Workbook.Descendants().ElementAt(index).Name;

                list.Add(sheetName);

                index++;

            }

            return list;

        }
Please mark as accpeted answer so other can refer this.
+2
Faisal Pathan7y ago
here is the demo which created today. you can use as per your requirements.
+1
Bhavleen Singh7y ago
how to see demo?
0
Faisal Pathan7y ago
I just created demo for you now you can use as per your requirements
+1
Bhavleen Singh7y ago
did i've to convert SheetNames to list to populate it to dropdown and what that View() means?
0
Jignesh Kumar7y ago
Hi Bhavleen,

Please find below link,
https://social.msdn.microsoft.com/Forums/en-US/2f459200-deef-4131-be8a-1b67a41efb97/excel-sheet-names-in-sheet-order?forum=adodotnetdataproviders
0