skills.rest
MichaelYang-lyx
MichaelYang-lyxCOMMUNITY
Explore all skills by this author →
GitHub

large-file-conditional-formatting

Switch large Excel files to Parquet-based reading for faster data ingestion.

110|3|Updated Feb 26, 2026
Search Tags:#workflow#openpyxl#excel#time-series#data-analysis#parquet#conditional-formatting
One-click install
npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill large-file-conditional-formatting-michaelyang-lyx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: large-file-conditional-formatting
Source: https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-cell-coloring/threshold-cell-coloring
Command: npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill large-file-conditional-formatting-michaelyang-lyx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel workbooks with a large total number of rows can become slow to read and memory-intensive. This Skill automatically switches to Parquet-accelerated reading when the file is large to speed up processing.

Core Features & Use Cases

  • Auto-switch Parquet-based reading for large Excel files to optimize performance.
  • Compute time-series averages across sheets or targeted dimensions.
  • Generate an Excel report using openpyxl with conditional formatting (e.g., highlighting values below the mean) and custom styling.
  • Use Case: Analyze multi-sheet workbooks to produce a color-formatted summary.

Quick Start

Run the large-file-conditional-formatting workflow on your Excel file to generate a color-formatted analysis report.

Frequently Asked Questions about large-file-conditional-formatting

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

FAQPage Schema
How do I speed up reading large Excel files for data analysis?▼

Speeding up large Excel file reading is achieved by automatically switching to Parquet-accelerated reading, which optimizes memory usage and data ingestion performance.

Can I compute time-series averages across multiple Excel sheets?▼

Computing time-series averages across multiple Excel sheets is supported, allowing multi-sheet workbooks to be analyzed and aggregated efficiently.

How do I generate an Excel report with conditional formatting using openpyxl?▼

Generating an Excel report with openpyxl applies conditional formatting like highlighting values below the mean, while adding custom styling to your summarized data.

What's the best way to process huge Excel files without running out of memory?▼

Processing huge Excel files without memory exhaustion is handled by switching to Parquet-based reading, which accelerates data ingestion for large row counts.

Does this workflow support analyzing multi-sheet workbooks to produce a color-formatted summary?▼

Analyzing multi-sheet workbooks to produce a color-formatted summary is fully supported, combining time-series computations with openpyxl report generation.

When should I switch from direct Excel reading to Parquet-based reading?▼

Switching to Parquet-based reading is necessary when Excel workbooks have a large total number of rows that make direct reading slow and memory-intensive.

Related Skills

Explore More Data & Analytics Skills→
MichaelYang-lyxMichaelYang-lyx
110

multi-sheet-reading-and-analysis

Read multi-sheet Excel workbooks and analyze data with Parquet optimization.

Community
Advanced
omicverseomicverse
32

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

Official
Intermediate
thanhtai040805thanhtai040805
2

quant-statistics

Run ADF, cointegration, and Granger causality tests on financial time series.

Community
Advanced
aiyinluyaaiyinluya
2

multi-file-excel-parquet-analysis

Count rows across Excel sheets and generate categorical statistics with Parquet.

Community
Intermediate