We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Flutter Excel Library - Overview

Flutter Excel Library is a feature-rich, high-performance file-format library that lets you add robust Excel functionalities to Flutter applications. It allows you to create Excel documents programmatically with text, numbers, date-time values, styles, number formats, formulas, images, charts, hyperlinks, imported data, conditional formatting, and workbook and worksheet protection.


General information

Powerful and comprehensive APIs

All the elements in typical Excel documents like text, numbers, date-time values, cell formatting, images, formulas, charts, hyperlinks, conditional formatting, and protection are accessible through a comprehensive set of APIs.

Create Excel files from scratch

Essential XlsIO allows you to create Excel documents from scratch and save them to a stream with just a few lines of code.


Flutter Excel library features

Multi-worksheet Excel document in Flutter

Worksheet manipulation

Create Excel worksheets with text, numbers, date-time values, cell formatting, basic formulas, images, charts, hyperlinks, protection, autofit rows and columns, and more.

Cell formatting in Flutter Excel Library

Cell formatting

Apply various kinds of cell formatting like cell styles, number formats, built-in styles, merged cells, and text alignment.

Formulas in Flutter Excel Library

Formulas

Add formulas and nested formulas to worksheet cells to calculate values. Use logical functions formulas such as mathematical, statistical, etc. , and lookup functions.

Images in Flutter Excel Library

Images

Insert images with formats such as PNG and JPEG into Excel worksheets. Hyperlinks can also be added to the images.

Charts in Flutter Excel Library

Charts

Add embedded charts to Excel worksheets to visualize data in a graphical structure. Use chart types such as pie, column, line, stacked, and area.

Flutter Excel Library protection

Protection

Protect the structure of an Excel workbook and the cells of the worksheets from editing.

Row and column manipulations in Flutter Excel Library.

Row and column manipulations

Perform various cell-level operations like resizing, adding, or deleting rows and columns.

Conditional formatting in Flutter Excel Library

Conditional formatting

Apply various types of conditional formatting based on cell values, formulas, top and bottom values, unique or duplicate values, and above or below average along with advanced conditional formatting features.

Import data in Flutter Excel Library

Import data

Easily import data from a List to an Excel worksheet.

Data validation in Flutter Excel Library.

Data validation

The Excel Library supports number, time, date, text length valdations, and drop down lists.

Tables in Flutter Excel Library.

Tables

Excel tables can be created with header rows, banded rows and columns, total rows, and built-in styles.

Filters in Flutter Excel Library

Filters

The Excel Library supports various filters such as text, date, custom, dynamic, and color.


Flutter Excel Code Example

Easily get started with the Flutter Excel library using a few simple lines of Dart code example as demonstrated below. Also explore our Flutter Excel Library Example that shows you how to render and configure the Flutter Excel.

import 'dart:convert';
import 'dart:html';

Future<void> _createExcel() async {
// Create a new Excel Document.
final Workbook workbook = Workbook();

// Accessing worksheet via index.
final Worksheet sheet = workbook.worksheets[0];

// Set the text value.
sheet.getRangeByName('A1').setText('Hello World!');

// Save and dispose the document.
final List<int> bytes = workbook.saveAsStream();
workbook.dispose();

//Download the output file in web.
AnchorElement(
    href:
        "data:application/octet-stream;charset=utf-16le;base64,${base64.encode(bytes)}")
  ..setAttribute("download", "output.xlsx")
  ..click();



Feature Matrix

Document and Workbook Features Flutter Mobile Flutter Web
Create Excel documents from scratch. Yes Yes
Save an Excel document to a stream. Yes Yes
Change worksheet names. Yes Yes
Excel content
Add text, number, and date-time values to single or multiple cells in Excel worksheets. Yes Yes
Apply cell formatting including colors, text alignment, number formats, font styles, built-in styles, borders, etc. Yes Yes
Insert JPEG and PNG images. Yes Yes
Add formulas to worksheet cells that can evaluate values. Yes Yes
Add embedded charts to Excel worksheets to visualize data. Yes Yes
Insert hyperlinks to cells and images that can navigate to a webpage, remote file, or even to a different region in the same Excel document. Yes Yes
Import data from List< Object > to worksheets. Yes Yes
Create and manipulate conditional formatting (icon sets, data bars, color scales, specific data values, top-bottom rules, above-below average styles, and unique/duplicate value formatting). Yes Yes
Row and Column Manipulation
Merge and unmerge cells. Yes Yes
Resize rows and columns of a worksheet. Yes Yes
Insert and delete rows and columns. Yes Yes
Security
Protect workbooks. Yes Yes
Protect worksheets. Yes Yes
Lock and unlock cells with protection. Yes Yes


Frequently Asked Questions

The Syncfusion Flutter Excel library provides the following features:

  • Create, read, edit, and view Excel files with just a few lines of code.
  • Utilize top features: charts, formulas, tables, pivot tables, data validation, data import and export, conditional formatting, shapes, and security.
  • Import data into a customized format using Template Markers.
  • Perform quick evaluation with 400+ functions.
  • Convert Excel files into PDF, HTML, and images.
  • One of the best Flutter Excel libraries on the market, offering a rich set of APIs to interact with the software.
  • Extensive demos, documentation, and videos to learn quickly and get started with Syncfusion XlsIO.

No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.

A good place to start would be our comprehensive getting started documentation.

Apart from Flutter, the Syncfusion Excel library supports platforms for web (Blazor, ASP.NET Core, ASP.NET MVC and ASP.NET Web Forms), mobile (.NET MAUI, Xamarin, and UWP) and desktop (Windows Forms, WPF, WinUI, .NET MAUI, Xamarin, and UWP).

You can find our Excel Framework demo here.

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Scroll up icon
Live Chat Icon For mobile