data-export-excel
Export analysis results, data tables, and formatted spreadsheets to Excel files using openpyxl. Works with ANY LLM provider (GPT, Gemini, Claude, etc.).
Security Assessment
About data-export-excel
The 'data-export-excel' skill provides an efficient and flexible way to export bioinformatics data, analysis results, and formatted tables to Excel files. By leveraging the openpyxl Python library, this skill allows users to generate professional-quality Excel reports and spreadsheets locally, without relying on cloud-hosted services. This makes it ideal for users who need to work with large datasets or sensitive data in a secure, on-premise environment. Additionally, it is designed to be compatible with all major LLM providers, including GPT, Gemini, Claude, and others, ensuring broad accessibility and versatility across different platforms.
FAQ
What types of data can I export with this skill?
You can export a variety of data, including AnnData observations (.obs), DEG analysis results, cluster annotations, and quality control metrics. The skill supports different data formats, such as pandas DataFrames, for seamless integration with your existing workflows.
Is this skill compatible with cloud-hosted solutions?
No, this skill operates locally using the openpyxl library, meaning it does not rely on cloud-hosted services. It is designed for use in environments where you prefer not to use cloud resources.
What is the best way to handle large datasets with this skill?
For datasets larger than 100,000 rows, it is recommended to use CSV export instead of Excel to ensure performance and avoid potential memory issues.
Can I generate multi-sheet workbooks with this skill?
Yes, the skill supports the creation of multi-sheet Excel workbooks, allowing you to export different types of data (e.g., cell metadata, gene metadata, DEG results) into separate sheets within the same file.
What should I keep in mind when using this skill?
Always include column headers in the first row, convert numpy arrays to lists before writing to Excel, and ensure the output directory exists when saving the file.
Install data-export-excel
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
Starlitnightly/omicverse