Skip to content
cccskills

Browse skills

1K skills ・ Works with: Excel · sorted by popularity

Validate spreadsheet sources before running Python scripts to transform data, update multiple sheets, or apply formatting. Check required data first, try backup sources when needed, and report errors clearly if processing cannot proceed.

  • Checking required columns before processing Excel files
  • Transforming data and saving a new workbook
  • Updating formatting across multiple sheets
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Update or create Excel workbooks with checks against the requested structure. Identify the correct file before editing, then reread the saved workbook to verify sheet names, populated columns, row counts, and selected sample counts.

  • Identify the correct workbook among similarly named files
  • Verify required sheets and columns after editing
  • Check selected sample counts and required selection criteria
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Process Excel files with Python after checking that input files and source URLs are accessible. The workflow covers data transformations, formulas, and formatting, with alternative sources and error logs when access fails.

  • Transforming Excel data after checking input files
  • Applying formulas and formatting across multiple sheets
  • Trying backup sources when a data URL is unavailable
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Create or edit Excel workbooks with checks for sheet names, row counts, formulas, and merged cells. Reopen the saved file and verify each requirement, recording explicit results rather than relying on a completion summary.

  • Create an Excel workbook from a detailed specification
  • Verify row counts and formulas after editing
  • Identify the correct workbook among similar files
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Gather web information and turn it into an Excel workbook with explicit checks. Handles search failures through delegated research, records sources and missing data, and verifies the saved workbook against requested requirements.

  • Compiling competitor prices into a verified Excel workbook
  • Organizing market data with sources and collection times
  • Continuing research after repeated search failures
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Verify saved Excel files directly with Python and openpyxl, a workbook library. Check sheets, headers, row counts, marked rows, and output files to resolve conflicting agent reports and summarize what actually exists on disk.

  • Resolve conflicting workbook reports from agents
  • Check that spreadsheet edits were saved
  • Count rows selected with a marker column
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Process Excel workbooks and generate PDF reports by running Python scripts directly. Covers multiple sheets, data transformations, formatting, and error handling, with scripts saved as files for complex tasks.

  • Transform data across multiple Excel sheets
  • Apply consistent formatting to spreadsheet reports
  • Generate PDF reports from spreadsheet data
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Process Excel workbooks by saving Python scripts to files and running them through the shell. Covers multiple sheets, data transformations, formulas, formatting, and error reporting for complex spreadsheet tasks.

  • Transform revenue data and save a processed Excel workbook
  • Apply calculations across multiple worksheets
  • Format report headers with colors and alignment
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Create and process Excel files, PDF checklists, and structured reports by running Python scripts directly. The skill covers multiple sheets, formulas, formatting, data transformations, and error handling for document workflows with several steps.

  • Process and format multiple Excel sheets
  • Create PDF checklists
  • Turn sales summaries into PDF reports
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Track tasks that require several output files with an upfront checklist, checks after each file is created, and a final review. Confirm that every required file exists and has a nonzero size before reporting completion.

  • Deliver a spreadsheet and a document together
  • Check that a report and summary are both present
  • Verify data files and visualizations before completion
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Run Python through shell commands when sandbox execution fails because required packages are unavailable. The skill explains short commands, multiline scripts, package checks, and output verification, with examples for creating Excel and Word files.

  • Continuing Python work after sandbox import failures
  • Creating Excel or Word files through shell commands
  • Running multiline Python scripts with a heredoc
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Build answers and reports from provided reference files before searching the web. The workflow identifies attachments, extracts and checks relevant data, tries alternatives for unreadable Word files, and states sources and missing information.

  • Creating a report from an attached Excel file
  • Extracting reference text when Word file reading fails
  • Identifying missing information before supplementary searches
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Helps agents build outputs from supplied reference files by reading, checking, and citing their data first. External searches are reserved for missing details, verification, or tasks that explicitly require current information.

  • Creating reports from attached spreadsheets
  • Building property documents from supplied listing data
  • Checking reference files before searching the web
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Use attached spreadsheets and documents as the primary source for reports and analysis. Identify relevant files, extract needed data, and cite filenames, turning to external searches or clearly labeled estimates only when the supplied material lacks required information.

  • Preparing a report from an attached Excel file
  • Extracting required figures from CSV or PDF files
  • Citing the source filename for reported data
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Extract data from supplied spreadsheets and documents, check for missing or truncated content, and try alternative reading methods when needed. Results identify source files and clearly separate extracted facts from external information or estimates.

  • Creating reports from attached spreadsheets
  • Recovering pricing tables from incomplete Word extraction
  • Re-reading missing sections of a PDF
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Recover failed Python tasks by saving the code as a script and running it through the shell. Provides steps to inspect errors and confirm generated files for spreadsheet creation, data processing, and calculations.

  • Retry failed Excel or CSV generation
  • Resume data transformations after a sandbox error
  • Investigate Python errors through shell output
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Create and edit Excel workbooks by running a complete Python script through the shell. Covers multiple sheets, data entry, formatting, formulas, and saving files when other file-reading or code-execution tools fail.

  • Create an Excel report with multiple sheets
  • Apply data and formatting in one script
  • Update cells in an existing XLSX file
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Recover from failed inline Python execution by saving the code as a script, running it through the shell, and checking the output. The four-step workflow helps diagnose errors in multiline code and spreadsheet generation tasks.

  • Recovering from failed inline Python execution
  • Diagnosing heredoc parsing errors
  • Debugging complex multiline scripts
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Diagnose Python spreadsheet failures through staged checks of the interpreter, library imports, file access, and basic operations. Minimal test scripts help separate environment problems from errors in the full processing script.

  • Investigating unclear errors returned by run_shell
  • Diagnosing spreadsheet scripts that suddenly stop working
  • Checking Python setup in a new environment or container
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Create spreadsheets, diagrams, and PDF reports in a staged workflow. Allocate execution attempts across deliverables, check generated files, and use simpler methods or alternative formats when tool errors or limited remaining attempts interrupt progress.

  • Preparing a comparison spreadsheet, diagram, and report
  • Allocating execution attempts across several deliverables
  • Recovering from file generation errors with fallback methods
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Continue Excel file creation and editing when execute_code_sandbox repeatedly fails with openpyxl errors. Use run_shell to run Python directly, then check that the workbook was saved with the expected sheets and content.

  • Continuing Excel creation after sandbox errors
  • Editing existing workbooks and adjusting column widths
  • Checking saved workbook sheets and content
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Build Excel spreadsheets with merged titles and headers using openpyxl, a Python library for spreadsheet files. Follow a sequence for entering values, merging cells, and applying formatting, with guidance for updating existing merged ranges and checking saved results.

  • Creating report titles that span multiple columns
  • Formatting section headers and grouped labels
  • Updating values in existing merged ranges
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Find generated files that are missing from their expected locations in isolated or temporary execution environments. Search confirmed directories, identify the right file, copy it to the intended destination, and verify that it is readable and nonempty.

  • Find files after a tool reports successful generation
  • Recover deliverables saved in temporary directories
  • Correct files saved in unexpected nested folders
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026

Locate missing files and verify their full paths before processing them. This workflow checks directory contents, searches by filename, and inspects permissions, size, and modification time to help resolve FileNotFoundError, an error indicating a file could not be found.

  • Investigating FileNotFoundError
  • Finding files with unknown locations
  • Checking file existence and permissions before processing
HKUDS/OpenSpace7.8KUpdated Aug 13, 2026