WorkArchive Excel API

Personal Project

An ASP.NET Core Web API for generating formatted Excel spreadsheets based on JSON input, using EPPlus and a predefined template.

About the project


WorkArchive is a web API project that generates Excel spreadsheets for work registration. It accepts JSON input containing metadata and work log entries, fills a predefined Excel template, and returns a styled `.xlsx` file. The project leverages EPPlus for Excel manipulation and includes features like dynamic table generation, automatic weekday calculation, and custom styling.

Key features


  • Excel Generation: Creates `.xlsx` files based on a predefined template.
  • Dynamic Table: Automatically generates rows for work log entries.
  • Custom Styling: Applies borders, background colors, and row heights.
  • Automatic Calculations: Includes weekday names and total hours.
  • Embedded Template: Uses an embedded Excel template for consistent formatting.
  • Swagger Integration: Provides API documentation and testing interface.
  • Docker Support: Includes a Dockerfile for containerized deployment.