Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

Display to user the TABS in an Excel spreadsheet before importing using VS C#.

I have a VS C# application that reads an Excel spreadsheet and writes data into a table in SQL. The users now want to use this same spreadsheet but separate data into different tabs. Is there a way to prompt the user and display the different tabs in the spreadsheet and allow them to chose which tab has the data they want to import? I will also need to read the data in the corresponding tab.
Avatar of Norie
Norie

Are you opening the workbook the user has selected at any point?

Where/how would you want the sheets listed?
Avatar of rwheeler23

ASKER

No, there is no reason for them to have it open. However, if it will aid this process they could open it.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.