excel batch import export

    1

    Automates EasyExcel batch import/export for Spring Boot, MyBatis Plus, and LayUI admin panels.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    excel batch import export

    Example session with this skill installed

    Add batch import and export for the ProductEntity table. Use productCode as the unique key. The admin page uses LayUI and the controller is at /admin/product.

    • Read your context and instructions
    • Compiled the excel batch import

    I have implemented the batch Excel features for ProductEntity. I created a shared VO, added the endpoints to ProductController, and implemented the upsert logic in ProductService.

    Product Excel Integration

    // src/main/java/com/app/vo/ProductExcelVO.java
    @Data
    @ColumnWidth(22)
    public class ProductExcelVO implements Serializable {
        @ExcelProperty(value = "产品编码", index = 0) 
        private String productCode;
        
        @ExcelProperty(value = "产品名称(必填)", index = 1) 
        private String productName;
        
        @ExcelProperty(value = "价格", index = 2) 
        private BigDecimal price;
    
        @ExcelProperty(value = "创建时间", index = 3) 
        private String createTime;
    }
    
    // LayUI Frontend Binding
    function uploadRender() {
        upload.render({
            elem: '#productImport',
            accept: 'file',
            exts: 'xls|xlsx',
            url: '/admin/product/import',
            done: function (res) {
                if (res.code === 200) { 
                    layer.msg('导入成功'); 
                    table.reload('productTable'); 
                }
            }
        });
    }
    

    Next steps

    1. Add the com.alibaba:easyexcel dependency to your pom.xml.
    2. Add the Import/Export buttons to your toolbarDemo script in product_list.html.
    3. Restart the service and test with the generated "Download Template" link.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Manual implementation of Excel processing in Spring Boot is repetitive and error-prone. This skill automates the creation of high-performance batch import and export features using the EasyExcel framework.

    What it does

    • Shared VO Generation: Creates a single ExcelVO class to synchronize import and export column mappings.
    • Controller Scaffolding: Implements endpoints for blank template downloads, filtered data exports, and file uploads.
    • Upsert Logic: Handles data ingestion with intelligent matching to update existing records or insert new ones based on business keys.
    • Frontend Integration: Provides ready-to-use LayUI and Thymeleaf snippets for toolbar buttons and asynchronous file uploads.
    • Data Conversion: Manages date formatting and field mapping between database entities and Excel rows.

    How it works

    1. Context Discovery: Read existing Controller and Entity files to identify target tables and business unique keys.
    2. VO Creation: Generate the ExcelVO with @ExcelProperty annotations ensuring contiguous indexing.
    3. Backend Implementation: Add the export, import, and template methods to the Spring Service and Controller layers.
    4. UI Binding: Insert the LayUI upload handlers and toolbar buttons into the admin page.

    Frameworks & tools

    Java, Spring Boot, MyBatis Plus, Alibaba EasyExcel, LayUI, Thymeleaf, and Maven.

    Why this beats prompting it yourself

    Standard prompts often fail to align VO column indexes or forget that LayUI requires re-binding upload elements after table re-renders. This skill enforces a strict shared-VO architecture and includes the necessary transaction management and front-end callbacks to prevent production data corruption.

    Use cases

    • Adding bulk product upload capabilities to an e-commerce inventory table.
    • Implementing filtered report exports for administrative dashboards.
    • Migrating legacy spreadsheet data into a MyBatis Plus managed database.
    • Providing downloadable data entry templates for warehouse staff.

    Known limitations

    Requires a Spring Boot project with EasyExcel and MyBatis Plus already in the classpath. Targeted specifically at LayUI-based admin interfaces for the frontend implementation.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for APIs & Backend.

    Requires EasyExcel and MyBatis Plus dependencies. Optimized for LayUI admin templates. Business unique keys must be clearly defined in the entity.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Permissions

    Read Files
    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the repetitive task of writing boilerplate code for Excel processing by generating shared Value Objects (VOs), backend controllers, and frontend LayUI components that work together seamlessly.

    It is specifically designed for Java environments using Spring Boot, MyBatis Plus, and Alibaba EasyExcel, with frontend support optimized for LayUI and Thymeleaf admin panels.

    Unlike generic AI prompts, this skill enforces a shared-VO architecture to ensure column indexing is identical for both imports and exports, preventing data misalignment and frontend binding errors common in LayUI.

    The skill implements an 'upsert' logic that uses your business unique keys to determine whether to update an existing record or create a new one during the import process.

    The skill generates the necessary Java classes (VOs, Controllers, Services), MyBatis Plus logic, and the corresponding LayUI/Thymeleaf frontend snippets for a complete end-to-end implementation.

    Yes, the skill reads your existing Controller and Entity files to ensure the generated code follows your project’s naming conventions and database schema automatically.

    New in APIs & Backend

    Free