---
title: WorkArchive Excel API
showOnCv: false
type: Personal
abstract: An ASP.NET Core Web API for generating formatted Excel spreadsheets based on JSON input, using EPPlus and a predefined template.

images:
  - src: cover
    srcDark: cover-dark
    filetype: .webp

pdfFiles: []

quickLinks:
  - kind: api-docs
    url: https://workarchive.w-tb.nl

keywords: []
supervisors: []
keyFeatures:
  - "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."
tags:
  - Backend
  - Automation
  - ASP.Net Core
  - Docker
---

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.