Use this skill for WPF Application needing Excel-like UI using the Syncfusion Spreadsheet Component. Trigger for creating, viewing, editing Excel (.xlsx, .xls) files; using formulas, filtering, sorting, or cell formatting. Also trigger when users reference spreadsheet files ("open xlsx", "load Excel file", "add Syncfusion spreadsheet"). Do NOT trigger for standalone file processing without UI components.
Build Excel-like spreadsheet applications in WPF using Syncfusion SfSpreadsheet control with full support for workbook operations, formulas, charts, data validation, and ribbon customization.
User: "Show me how to create a spreadsheet with data and formulas"
Result: C# code generated to create workbook, set cell values, and add formulas
User: "Add data validation and rules in the spreadsheet control"
Result: C# code generated for spreadsheet control validation and custom rules
Trigger keywords: "how to", "add spreadsheet", "code sample", "show me", "example", "snippet", "integrate", "component", "create sample", "code", "sample code", "generate code", "implement", "add to project", "configure spreadsheet"
Before showing code, ask:
"How would you like me to provide the solution?
Option 1: Create a new file in skill folder (.codestudio/skills/wpf-spreadsheet-editor/output/)
Option 2: Add code to an existing file in your project (you provide the file path)
Option 3: Just show the code (no files created/modified)
Please select Option 1, 2, or 3."
⏸️ WAIT for explicit user selection before proceeding.
references/*.md file(s) for requested featureOption 1: Show code → automatically save to .codestudio/skills/wpf-spreadsheet-editor/output/ (skill folder only)
Option 2: Ask for file path → show code → wait for explicit YES confirmation → apply code → ask to build
Option 3: Show code with summary and required assemblies → done (no files created/modified)
references/getting-started.md (Prerequisites and Setup Requirements section). If missing, ask user consent and add them.When a user asks a question that does NOT match the skill domain (i.e., not related to WPF Spreadsheet, Excel processing, or Syncfusion spreadsheet control), respond with:
"Unable to process the input. Please provide the input in a different way."
Do NOT attempt to:
ONLY activate this skill and its workflows when the user's request matches trigger keywords: "spreadsheet", "Excel", "UI", "code", "Ribbon", "WPF" (in context of spreadsheet/Excel).
All templates and feature snippets live in references/*.md. Each file is a focused snippet the agent combines when generating samples.
Flow: Always start with references/getting-started.md (Prerequisites and Setup Requirements section), then merge matched feature snippets. If no feature keywords match, return only the basic sample.
| File | Contents |
|---|---|
| getting-started.md | Assemblies, XAML setup, create/open/save workbook, import from datatable and export to datatable |
| localization.md | Localization and language support in spreadsheet |
| ribbon.md | Built-in ribbon overview and integration |
| ribbon-customization.md | Add/remove ribbon tabs and items, cancel ribbon commands |
| worksheet-management.md | Insert sheet/delete sheet/rename sheet/ hide sheets, gridlines, headings, zoom, events |
| editing-and-selection.md | Cell editing, cut/copy/paste, keyboard interaction |
| selection.md | Cell selection modes, select ranges, select rows/columns |
| find-and-replace.md | Find All, Find Next, Find Conditional Formatting, Find Constants, Find Formulas, Find Data Validation, Replace All, and Replace operations |
| formulas.md | 400+ Excel-compatible formulas, formula bar, multi-threaded calculation, name ranges |
| name-manager.md | Create, edit, and manage named ranges |
| cell-comments.md | Create, edit, and manage cell comments and notes |
| cell-formatting.md | set Text values , numbers values , dates values , borders, fonts, fill colors, alignment, font styles, wrap text, build in styles, format as table, clear formatting |
| resizing-and-hiding.md | Insert/Delete, Hide/unhide rows and columns, set row height and column width |
| sorting-and-filtering.md | Sorting and filtering data, apply filters, custom sort orders, filter by values and criteria |
| conditional-formatting.md | Data bars, icon sets, color scales, rule-based formatting |
| data-validation.md | Input restrictions, error alerts, list and cross-sheet validation |
| freeze-panes.md | Freeze rows and columns for easy navigation and scrolling |
| clipboard-operations.md | Cut, copy, paste with paste-special options |
| charts-pictures-textboxes.md | Import and display charts, images, and textboxes |
| outlines.md | Group/ungroup rows and columns, expand/collapse outline levels |
| sparklines.md | Import line, column, and win/loss sparklines |
| merge-cells.md | Merge and unmerge cells |
| workbook-worksheet-protection.md | Password-protect worksheets and workbook structure |
| conversion.md | Export to PDF, HTML, image, and CSV; printing spreadsheet |
| fill-series.md | Auto-fill cells with series values and patterns |
| floating-cells.md | Work with floating cells and textboxes |
| hyperlinks-and-bookmarks.md | Create and manage hyperlinks and bookmarks |
| supported-file-types.md | Supported file formats and import/export options |
| undo-redo.md | Undo and redo operations in spreadsheet |
| zooming.md | Zoom in/out and adjust view levels |
Use Only Reference Snippets
references/*.mdNO FILE MODIFICATIONS WITHOUT PERMISSION
Unsupported Feature Handling
references/*.md, respond with:
That feature is not currently supported by the Syncfusion WPF Spreadsheet component.Validation Before Write
references/*.md files