File Management Service

Description

This service offers the ability to automate Excel and CSV functionalities, encompassing:

• Automated formula setup and calculations
  • Pivot setup and refresh
  • Addition of sheets to an Excel document
  • Creation and saving of Excel files.
  • Creation and Save of CSV

Internally, This library utilizes

• AsposeCells and Apache-POI to manipulate Excel content. Users have the flexibility to specify the underlying Excel engine through configuration..
• OpenCsv for manipulation of CSV content.

Testing

First, unit tests, duh.