Announcements
No record found.
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
Hi - what version are you using?
Hi Mav,
You should be able to change the sheet lookup and use worksheets b & c as well. Is this not working for you?
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?
Mav,
I haven't tried this before. Will give it a try and let you know.
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.
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 .
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.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 455 Super User 2026 Season 1
Syed Haris Shah 308 Super User 2026 Season 1
