Use Groovy to Create an Excel Workbook
You can now use Groovy to create an Excel workbook that is sent to the Inbox/Outbox. You can create sheets, add rows, and save or write the workbook to an output stream or file.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting
Business Benefit: Using Groovy allows you to automate the creation of Excel workbooks.
Tips And Considerations
- To get a quick introduction to Groovy business rules, watch the Learning Groovy in EPM Cloud video.
- To get started quickly using Groovy examples, click the examples link under Example Groovy Scripts in EPM Groovy Rules Java API Reference.
Key Resources
- Learning Groovy in EPM Cloud video
- Creating a Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
- Introduction to Groovy Business Rules
- Groovy Tutorials
- EPM Cloud Groovy Rules Java API Reference
Access Requirements
- Calculation Manager Business Rule Designer