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
Unfortunately, the "Export Data Store Entity to Excel" smart service does not support customizing the structure of the Excel output file directly. It primarily exports the data as-is from the data store entity.
However, By modifying the underlying view or table to include all the necessary data, you can ensure that the exported Excel file contains the combined information you need.
thanks for the information. you mean changing it like this?
Yes..
Export Data Store Entity to Excel will allow you to export without the filter criteria.
The screenshot mentioned in your query is the default behavior of the record type export to excel functionality, which include the filter criteria in the top.
CDT to Excel found in the Excel Tools plug-in can do this (it's marked as deprecated but still works just fine AFAIK)
sorry, dont know what plug-in you mentioned here.
sorry, not really sure what you talked here.
Mike Schmitt said:the Excel Tools plug-in
the one I named...
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.)