Syncfusion UWP Spreadsheet Editor
Overview
Build Excel-like spreadsheet applications in UWP using Syncfusion SfSpreadsheet control with full support for workbook operations, formulas, charts, data validation, and ribbon customization.
Key Capabilities
- Workbook Operations: Create/open/save Excel files (XLS, XLSX, XLSM, CSV), multiple worksheets, freeze panes, zoom, protection
- Cell Operations: Editing, formatting (fonts, colors, borders, alignment), merge cells, comments, hyperlinks, bookmarks
- Data Features: 400+ Excel-compatible formulas, named ranges, data validation, conditional formatting, fill series
- Advanced Features: Charts, sparklines, clipboard operations, undo/redo, grouping/outlines
Quick Start Examples
Example 1
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
Example 2
User: "Add data validation and rules in the spreadsheet control"
Result: C# code generated for spreadsheet control validation and custom rules
Generate UWP Code — Workflow
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"
Step 1: Ask User for Delivery Option
Before showing code, ask:
"How would you like me to provide the solution?
Option 1: Create a new file in skill folder (.codestudio/skills/syncfusion-uwp-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.
Step 2: Generate Code from Reference Files
- Read relevant
references/*.mdfile(s) for requested feature - Build C# and/or XAML code using ONLY snippets from reference files
- Do NOT show code yet, do NOT create files yet
Step 3: Handle User Selection
Option 1: Show code → automatically save to .codestudio/skills/syncfusion-uwp-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)
- For Option 2 only: Before generating code, check if the project has the prerequisites from
references/gettingstarted.md(Prerequisites and Setup Requirements section). If missing, ask user consent and add them.
Out-of-Scope Requests
When a user asks a question that does NOT match the skill domain (i.e., not related to UWP 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:
- Generate code outside the spreadsheet/Excel domain
- Provide general UWP guidance unrelated to spreadsheet functionality
- Process requests for other Syncfusion controls or unrelated frameworks
- Assist with non-spreadsheet features
ONLY activate this skill and its workflows when the user's request matches trigger keywords: "spreadsheet", "Excel", "UI", "code", "Ribbon", "UWP" (in context of spreadsheet/Excel).
Code References
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/gettingstarted.md (Prerequisites and Setup Requirements section), then merge matched feature snippets. If no feature keywords match, return only the basic sample.
| File | Contents |
|---|---|
| gettingstarted.md | NuGet packages check, XAML setup, namespaces, create/open/save workbook, basic spreadsheet code |
| localization.md | Supported languages, culture settings, localized UI strings, RTL support, number/date/currency formatting, dynamic language switching |
| ribboncustomization.md | Add custom ribbon tabs, add items to existing tabs, remove ribbon tabs and items, ribbon customization patterns |
| worksheetmanagement.md | Insert/delete/rename/hide/unhide sheets, protection (sheets and workbooks), gridlines, headings, zooming |
| editing.md | Enable/disable editing, edit cells programmatically, locking/unlocking cells, editing events, data validation (number, date, text, list, custom formula), hyperlinks |
| selection.md | Enable/disable selection, access current cell, get selected ranges, add/clear selections, move current cell, convert GridRangeInfo and IRange, selection events, keyboard navigation |
| findandreplace.md | Find All, Find Next, Find Conditional Formatting, Find Constants, Find Formulas, Find Data Validation, Replace All, Replace operations |
| formulas.md | Add formulas to cells, 409+ built-in functions (database, date/time, math, text, logical, lookup, statistical, financial, information), named ranges, formula calculation engine |
| customformula.md | Register custom formulas, add custom formulas to FormulaEngine, implement custom formula logic, use custom formulas in cells |
| formatting.md | Cell background color, font formatting, cell borders, cell alignment, text wrapping, merge/unmerge cells, number formatting, built-in styles, format as table, clear formatting |
| rowsandcolumns.md | Insert/delete rows and columns, row height and column width, hide/show rows and columns, freeze/unfreeze panes, auto-fit rows and columns |
| conditionalformatting.md | Highlight cell rules (values, formulas, text, time periods), data bars, color scales, icon sets, comparison operators, format types, time period types |
| interactivefeatures.md | Clipboard operations (cut, copy, paste, paste options in pogrammatically), undo/redo functionality, context menu customization, cell comments |
| outline.md | Group/ungroup rows and columns, expand/collapse groups, outline settings, clear all outlines |
| shapes.md | ⚠️ REQUIRED for graphic elements: Charts (register GraphicChartCellRenderer), sparklines (register SparklineCellRenderer), pictures (add at runtime), text boxes, select shapes, clear shape selection |
| workingwithsfspreadsheet.md | Access workbook/worksheets, access SpreadsheetGrid, workbook load/unload events, set active sheet, access cells and ranges, set/clear cell values, refresh view, scrolling, formula bar visibility, workbook modification check, suppress alerts, suspend/resume formula calculation, popup management |
Rules
- Use Only Reference Snippets
- Generate code exclusively from the Markdown files under references/ - Do not invent/guess/include any properties, events, API methods, component names, or parameters not present in references/*.md
- NO FILE MODIFICATIONS WITHOUT PERMISSION
- Never create or modify files/folders in user workspace without explicit user selection and confirmation. - Cannot create StackPanel, buttons, textblocks, dialogs, MessageBox or any UI elements beyond the Spreadsheet without user permission.
- Unsupported Feature Handling
- If the user requests a feature with no corresponding snippet in references/*.md, respond with: That feature is not currently supported by the Syncfusion UWP Spreadsheet component. - Suggest the closest supported features only if they have snippets - Explicitly list unsupported items and do not synthesize code for them
- Validation Before Write
- Re-validate before writing that all code blocks originate from references/*.md files - If validation fails, stop and inform the user