Database Excel Exporter

📂 Project Description

The Database Excel Exporter Console App is a backend utility that connects to a database, retrieves structured data, exports it into Excel files, and automatically uploads the generated files to a specified SharePoint folder. It streamlines data distribution, reduces manual reporting tasks, and ensures timely access to up-to-date data for stakeholders.

❗ Problem & Solution

Problem: Generating reports manually from databases is time-consuming and prone to errors. Sharing the latest data with stakeholders often requires repeated manual exports and uploads, increasing the chance of outdated information being circulated.

Solution: The Database Excel Exporter automates data extraction, converts it into Excel files, and uploads them to a designated SharePoint folder. This ensures stakeholders always have access to accurate and up-to-date data while reducing manual effort and improving reporting efficiency.

🚀 Features
  • Automated data retrieval and Excel export
  • Automatic upload to specified SharePoint folder
  • Reduces manual reporting tasks
  • Ensures timely access to up-to-date data
  • Reliable and consistent report generation
🛠️ Tech Stack
  • Framework/Platform: .NET 9 / .NET Core Console App
  • Language: C#
  • Database: Microsoft SQL Server
  • Excel Library: EPPlus or ClosedXML
  • File Upload: SharePoint API integration
  • Task Scheduling: Windows Task Scheduler or Cron jobs
📹 Project Demo

Watch the demo below

© 2026 Wilfredo Domanico Jr. All rights reserved.