Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Reading Multiple Worksheets From Excel before quitting excel application

Posted on by 2,420

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

  • Verified answer
    AX 2012 r3 Profile Picture
    AX 2012 r3 2,420 on at
    RE: Reading Multiple Worksheets From Excel before quitting excel application

    Hi Everyone,

    I found to count how many sheets are there in one excel.

    Here we go.

    Sheets.png

    this might help some one

    Regards.

    Have a great day.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans