parse-cli

分类: 数据库与数据存储 | 上传者: ChrisPappalardo | 下载: 0 | 版本: v1.0（最新）

使用此技能可以使用 eparse CLI 从 Excel 文件中提取并列出表格。当您需要从一个或多个 Excel 文件或目录中发现或提取表格数据时调用。支持输出到控制台、SQLite 或 PostgreSQL。

更新日志: Source: GitHub https://github.com/ChrisPappalardo/eparse

目录结构

当前层级: tree/main/.github/skills/parse-cli/

📄 SKILL.md 1.3 KB

SKILL.md

---
name: parse-cli
description: Use this skill to extract and list tables from Excel files using the eparse CLI. Call when you need to discover or extract tabular data from one or more Excel files or directories. Supports output to console, SQLite, or PostgreSQL.
license: MIT
---
# Parse Excel Files with eparse CLI

## When to use
- To discover, extract, or validate tables in Excel files or directories.
- For initial data exploration or to prepare data for querying.

## How to use
1. Run the following command, replacing `<path_to_files>` with your file or directory:
   ```sh
   eparse -v -f <path_to_files> parse
   ```
2. For output to SQLite (choose your own database file name):
   ```sh
   mkdir -p .files
   eparse -f <path_to_files> -o sqlite3:///.files/<your_db_file>.db parse -z
   ```
   - Replace `<your_db_file>` with your desired SQLite database file name.
3. For output to PostgreSQL (requires psycopg2):
   ```sh
   eparse -f <path_to_files> -o postgres://<user>:<password>@<host>:<port>/<db_name> parse -z
   ```
   - Replace `<user>`, `<password>`, `<host>`, `<port>`, and `<db_name>` with your PostgreSQL credentials and database name.

- Use `-t` to avoid truncation, `-l` for loose table detection, and `--exclude-nested` to skip nested tables.
- See README for more options.

登录后下载/点赞/收藏 ❤ 168 | ★ 0

parse-cli

目录结构

SKILL.md

举报内容

提示