Xeku.ExcelImport 0.0.0.7

Xeku.ExcelImport

Excel Import module for DevExpress XAF applications, providing robust Excel data import and template export capabilities.

繁體中文文檔

Features

• Automated Key Management: Automatically hides the primary key in the first column of the template.
• Multiple Import Modes: Supports Synchronization, Insert Only, Update Only, and Insert All.
• Data Validation: Automatically validates imported data against business rules.
• Template Generation: Generates Excel import templates with data validation.
• Filtered Export: Applies UI filters when exporting data to templates.
• Localization: Built-in support for English and Traditional Chinese.

Architecture

graph TB
    subgraph "Presentation Layer"
        UI["XAF UI (ListView)"]
    end
    
    subgraph "Controller Layer"
        ExcelImportController["ExcelImportController"]
    end
    
    subgraph "Service Layer"
        ExcelImporter["ExcelImporter"]
    end
    
    subgraph "Data Layer"
        Entities["Business Objects<br/>(ExcelImportTemplate)"]
        DB[("Database")]
    end
    
    UI --> ExcelImportController
    ExcelImportController --> ExcelImporter
    ExcelImporter --> Entities
    Entities --> DB
    
    style UI fill:#e1f5ff
    style ExcelImportController fill:#e1f5ff
    style ExcelImporter fill:#fff4e1
    style Entities fill:#e8f5e9
    style DB fill:#fce4ec

Getting Started

1. Installation

dotnet add package Xeku.ExcelImport

2. Module Registration

Register the modules in your XAF solution:

// In Module.cs
RequiredModuleTypes.Add(typeof(Xeku.ExcelImport.ExcelImportModule));

// Blazor Project (in BlazorModule.cs)
RequiredModuleTypes.Add(typeof(Xeku.ExcelImport.Blazor.ExcelImportBlazorModule));

// WinForms Project (in WinModule.cs)
RequiredModuleTypes.Add(typeof(Xeku.ExcelImport.Win.ExcelImportWinModule));

Usage

1. Configure Import Template

1. Navigate to Administration > Excel Import Template.
2. Create a new template and select the target business type.
3. Click Generate Columns to automatically create field mappings.

2. Execute Import

1. In the target ListView, click the Import Excel action.
2. Upload the filled Excel file.

AI Agent Integration

Use Cases

1. Automated Data Sync: AI Agents can trigger import logic via API or scheduled tasks.
2. Data Pre-processing: AI can clean and format data before passing it to the importer.

Best Practices

• Ensure the first column (hidden) of the Excel template contains the correct Oid for incremental updates.
• Monitor ProgressEventArgs for status updates on long-running tasks.

License

MIT License