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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
