Excel Document Processing Using Syncfusion Flutter XlsIO Library

Overview

Create, edit, and save Excel workbooks (.xlsx) using the Syncfusion Flutter XlsIO library. This skill supports generating Dart code snippets for Flutter projects targeting mobile, web, and desktop platforms.

Key Capabilities

• Create & Edit: Workbooks, worksheets, cells, rows, columns, cell formatting, styles, formulas, named ranges, charts, images, hyperlinks, data validation, conditional formatting
• Data Management: Import data (lists, typed data, hyperlinks, images), export data, advanced filtering (text, custom, date, dynamic, color filters), freeze panes, show/hide rows/columns
• Advanced Features: RTL layout for international support, CSV export, template-based operations, data validation rules (text, list, number, date, decimal, custom)
• Charts & Visualization: Create and configure all chart types (pie, bar, column, line, stacked, 3D, specialized), customize elements (title, legends, labels, positioning)
• Security: Password protection, worksheet/workbook encryption, cell protection with unlock options
• Page Setup: Margins, page breaks, print areas, page orientation, headers/footers

Prerequisites

• Flutter SDK installed
• Add dependencies to pubspec.yaml:

``yaml dependencies: syncfusionflutterxlsio: ^33.1.44 syncfusion_officechart: ^33.1.44 ``

• Use the latest compatible package versions from pub.dev or Syncfusion documentation.
• Run: flutter pub get
• Import in Dart code:

``dart import 'package:syncfusionflutterxlsio/xlsio.dart'; import 'package:syncfusion_officechart/officechart.dart'; ``

Quick Start Example

Generate Dart Code

User: "Show me how to create an Excel workbook with multiple sheets" Result: Dart code snippet displayed (no files created)

Mode: Generate Dart Code for the User's Flutter Project

Trigger keywords: "show me how", "how to", "how can I", "how do I", "provide code", "provide an example", "give an example", "demonstrate", "code snippet", "sample code", "example", "sample", "give me", "show me", "main.dart", "example code", "generate code for", "codesnippet".

Workflow:

Step 1 — Detect the Platform and Suggest the Correct Package

• Inspect the workspace project files (pubspec.yaml, main.dart, etc.) to identify the Flutter platform target (mobile, web, desktop).
• Tell the user to add syncfusionflutterxlsio to their pubspec.yaml before generating any code.

Step 2 — Generate Code from Reference Files Only

Do NOT invent, guess, or suggest any API, class, method, or property not explicitly present in the reference files.

• Read the relevant references/*.md file(s) for the requested feature
• Build Dart code strictly from the APIs and snippets found in those files
• Use the correct save/launch pattern for the target platform:

- Mobile → getApplicationSupportDirectory() + OpenFile.open() - Desktop → getApplicationSupportDirectory() + OpenFile.open() - Web → base64 + JavaScript download or web package approach

• Do not create or run any standalone Dart script

Code References

All snippets are in the references/ folder:

Rules

• Do NOT create or run temp scripts — this skill only generates code for user projects (Mode 1)
• Generate code strictly from reference files — never invent APIs or methods
• Always include proper imports: import 'package:syncfusionflutterxlsio/xlsio.dart'; and import 'package:syncfusion_officechart/officechart.dart';
• For mobile/desktop apps: Use getApplicationSupportDirectory() + OpenFile.open() for file saving
• For web apps: Use base64 + JavaScript download or web package approach
• Always call workbook.dispose() after saving to release memory
• Save workbooks synchronously using saveSync() or asynchronously using save()
• Remind users to add syncfusionflutterxlsio and syncfusion_officechart to pubspec.yaml before using generated code