skills.rest
Starlitnightly
StarlitnightlyCOMMUNITY
Explore all skills by this author →
GitHub

data-export-excel

Export AnnData observations, variables, DEG results, and QC metrics to styled multi-sheet Excel workbooks using openpyxl.

1.2k|145|Updated Mar 22, 2021
Search Tags:#formatting#pandas#openpyxl#excel#data export#workbook#multi-sheet
One-click install
npx skills add https://github.com/Starlitnightly/omicverse --skill data-export-excel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-export-excel
Source: https://github.com/Starlitnightly/omicverse/tree/main/.claude/skills/data-export-excel
Command: npx skills add https://github.com/Starlitnightly/omicverse --skill data-export-excel

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill exports analysis results, tables, and formatted spreadsheets to Excel, enabling easy sharing and offline analysis.

Core Features & Use Cases

  • Multi-sheet workbooks: separate metadata, results, and figures into sheets.
  • Formatting: header styling, column width auto-adjustment, borders, and themes.
  • Large datasets: guidance for exporting large datasets efficiently.

Quick Start

Save a DataFrame of DEG results to analysis_results.xlsx with a formatted header.

Frequently Asked Questions about data-export-excel

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

FAQPage Schema
How do I export a pandas DataFrame to Excel with formatted headers and styling?▼

Export pandas DataFrames to Excel using openpyxl-based formatting that applies header styling, auto-adjusts column widths, and adds borders. This Skill automates the multi-step process of writing data and applying professional formatting in a single operation.

Can I export multiple tables into separate sheets in a single Excel workbook?▼

Yes, multi-sheet workbooks let you organize analysis results, metadata, and statistics across separate sheets within one file. This Skill creates organized, multi-sheet Excel files compatible with any environment.

What's the best way to export large datasets to Excel without performance issues?▼

This Skill provides guidance for exporting large datasets efficiently using openpyxl, enabling safe file output and local execution that handles DEG results, cluster statistics, and QC metrics at scale.

How do I export AnnData observations and variables to Excel?▼

Export AnnData .obs and .var matrices directly to formatted Excel spreadsheets with headers, column widths, and borders applied automatically, preserving data structure for offline analysis and sharing.

Does this work for exporting analysis results like DEG tables and cluster statistics?▼

Yes, this Skill exports DEG results, cluster statistics, and QC metrics into multi-sheet workbooks with formatting. It's designed for local Python environments and produces Excel files ready for sharing and offline review.

Related Skills

Explore More Data & Analytics Skills→
omicverseomicverse
32

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

Official
Intermediate
cartacarta
12

carta-reporting-excel

Export Carta report data to branded Excel files with live aggregation formulas.

Official
Advanced
iOfficeAIiOfficeAI
31.8k

xlsx

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

Official
Advanced
OpenSenseNovaOpenSenseNova
4.9k

sn-da-large-file-analysis

Convert large Excel datasets to Parquet using streaming techniques.

Official
Advanced