A WPF application that generates Word reports from Excel user data using DocX and EPPlus.
Here’s what the UI looks like:
- Load user data from Excel.
- Replace placeholders in a Word template.
- Generate a consolidated report. Headers and footers cannot be added properly due to library limitations.
- Progress bar for long operations.
- Configurable date format and language support.
- Select the Excel file containing user data. First row is ignored. Second row should have headers like
NAME,DATE, etc. - Select the Word template (DOCX) with placeholders like
{NAME},{DATE}. - Select the output folder.
- Choose the date format from the dropdown before generating reports to avoid confusion between U.S. and international formats.
- Click Generate Reports.
- The application will create a consolidated Word document with all user results.
- Language options are stored in resource files (
Resources.resx). - Date format options can be customized in the ComboBox or via configuration.
- .NET 6 or later
- EPPlus
- DocX