Do you want to export an excel report based on your own structure(requirements)? Do you want to make an export for any model(object) of odoo? Do you want to select your own fields for export output? Do you want to export your own custom template? So here you are! We have made a fantastic tool to export data in excel with your own data format and without any technical skill, You just need to select models and fields and that's it. You can export any type of model(object) and related fields of the model. You can also export some special odoo fields like one2many, many2many, many2one very easily. Cheers!
5) Go to Apps menu and click on ‘Update Modules List’, Press Update Button.
6) In the search bar, search ‘sh_dynamic_export_excel’.
7) Click on ‘Install’ to install it.
Workflow of excel dynamic global export.
Go to "Dynamic Action".
You can see "Action List" in dynamic action.
Press the "Add Action" button in the appropriate model, here you can select the appropriate model and you can write the name for the download file. "Add a line" used for add fields which you want in export, No 1 and No 2 button use you can see in below screenshots.
Here the user can make the structure in one to many field types using that button, here the No 1 button used for that and Select appropriate lines for one to many and field.
Users can make the structure in many to one field types using that button, here the No 2 button used for that and Select appropriate lines for many to one and field.
Go to action and select purchase details for the export XLS file.
Select file format option "XLS" for export data in excel and tick the checkbox to make a separate sheet per each record.
After press on the "Apply" button, you can download your file.
Excel exported file looks like below.
You will get free support and assistance in case of any issues