How to display list of tabs in an Excel spreadsheet using C#?

I have a client who sends me spreadsheets full of customer data. Up until now it was always one spreadsheet per customer. Now they are putting each of their customer's data on a separate tab inside one spreadsheet. How do I now update my C# code to give them a selection box for each tab and then read the data in the tab chosen?

C#Microsoft ExcelMicrosoft Office

Last Comment

rwheeler23

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Miguel Oz

2/9/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

rwheeler23

2/9/2018

ASKER

Thanks. They have a mixture of Excel 2010 and 2013. I will tell them to always use the same one. I suppose a logical follow-up question would be is a way to determine which version they are using?

Miguel Oz

2/9/2018

No the interop works OK with older versions as well, just add the 2013 assembly to your project and you should be fine

rwheeler23

2/10/2018

ASKER

'Thanks

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!