skills.rest
omicverse
omicverseOFFICIAL
Explore all skills by this author →
WebsiteGitHub

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

32|5|Updated Mar 12, 2026
Search Tags:#pandas#openpyxl#excel#spreadsheets#export#deg#annadata
One-click install
npx skills add https://github.com/omicverse/omicclaw --skill data-export-excel-omicverse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-export-excel
Source: https://github.com/omicverse/omicclaw/tree/main/src/omicverse_skills/skills/data-export-excel
Command: npx skills add https://github.com/omicverse/omicclaw --skill data-export-excel-omicverse

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Many analysis workflows produce tables, annotations, and DEG results that need to be shared, reviewed, or archived as Excel workbooks; manually converting and styling these outputs is time-consuming and error-prone.

Core Features & Use Cases

  • Export pandas DataFrames and AnnData observation/variable tables to Excel with headers and optional index.
  • Create multi-sheet workbooks for QC metrics, gene metadata, DEG results, and cluster marker lists.
  • Apply cell styling, header formatting, conditional coloring for fold-change and p-value thresholds, and auto-adjust column widths for readability.
  • Handle medium-to-large datasets with guidance to fallback to CSV when approaching Excel row limits for reliable performance.

Quick Start

Export the DataFrame df or AnnData tables to a styled Excel workbook named analysis_results.xlsx including headers and basic formatting.

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 pandas DataFrame and AnnData tables to Excel with formatting?▼

You can export DEG results to Excel with conditional formatting by applying color thresholds to fold-change and p-value columns, creating a styled multi-sheet workbook for clear review and archiving.

Does exporting bioinformatics results to Excel work without external server dependencies?▼

Exporting bioinformatics results to Excel works locally without external dependencies by using the openpyxl engine to write formatted cells, headers, and multi-sheet reports directly within the execution environment.

What is the best way to create a multi-sheet Excel workbook for QC metrics and marker lists?▼

For very large datasets approaching Excel row limits, the Skill provides guidance to fallback to CSV export, ensuring reliable performance and preventing workbook corruption when handling massive bioinformatics tables.

How do I control the index column when exporting AnnData.obs to a spreadsheet?▼

You can control the index column when exporting AnnData.obs to a spreadsheet by specifying index inclusion parameters, determining whether row names are written as a formatted column or omitted entirely.

Related Skills

Explore More Data & Analytics Skills→
MubasherMohammedMubasherMohammed

diff-visualizer

Generate visualizations and reports for bulk and single-cell RNA-seq differential expression.

Community
Advanced
iOfficeAIiOfficeAI
31.8k

xlsx

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

Official
Advanced
MDheweiMDhewei
64

single-cell-basic-analysis

Analyze single-cell RNA-seq count matrices through QC, normalization, clustering, and marker discovery.

Community
Advanced
Pixel-Process-UGPixel-Process-UG
1

xlsx-processing

Read, write, and format Excel files with openpyxl and pandas.

Official
Advanced