A specialized automation skill for navigating vue-element-admin tables, updating record importance, and generating Excel reports.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install vue-table-operation
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install vue-table-operation using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Vue Table Automation and Excel Export?
This skill provides a robust framework for interacting with the vue-element-admin management system. It leverages browser automation to handle complex UI interactions such as multi-step login, table navigation, and modal-based data editing. By integrating Openclaw Skills with Python's openpyxl library, it bridges the gap between web-based data management and local reporting, ensuring seamless data extraction and updates.
The skill is designed to handle the nuances of modern web frameworks, including dynamic element references and state changes. It automates the tedious process of clicking through paginated tables, capturing details from modal popups, and synchronizing that data into a structured Excel format for business intelligence or record-keeping purposes.
Vue Table Automation and Excel Export Use Cases
- Bulk updating record importance or star ratings in a Vue-based admin dashboard.
- Generating daily Excel reports from dynamic web tables for stakeholders.
- Automating data validation by traversing multiple pages of an administrative interface.
- Synchronizing web-based records with local spreadsheet storage for offline analysis.
How Vue Table Automation and Excel Export Works
- Initializes the browser and authenticates using provided credentials (editor/123456) to access the dashboard.
- Creates a local Excel workbook using openpyxl, pre-formatted with headers for Author, Type, Title, and Status.
- Navigates the sidebar menu to locate and open the Comprehensive Table view.
- Iterates through table rows, opening the edit modal for each entry to extract detailed metadata.
- Updates the record's importance rating (e.g., to 3 stars) and saves the changes back to the system.
- Appends the extracted data to the Excel file and handles pagination until all records are processed.
- Saves the final report to the local filesystem and closes the browser session.
Vue Table Automation and Excel Export Setup
To use this Openclaw Skills automation, ensure you have the necessary Python environment and libraries installed.
pip install openpyxl
Ensure your agent has the browser tool enabled and access to the target URL: https://panjiachen.github.io/vue-element-admin/. The script assumes a default export path on the Desktop.
Vue Table Automation and Excel Export Data Schema & Taxonomy
The skill generates an Excel file (.xlsx) named with the current date (YYYY-MM-DD.xlsx) containing the following columns:
| Column | Source | Description |
|---|---|---|
| ID | Table Row | The sequence number of the record. |
| Author | Table Row | The creator of the entry. |
| Type | Modal | Category (e.g., Japan, China, USA, Eurozone). |
| Time | Modal | Formatted timestamp (YYYY-MM-DD HH:MM). |
| Title | Modal | Full text of the record title. |
| Status | Modal | Current state (published/draft). |
| Importance | Action | The updated star rating (set to 3 stars). |
Vue Table Automation and Excel Export Advanced Features
- Dynamic element reference resolution using browser snapshots to handle UI refreshes and shifting DOM elements.
- Automated pagination logic supporting datasets of various sizes (e.g., 20 records per page).
- Multi-tool coordination between browser interactions and local openpyxl file operations.
- Intelligent modal handling to ensure data is captured only when the UI is ready.
SKILL.md
Loading
Related Openclaw Skills
Universal PDF Vision Parser
A high-performance document digitizer that uses multimodal vision to convert multilingual PDFs and complex layouts into perfectly structured Markdown.
Platform Health Check
A diagnostic tool to monitor the connectivity, latency, and authentication status of over 20 agent platform APIs.
SkillGuard
SkillGuard is a specialized security tool designed to audit Openclaw Skills for malicious code, prompt injections, and data exfiltration threats.
Content Automator
A high-performance automation pipeline for generating faceless YouTube content using AI scripts, ElevenLabs TTS, and ffmpeg assembly.
WSB Digest
An automated tool to track trending WallStreetBets stocks and deliver insightful daily reports directly to Discord.
Annotation Format Converter
A versatile tool to bridge the gap between different computer vision annotation standards like COCO, YOLO, and VOC.
Featured*
