Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Can Dixif reads multiple worksheets of excel workfbook?

Posted on by

Can Dixif reads multiple worksheets of excel workfbook?

Scenario 

I have a excel workbook 1 which has worksheets a,b & c how do i setup processing group/dixif so that it reads data from all worksheets & insert/update data in my target table.

My setup works fine for worksheet a but cannot see data of worksheet b & c. 

Thanks

Mav

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    Hi Mav,

    It is not possible for DIXF to read data from multiple sheets for one single entity. In that case, you have to combine the information on one sheet in one table.

    You can have multiple sheets for multiple entities.

  • Mav Profile Picture
    Mav on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    I do not have multiple entities.  The data has to go in same entity but data is spread across multiple sheets.

    So looking for a solution which would allow to import data from multiple sheets into 1 entity .

    Thanks

    Mav

  • Anrini Profile Picture
    Anrini on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    Hello, I hope the following blog will be useful -

    docs.microsoft.com/.../excel-template-multiple

    Data management in the application supports Microsoft Excel-based templates for data entities. These templates can contain one or more worksheets.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    Mav,

    I haven't tried this before. Will give it a try and let you know.

  • Mav Profile Picture
    Mav on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    I am using  Ax2012 R3 Feb update.

    Are you sure sheet lookup would work ? Have you used it to consume multiple sheets of workfbook?

    When i use sheet lookup in processing group form, it wont allow me to create another row for same entity , so really not sure how to use this feature?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    Hi Mav,

    You should be able to change the sheet lookup and use worksheets b & c as well. Is this not working for you?

  • MuthukumaranAX Profile Picture
    MuthukumaranAX 2,897 on at
    RE: Can Dixif reads multiple worksheets of excel workfbook?

    Hi - what version are you using?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans