Ethan H. Eastwood
Ethan H. Eastwood

Software Developer

Game Designer

Destroyer of Tacos

Ethan H. Eastwood
Ethan H. Eastwood

Software Developer

Game Designer

Destroyer of Tacos

Download CV

Excel Reader

  • Runtime & Framework: .NET 8
  • Database: SQL Server
  • ORM: Entity Framework
  • Excel Library: EPPlus

View the project’s public Github repo here.

A Small Application that connects to a local SQL Server Database and adds infomation extracted from an Excel document as entries in the database.

Features

  • Fetches business information saved in an Excel document (Existing Id Number, First and Last Name, Email, Phone, and Department Name) using EPPlus to extract data.
  • Deletes and Re-creates the Database and it’s tables every time the application runs to ensure no outdated records from previous Excel documents.
  • Status messages to inform the user of what the application is currently doing in the background. Entries added to database are displayed when database and excel operations are complete!