skills.rest
aiyinluya
aiyinluyaCOMMUNITY
Explore all skills by this author →
GitHub

formatted-export-with-parquet

Filter empty or invalid records across Excel sheets and export red-highlighted rows.

2|Updated May 19, 2026
Search Tags:#filtering#excel#data cleaning#multi-sheet#pyarrow#highlight export#spreadsheet visualization
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill formatted-export-with-parquet-aiyinluya
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: formatted-export-with-parquet
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-result-export/formatted-export
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill formatted-export-with-parquet-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, pyarrow, openpyxl.

What problem does it solve?

It solves the problem of quickly locating specific records across multiple Excel sheets and turning the results into a clearly highlighted output for fast review and downstream analysis.

Core Features & Use Cases

  • Cross-sheet condition filtering: Scans every sheet, fuzzy-matches a target column, and selects rows that meet conditions such as empty/invalid values.
  • Visual red highlighting: Exports the matched rows to an Excel file and marks the entire matched rows in red for instant human inspection.
  • Data-cleaning workflow fit: Useful for data cleaning, conditional filtering, and “audit-style” visualization where exceptions must stand out.

Quick Start

Use the formatted-export-with-parquet skill to filter the specified empty/invalid records across all sheets and generate a red-highlighted Excel file.

Frequently Asked Questions about formatted-export-with-parquet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I filter empty values across multiple Excel sheets and highlight matching rows?▼

You can filter empty values across multiple Excel sheets by scanning every sheet, fuzzy-matching a target column, and exporting matched rows into a new Excel file with full-row red highlighting for instant visual inspection.

What is the best way to visually audit invalid records in an Excel spreadsheet?▼

The best way to visually audit invalid records in an Excel spreadsheet is to apply conditional filtering across all sheets and export the matching rows with red highlighting, making exceptions stand out for fast review.

Does pandas work with pyarrow and openpyxl for Excel data cleaning and export?▼

Yes, pandas works with pyarrow for data handling and openpyxl for Excel writing and cell styling, satisfying deterministic export requirements when filtering and highlighting invalid spreadsheet records.

Can I do conditional selection across all sheets in one Excel file?▼

Yes, you can perform conditional selection across all sheets in one Excel file by scanning every sheet, fuzzy-matching a target column, and selecting rows that meet empty or invalid value conditions.

How do I highlight filtered Excel rows in red for data review?▼

You can highlight filtered Excel rows in red by using openpyxl for cell styling to mark entire matched rows, creating a visual audit output file for fast human inspection and downstream analysis.

Related Skills

Explore More Data & Analytics Skills→
Sir-chawakornSir-chawakorn
9

wrangle-tabular-data

Clean, transform, and reshape CSV, Parquet, and DataFrame tabular data.

Community
Advanced
UntLabUntLab
1

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting across Excel, CSV, and TSV.

Community
Intermediate
hmzainjamilhmzainjamil
1

xlsx-manipulation

Create and edit Excel workbooks with openpyxl, including formulas, styling, validation, and charts.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

sn-da-large-file-analysis

Convert large Excel datasets to Parquet using streaming techniques.

Official
Advanced