القائمة
Read and parse Excel workbooks (.xlsx/.xls) with support for multiple sheets, named ranges, and automatic type inference.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Validate tabular data against configurable business rules — range checks, cross-column constraints, referential integrity against lookup tables, and temporal consistency.
Load and parse CSV files into structured data frames with configurable encoding, delimiter, and date parsing options.
Export pandas DataFrames or processed datasets to well-formatted CSV files with configurable encoding, delimiter, quoting, and column ordering.
Aggregate tabular data by one or more dimensions with configurable metrics — sum, mean, count, min, max, median. Supports multi-level grouping and pivot table generation.
Comprehensive data cleaning toolkit — handles missing values, duplicate removal, type coercion, whitespace trimming, and outlier detection in a single pass over the dataset.
Identify and remove duplicate records from tabular datasets using exact-match, fuzzy-match, or composite-key-based deduplication strategies.
| name | excel-data-reader |
| description | Read and parse Excel workbooks (.xlsx/.xls) with support for multiple sheets, named ranges, and automatic type inference. |
| version | 0.2.0 |
Reads Excel workbook files (.xlsx and .xls formats) and converts them to pandas DataFrames. Supports selecting specific sheets by name or index, reading named ranges, and automatic type inference for numeric and date columns. Can process multiple sheets in a single invocation and output each as a separate file.
--input / -i: Path to Excel file (required)--sheet: Sheet name or index (default: first sheet; use all for all sheets)--header-row: Row number containing headers (default: 0)--date-columns: Columns to force-parse as dates--output / -o: Output directorypython3 ./skills/excel_data_reader/reader.py -i <file> -o <output_dir>pandas, openpyxl, xlrd