Good Morning,
I am trying to import data through Excel using SysExcelApplication.
I am stuck .The doubt is if i import one worksheet i am importing successfully.
They gave me multiple worksheets in one excel.
I want to know can i able to insert all worksheets data at a time befor quitting excel application.
what i am thinking is.Is it possible to know how many worksheets are there for that particular excel file.So,that i can loop based on worksheets.
Please help me.
Regards.
Have a great day.
*This post is locked for comments
Hi Everyone,
I found to count how many sheets are there in one excel.
Here we go.
this might help some one
Regards.
Have a great day.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156