export custom data into excel file

Question

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

Abhay Dalsaniya · Answer

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.

Mike Schmitt · Answer

CDT to Excel found in the Excel Tools plug-in can do this (it's marked as deprecated but still works just fine AFAIK)

Mike Schmitt · Answer

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.)

export custom data into excel file

Top Replies