vue-table-operation_skill

This skill automates logging in, navigating the comprehensive Vue Table, extracting data, exporting to Excel, and updating records to streamline batch

Python

2.5k

GitHub Stars

2

Bundled Files

2 months ago

Catalog Refreshed

3 months ago

First Indexed

Readme & install

Copy the install command, review bundled files from the catalogue, and read any extended description pulled from the listing source.

Installation

Preview and clipboard use veilstrat where the catalogue uses aiagentskills.

npx veilstrat add skill openclaw/skills --skill vue-table-operation

_meta.json295 B
SKILL.md3.6 KB

Overview

This skill automates interaction with the vue-element-admin comprehensive Table page to log in, iterate table rows across pages, modify record importance, and export collected data to an Excel file. It combines a browser automation tool for UI actions with openpyxl for Excel creation and updates. The workflow is built for repeatable bulk processing of Table data and preserves original values before changes.

How this skill works

The skill opens the admin site, performs login if needed, and navigates to the comprehensive Table view. It iterates page by page, opens each row's edit dialog, extracts specified fields (type, time, title, status, importance), writes those values into an Excel workbook, updates the importance slider to three stars, saves the change, and moves to the next row or page. Refs for clickable elements come from live snapshots because UI refs can change after refreshes.

When to use it

Bulk audit and modification of records in vue-element-admin Table pages
Automated collection and export of table data into Excel for reporting
Routine updates that set a standard importance value across many records
Testing or demo flows that require repeatable UI interactions
When manual traversal of paginated tables is slow or error-prone

Best practices

Always capture fresh element refs from the page snapshot before clicking; refs change on refresh
Save a backup Excel copy before running modifications to preserve original data
Insert short waits after closing dialogs so the table refresh completes before next action
Limit page size or process smaller batches during initial runs to validate selectors and data extraction
Use explicit logins or logout+login to ensure a known session state before automation starts

Example use cases

Daily export of all Table entries to a dated Excel file for compliance or reporting
Normalize importance values across records after a policy change (set to 3 stars)
Collect metadata (author, type, time, title, status) to feed downstream analytics or audits
Automated regression test that verifies edit dialog fields and slider behavior across pages
One-off data migration where extracted Excel is used as an import source elsewhere

FAQ

No. Element refs used by the browser tool can change after refreshes. Always acquire current refs from the page snapshot before interacting.

Where is the Excel file saved?

By default the script writes a dated .xlsx file to the Desktop path provided in the code; change the file_path to suit your environment.

How is importance measured and changed?

Importance is inferred from slider/star images in the edit dialog. The script clicks the third star in the slider to set importance to 3 stars.