skills.rest
liumeixin
liumeixinCOMMUNITY
Explore all skills by this author →
GitHub

excel-data-extract

Identify Excel file types (.xls, .xlsx, .xlsb) and extract data using Python libraries xlrd and openpyxl with fallback parsing methods for problematic files.

4|Updated May 14, 2026
Search Tags:#data extraction#error handling#excel#file processing#data recovery
One-click install
npx skills add https://github.com/liumeixin/hermes-skills --skill excel-data-extract
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-data-extract
Source: https://github.com/liumeixin/hermes-skills/tree/main/excel-data-extract
Command: npx skills add https://github.com/liumeixin/hermes-skills --skill excel-data-extract

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires xlrd, openpyxl, zipfile, and includes scripts (resource) components.

What problem does it solve?

This Skill assists in reading and processing various Excel file formats, offering solutions for issues that arise when encountering corrupt or incompatible files, streamlining the data retrieval process.

Core Features & Use Cases

  • File Type Identification: Determines whether the file is .xls, .xlsx, or .xlsb and selects the appropriate method for reading.
  • Error Handling: Provides workarounds for common errors encountered when using xlrd or openpyxl, such as style sheet errors and BOM issues.
  • Use Case: If you have a complex Excel file that xlrd cannot read due to a style sheet error, this Skill offers a manual parsing method to extract the data successfully.

Quick Start

Use the excel-data-extract skill to read data from the corrupted 'data-corrupted.xlsx' file.

Frequently Asked Questions about excel-data-extract

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

FAQPage Schema
How do I read a corrupted Excel file when openpyxl or xlrd fails?▼

Yes, this Skill handles .xls, .xlsx, and .xlsb formats. It automatically identifies the file type and selects the appropriate method to read BIFF, Office Open XML, and binary Excel files.

What causes xlrd style sheet errors when processing Excel files?▼

Xlrd style sheet errors occur when processing complex or incompatible Excel files. This Skill resolves these issues by providing manual parsing methods to extract data directly, bypassing the failed xlrd style sheet reading process.

Do I need Python libraries like zipfile to extract data from Excel files?▼

Yes, you need Python libraries like zipfile, openpyxl, and xlrd to extract data from Excel files. These dependencies enable the Skill to manipulate and read various Excel formats, including Office Open XML files.

What is the best way to recover data from a file with BOM issues in Excel?▼

The best way to recover data from a file with BOM issues in Excel is to use alternative reading methods that bypass openpyxl failures. This Skill provides workarounds for BOM issues to successfully retrieve your data.

Can I use Python to process binary Excel files without encountering reading errors?▼

Yes, you can process binary Excel files in Python without reading errors by using this Skill's error handling capabilities. It selects appropriate methods for .xlsb files and provides workarounds for common openpyxl and xlrd failures.

Related Skills

Explore More Data & Analytics Skills→
gauravb4875-uxgauravb4875-ux

excel-generator

Automate Excel spreadsheet creation and manipulation using Python libraries.

Community
Advanced
thechandanbhagatthechandanbhagat
8

xlsx

Read, create, convert, analyze, and report on Excel spreadsheets in XLSX, XLS, and CSV formats.

Community
Advanced
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
claude-office-skillsclaude-office-skills
368

table-extractor

Extract tabular data from PDF documents using the camelot library.

Official
Intermediate