News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Reading Multiple Works...

Microsoft Dynamics AX (Archived)

Reading Multiple Worksheets From Excel before quitting excel application

(0) Share

Report

Report

Posted on by AX 2012 r3

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

AX 2012 r3 2,420 on at

Like (0)

Report

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.

this might help some one

Regards.

Have a great day.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans