Hidden Gem: Truth about Import template excel file
Views (784)
Arun Vinoth
11,615
Moderator
Like
Share
ReportEver wondered how the Dynamics platform identify the Entity to be mapped & imported. And also from where the optionset (picklist) values are loading in spreadsheet template columns. When I was researching for this Stack Overflow question I found this very interesting Hidden gem.
Basically there is a hidden sheet not a regular hidden but a very hidden sheet where all these information are stored & utilized by the platform.
Basically there is a hidden sheet not a regular hidden but a very hidden sheet where all these information are stored & utilized by the platform.
We have to click “View code” option from the context menu, by right clicking sheet name tab in Excel file.
Then by opening the “Project explorer”, the hidden sheet will be visible in VBA, set the visibility to
1 – xlSheetVisible. Don’t save anything.
This was originally posted here.
*This post is locked for comments