Hi there,
I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file?
regards,
L
Discussion posts and replies are publicly visible
btw, if use CDT to excel, how to create the "Excel-base_template"? what it looks like?
linp0001 said:how to create the "Excel-base_template"?
The benefit with this is you can make it whatever you want. Add some formatting (other than in the cells data will be inserted into, sadly), like column widths, formatted column headers, and add your A1 / A2 / A3 cell contents (the hardcoded values, where the values in B1/B2/B3 will be filled in by your process). Upload this excel to your system then reference it as the "base template", and you're set.
(This is something they left out when creating the "export DSE to Excel" smart service for some reason, and they have never fixed that issue, despite the fact that it makes the node nearly unusable to me since I *always* want to provide a base template.)