| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 661 |
| Technical Name |
ex_xlsx_report |
| License | LGPL-3 |
| Versions | 15.0 17.0 18.0 |
Redefining the Excel Data Export Experience
Excel Report Template Engine is an advanced Excel export tool designed specifically for Odoo, solving the limitation of Odoo's native Excel export functionality that doesn't allow for custom styling.
With this module, users can customize template data mapping and styling. The system will populate data according to user-selected records, following the predefined template, perfectly preserving the Excel template's styling in the output.
Whether you're creating sales reports, inventory statistics, or financial analyses, you can easily achieve professional-grade data presentation.
Core Features
Our Excel Report Template Engine offers the following powerful features to make your data presentation more professional and efficient
Image Export Support
Supports record-by-record generation, exporting images alongside Excel tables, maintaining data integrity and visual clarity.
Multi-level Grouping Display
Supports grouping of multiple records with up to two levels of grouping for summary data, similar to the powerful functionality of Pivot views, making data analysis more intuitive.
Batch Export Functionality
Supports cross-model One2many image printing, allowing selection of multiple Sales Orders (SO) and exporting separate Excel spreadsheets for each SO, significantly improving workflow efficiency.
Jinja2 Template Editing
Uses powerful Jinja2 syntax for flexible custom template editing, meeting various complex data presentation requirements. Supports sophisticated conditional logic and calculations.
High Compatibility
Functions as a standalone module with no compatibility issues, seamlessly integrating into your existing Odoo system. Simple installation and convenient configuration.
Stable and Reliable
Thoroughly tested and continuously updated to ensure stable operation in various environments. Includes example templates for quick onboarding.
Feature Showcase
See how our module helps you create professional Excel report exports
1 Custom Template Upload
Seamlessly integrate your enterprise-grade Excel templates with intelligent Jinja2 variable recognition. Perfectly supports complex table styles and formatting required by businesses, including merged cells, conditional formatting, and corporate branding. Ensures exported reports maintain 100% of the original design style, enhancing your company's image and professionalism.
2 Batch Export Functionality
Revolutionary batch processing capability enables one-click generation of multiple reports. For multiple Sales Orders (SOs), the system can simultaneously generate separate Excel reports, each containing complete One2many related data and product images. Significantly improves business process efficiency, reducing manual operation time by 80%, allowing your team to focus on creating more value.
3 Grouped Data Display
Enterprise-grade data analysis capabilities support multi-dimensional grouping and summarization, transforming complex data into clear insights. Combines the analytical advantages of Pivot views, automatically calculating subtotals and totals while applying customized corporate formatting styles. Helps management quickly identify business trends, make data-driven decisions, and enhance competitive advantage.
4 Enhanced Native Odoo Export
Comprehensive upgrade of Odoo's native export experience, breaking traditional export limitations. Not only presents complete business data in a single Excel sheet, but also supports seamless export of product images, company logos, and other key visual elements. Provides your customers, suppliers, and internal teams with professional reports that are information-rich and visually appealing, showcasing your company's quality and professionalism.
Application Scenarios
Our Excel Report Template Engine is suitable for various business scenarios, providing comprehensive data presentation solutions
Sales Reports
Generate professional sales orders, quotations, and sales analysis reports with product image export capabilities, making your sales documents more professional. Implement batch processing to improve your sales team's efficiency.
- Sales Order Reports
- Customer Quotations
- Product Catalogs
- Sales Performance Analysis
Inventory Management
Create detailed inventory reports including product images, stock levels, and location information to improve inventory management efficiency. Support multi-dimensional data analysis and visualization.
- Inventory Status Reports
- Warehouse Movement Records
- Product Batch Tracking
- Stock Alert Analysis
Financial Analysis
Generate professional financial reports with multi-level grouping display, making financial data analysis more intuitive and effective. Implement complex financial calculations and summaries.
- Profit & Loss and Balance Sheets
- Cash Flow Analysis
- Cost of Sales Analysis
- Budget Comparison Reports
Frequently Asked Questions
We've compiled some common questions and answers to help you better understand our product
Our module supports Odoo versions 14.0, 15.0, 16.0, and 17.0. Each version has been thoroughly tested to ensure full compatibility with the corresponding Odoo version.
You can use Microsoft Excel or other compatible spreadsheet software to create a template. Use Jinja2 syntax to mark variables in cells where you want to fill in data, and then upload the template to the system. Our module comes with example templates to help you get started quickly.
We provide detailed documentation and example templates to help you quickly master template creation skills.
After installing the module, you can create your first template in "Settings > Technical > Report Templates". We provide detailed documentation and example templates to help you get started quickly.
Yes, we provide 90 days of free technical support, including installation guidance and usage issue resolution. For long-term support, you can choose our technical support service package. Our support team will ensure your issues are resolved quickly.
Contact Us
If you have any questions or need custom development, our professional team is ready to serve you
Why Choose Our Solution?
Compared to Odoo's native export functionality, our module offers more comprehensive features
Customer Testimonials
See what our customers say about our product
Begin Your New Era of Excel Reporting
Compared to Odoo's native export functionality, our Excel Report Template Engine provides a more flexible and professional Excel export solution. No need to write complex code - simply design your Excel template, map the data fields, and generate beautiful, professional Excel reports.
Purchase NowIncludes 90 days of free technical support
Please log in to comment on this module