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/*.md file(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
1---2name: syncfusion-uwp-spreadsheet-editor3description: Use this skill for UWP 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.4---56# Syncfusion UWP Spreadsheet Editor78## Overview910Build Excel-like spreadsheet applications in UWP using Syncfusion SfSpreadsheet control with full support for workbook operations, formulas, charts, data validation, and ribbon customization.1112## Key Capabilities1314- **Workbook Operations:** Create/open/save Excel files (XLS, XLSX, XLSM, CSV), multiple worksheets, freeze panes, zoom, protection15- **Cell Operations:** Editing, formatting (fonts, colors, borders, alignment), merge cells, comments, hyperlinks, bookmarks16- **Data Features:** 400+ Excel-compatible formulas, named ranges, data validation, conditional formatting, fill series17- **Advanced Features:** Charts, sparklines, clipboard operations, undo/redo, grouping/outlines181920## Quick Start Examples2122### Example 123**User:** "Show me how to create a spreadsheet with data and formulas"2425**Result:** C# code generated to create workbook, set cell values, and add formulas2627### Example 228**User:** "Add data validation and rules in the spreadsheet control"2930**Result:** C# code generated for spreadsheet control validation and custom rules3132---3334## Generate UWP Code — Workflow3536**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"3738### Step 1: Ask User for Delivery Option3940Before showing code, ask:41```42"How would you like me to provide the solution?4344Option 1: Create a new file in skill folder (.codestudio/skills/syncfusion-uwp-spreadsheet-editor/output/)45Option 2: Add code to an existing file in your project (you provide the file path)46Option 3: Just show the code (no files created/modified)4748Please select Option 1, 2, or 3."49```5051**⏸️ WAIT for explicit user selection before proceeding.**5253### Step 2: Generate Code from Reference Files5455- Read relevant `references/*.md` file(s) for requested feature56- Build C# and/or XAML code using ONLY snippets from reference files57- Do NOT show code yet, do NOT create files yet5859### Step 3: Handle User Selection6061**Option 1:** Show code → automatically save to `.codestudio/skills/syncfusion-uwp-spreadsheet-editor/output/` (skill folder only)62**Option 2:** Ask for file path → show code → wait for explicit YES confirmation → apply code → ask to build63**Option 3:** Show code with summary and required assemblies → done (no files created/modified)6465 - **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.6667---6869## Out-of-Scope Requests70When 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:7172**"Unable to process the input. Please provide the input in a different way."**7374**Do NOT attempt to:**75- Generate code outside the spreadsheet/Excel domain76- Provide general UWP guidance unrelated to spreadsheet functionality77- Process requests for other Syncfusion controls or unrelated frameworks78- Assist with non-spreadsheet features7980**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).8182---8384## Code References8586All templates and feature snippets live in `references/*.md`. Each file is a focused snippet the agent combines when generating samples.87 88Flow: 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.8990| File | Contents |91|---|---|92| **gettingstarted.md** | NuGet packages check, XAML setup, namespaces, create/open/save workbook, basic spreadsheet code |93| **localization.md** | Supported languages, culture settings, localized UI strings, RTL support, number/date/currency formatting, dynamic language switching |94| **ribboncustomization.md** | Add custom ribbon tabs, add items to existing tabs, remove ribbon tabs and items, ribbon customization patterns |95| **worksheetmanagement.md** | Insert/delete/rename/hide/unhide sheets, protection (sheets and workbooks), gridlines, headings, zooming |96| **editing.md** | Enable/disable editing, edit cells programmatically, locking/unlocking cells, editing events, data validation (number, date, text, list, custom formula), hyperlinks |97| **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 |98| **findandreplace.md** | Find All, Find Next, Find Conditional Formatting, Find Constants, Find Formulas, Find Data Validation, Replace All, Replace operations |99| **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 |100| **customformula.md** | Register custom formulas, add custom formulas to FormulaEngine, implement custom formula logic, use custom formulas in cells |101| **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 |102| **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 |103| **conditionalformatting.md** | Highlight cell rules (values, formulas, text, time periods), data bars, color scales, icon sets, comparison operators, format types, time period types |104| **interactivefeatures.md** | Clipboard operations (cut, copy, paste, paste options in pogrammatically), undo/redo functionality, context menu customization, cell comments |105| **outline.md** | Group/ungroup rows and columns, expand/collapse groups, outline settings, clear all outlines |106| **shapes.md** | **⚠️ REQUIRED for graphic elements:** Charts (register `GraphicChartCellRenderer`), sparklines (register `SparklineCellRenderer`), pictures (add at runtime), text boxes, select shapes, clear shape selection |107| **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 |108109---110## Rules1111121. **Use Only Reference Snippets**113 - Generate code **exclusively from** the Markdown files under `references/`114 - **Do not invent/guess/include** any properties, events, API methods, component names, or parameters not present in `references/*.md`1151162. **NO FILE MODIFICATIONS WITHOUT PERMISSION**117 - Never create or modify files/folders in user workspace without explicit user selection and confirmation.118 - Cannot create StackPanel, buttons, textblocks, dialogs, MessageBox or any UI elements beyond the Spreadsheet without user permission.1191203. **Unsupported Feature Handling**121 - If the user requests a feature with no corresponding snippet in `references/*.md`, respond with:122 `That feature is not currently supported by the Syncfusion UWP Spreadsheet component.`123 - Suggest the closest supported features **only if** they have snippets124 - **Explicitly list** unsupported items and **do not synthesize code** for them1251264. **Validation Before Write**127 - Re-validate before writing that **all code blocks** originate from `references/*.md` files128 - If validation fails, stop and inform the user129130---
syncfusion