Excel Community

Note

This is a community-maintained fork of the excel library.

Excel Community is a flutter and dart library for reading, creating and updating excel-sheets for XLSX files.

Features

✅ Read & Write XLSX: Full support for reading and writing Excel files
✅ Multiple Data Types: Text, Numbers, Formulas, Dates, Times, Booleans
✅ Cell Styling: Fonts (Bold, Italic, Underline, Strikethrough), Colors, Borders, Alignment, Number Formats
✅ Charts: Column, Bar, Line, Area, Pie, Doughnut, Scatter, and Radar charts
✅ Cell Operations: Merge cells, insert/delete rows and columns
✅ Sheet Management: Create, copy, rename, delete sheets
✅ Cross-platform: Works on Flutter Web, Android, iOS, Desktop

Road-map:

➕ Formulas and Calculations
💾 Support Multiple Data type efficiently
✅ Charts (Implemented!)
🌄 Add Pictures
📰 Create Tables and style
🔐 Encrypt and Decrypt excel on the go.
Many more features

📋 Breaking Changes

Breaking changes from 4.x.x to 5.x.x

Updated minimum Dart SDK to 3.6.0

Breaking changes from 3.x.x to 4.x.x

Renamed Formula to FormulaCellValue
Cells value now represented by the sealed class CellValue instead of dynamic. Subtypes are TextCellValue FormulaCellValue, IntCellValue, DoubleCellValue, DateCellValue, TextCellValue, BoolCellValue, TimeCellValue, DateTimeCellValue and they allow for exhaustive switch (see Dart Docs (sealed class modifier)).

Breaking changes from 2.x.x to 3.x.x

Renamed getColAutoFits() to getColumnAutoFits(), and changed return type to Map<int, bool> in Sheet
Renamed getColWidths() to getColumnWidths(), and changed return type to Map<int, double> in Sheet
Renamed getColAutoFit() to getColumnAutoFit() in Sheet
Renamed getColWidth() to getColumnWidth() in Sheet
Renamed setColAutoFit() to setColumnAutoFit() in Sheet
Renamed setColWidth() to setColumnWidth() in Sheet

If you find this tool useful, please drop a ⭐️

📖 Usage

📄 Read XLSX File

var file = 'Path_to_pre_existing_Excel_File/excel_file.xlsx';
var bytes = File(file).readAsBytesSync();
var excel = Excel.decodeBytes(bytes);
for (var table in excel.tables.keys) {
  print(table); //sheet Name
  print(excel.tables[table].maxColumns);
  print(excel.tables[table].maxRows);
  for (var row in excel.tables[table].rows) {
    for (var cell in row) {
      print('cell ${cell.rowIndex}/${cell.columnIndex}');
      final value = cell.value;
      final numFormat = cell.cellStyle?.numberFormat ?? NumFormat.standard_0;
      switch(value){
        case null:
          print('  empty cell');
          print('  format: ${numFormat}');
        case TextCellValue():
          print('  text: ${value.value}');
        case FormulaCellValue():
          print('  formula: ${value.formula}');
          print('  format: ${numFormat}');
        case IntCellValue():
          print('  int: ${value.value}');
          print('  format: ${numFormat}');
        case BoolCellValue():
          print('  bool: ${value.value ? 'YES!!' : 'NO..' }');
          print('  format: ${numFormat}');
        case DoubleCellValue():
          print('  double: ${value.value}');
          print('  format: ${numFormat}');
        case DateCellValue():
          print('  date: ${value.year} ${value.month} ${value.day} (${value.asDateTimeLocal()})');
        case TimeCellValue():
          print('  time: ${value.hour} ${value.minute} ... (${value.asDuration()})');
        case DateTimeCellValue():
          print('  date with time: ${value.year} ${value.month} ${value.day} ${value.hour} ... (${value.asDateTimeLocal()})');
      }

      print('$row');
    }
  }
}

🌐 Read XLSX in Flutter Web

Use FilePicker to pick files in Flutter Web. FilePicker

/// Use FilePicker to pick files in Flutter Web

FilePickerResult pickedFile = await FilePicker.platform.pickFiles(
  type: FileType.custom,
  allowedExtensions: ['xlsx'],
  allowMultiple: false,
);

/// file might be picked

if (pickedFile != null) {
  var bytes = pickedFile.files.single.bytes;
  var excel = Excel.decodeBytes(bytes);
  for (var table in excel.tables.keys) {
    print(table); //sheet Name
    print(excel.tables[table].maxColumns);
    print(excel.tables[table].maxRows);
    for (var row in excel.tables[table].rows) {
      print('$row');
    }
  }
}

📂 Read XLSX from Flutter's Asset Folder

import 'package:flutter/services.dart' show ByteData, rootBundle;

/* Your ......other important..... code here */

ByteData data = await rootBundle.load('assets/existing_excel_file.xlsx');
var bytes = data.buffer.asUint8List(data.offsetInBytes, data.lengthInBytes);
var excel = Excel.decodeBytes(bytes);

for (var table in excel.tables.keys) {
  print(table); //sheet Name
  print(excel.tables[table].maxColumns);
  print(excel.tables[table].maxRows);
  for (var row in excel.tables[table].rows) {
    print('$row');
  }
}

➕ Create New XLSX File

// automatically creates 1 empty sheet: Sheet1
var excel = Excel.createExcel();

✏️ Update Cell Values

/*
 * sheetObject.updateCell(cell, value, { CellStyle (Optional)});
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * cell can be identified with Cell Address or by 2D array having row and column Index;
 * Cell Style options are optional
 */

Sheet sheetObject = excel['SheetName'];

CellStyle cellStyle = CellStyle(backgroundColorHex: '#1AFF1A', fontFamily :getFontFamily(FontFamily.Calibri));

cellStyle.underline = Underline.Single; // or Underline.Double
cellStyle.isStrikethrough = true; // enable strikethrough text


var cell = sheetObject.cell(CellIndex.indexByString('A1'));
cell.value = null; // removing any value
cell.value = TextCellValue('Some Text');
cell.value = IntCellValue(8);
cell.value = BoolCellValue(true);
cell.value = DoubleCellValue(13.37);
cell.value = DateCellValue(year: 2023, month: 4, day: 20);
cell.value = TimeCellValue(hour: 20, minute: 15, second: 5, millisecond: ...);
cell.value = DateTimeCellValue(year: 2023, month: 4, day: 20, hour: 15, ...);
cell.cellStyle = cellStyle;

// setting the number style
cell.cellStyle = (cell.cellStyle ?? CellStyle()).copyWith(

  /// for IntCellValue, DoubleCellValue and BoolCellValue use; 
  numberFormat: CustomNumericNumFormat('#,##0.00 \\m\\²'),

  /// for DateCellValue and DateTimeCellValue use:
  numberFormat: CustomDateTimeNumFormat('m/d/yy h:mm'),

  /// for TimeCellValue use:
  numberFormat: CustomDateTimeNumFormat('mm:ss'),

  /// a builtin format for dates
  numberFormat: NumFormat.standard_14,
  
  /// a builtin format that uses a red text color for negative numbers
  numberFormat: NumFormat.standard_38,

  // The numberFormat changes automatially if you set a CellValue that 
  // does not work with the numberFormat set previously. So in case you
  // want to set a new value, e.g. from a date to a decimal number, 
  // make sure you set the new value first and then your custom
  // numberFormat).
);


// printing cell-type
print('CellType: ' + switch(cell.value) {
  null => 'empty cell',
  TextCellValue() => 'text',
  FormulaCellValue() => 'formula',
  IntCellValue() => 'int',
  BoolCellValue() => 'bool',
  DoubleCellValue() => 'double',
  DateCellValue() => 'date',
  TimeCellValue => 'time',
  DateTimeCellValue => 'date with time',
});

///
/// Inserting and removing column and rows

// insert column at index = 8
sheetObject.insertColumn(8);

// remove column at index = 18
sheetObject.removeColumn(18);

// insert row at index = 82
sheetObject.insertRow(82);

// remove row at index = 80
sheetObject.removeRow(80);

🎨 Cell-Style Options

key	description
fontFamily	eg. getFontFamily(`FontFamily.Arial`) or getFontFamily(`FontFamily.Comic_Sans_MS`) `There is total 182 Font Families available for now`
fontSize	specify the font-size as integer eg. fontSize = 15
bold	makes text bold - when set to `true`, by-default it is set to `false`
italic	makes text italic - when set to `true`, by-default it is set to `false`
underline	Gives underline to text `enum Underline { None, Single, Double }` eg. Underline.Single, by-default it is set to Underline.None
strikethrough	makes text strikethrough (struck through) - when set to `true`, by-default it is set to `false`
fontColorHex	Font Color eg. '#0000FF'
rotation (degree)	rotation of text eg. 50, rotation varies from `-90 to 90`, with including `90` and `-90`
backgroundColorHex	Background color of cell eg. '#faf487'
wrap	Text wrapping `enum TextWrapping { WrapText, Clip }` eg. TextWrapping.Clip
verticalAlign	align text vertically `enum VerticalAlign { Top, Center, Bottom }` eg. VerticalAlign.Top
horizontalAlign	align text horizontally `enum HorizontalAlign { Left, Center, Right }` eg. HorizontalAlign.Right
leftBorder	the left border of the cell (see below)
rightBorder	the right border of the cell
topBorder	the top border of the cell
bottomBorder	the bottom border of the cell
diagonalBorder	the diagonal "border" of the cell
diagonalBorderUp	boolean value indicating if the diagonal "border" should be displayed on the up diagonal
diagonalBorderDown	boolean value indicating if the diagonal "border" should be displayed on the down diagonal
numberFormat	a subtype of `NumFormat` to style the CellValue displayed, use default formats such as `NumFormat.standard_34` or create your own using `CustomNumericNumFormat('#,##0.00 \\m\\²')` `CustomDateTimeNumFormat('m/d/yy h:mm')` `CustomTimeNumFormat('mm:ss')`

🔲 Borders

Borders are defined for each side (left, right, top, and bottom) of the cell. Both diagonals (up and down) share the same settings. A boolean value `true` must be set to either `diagonalBorderUp` or `diagonalBorderDown` (or both) to display the desired diagonal.

Each border must be a Border object. This object accepts two parameters : borderStyle to select one of the different supported styles and borderColorHex to change the border color.

The borderStyle must be a value from the enumerationBorderStyle:

BorderStyle.None
BorderStyle.DashDot
BorderStyle.DashDotDot
BorderStyle.Dashed
BorderStyle.Dotted
BorderStyle.Double
BorderStyle.Hair
BorderStyle.Medium
BorderStyle.MediumDashDot
BorderStyle.MediumDashDotDot
BorderStyle.MediumDashed
BorderStyle.SlantDashDot
BorderStyle.Thick
BorderStyle.Thin

/*
 *
 * Defines thin borders on the left and right of the cell, red thin border on the top
 * and blue medium border on the bottom.
 *
 */

CellStyle cellStyle = CellStyle(
  leftBorder: Border(borderStyle: BorderStyle.Thin),
  rightBorder: Border(borderStyle: BorderStyle.Thin),
  topBorder: Border(borderStyle: BorderStyle.Thin, borderColorHex: 'FFFF0000'),
  bottomBorder: Border(borderStyle: BorderStyle.Medium, borderColorHex: 'FF0000FF'),
);

Make sheet RTL

/*
 * set rtl to true for making sheet to right-to-left
 * default value of rtl = false ( which means the fresh or default sheet is ltr )
 *
 */

var sheetObject = excel['SheetName'];
sheetObject.rtl = true;

Copy sheet contents to another sheet

/*
 * excel.copy(String 'existingSheetName', String 'anotherSheetName');
 * existingSheetName should exist in excel.tables.keys in order to successfully copy
 * if anotherSheetName does not exist then it will be automatically created.
 *
 */

excel.copy('existingSheetName', 'anotherSheetName');

Rename sheet

/*
 * excel.rename(String 'existingSheetName', String 'newSheetName');
 * existingSheetName should exist in excel.tables.keys in order to successfully rename
 *
 */

excel.rename('existingSheetName', 'newSheetName');

Delete sheet

/*
 * excel.delete(String 'existingSheetName');
 * (existingSheetName should exist in excel.tables.keys) and (excel.tables.keys.length >= 2), in order to successfully delete.
 *
 */

excel.delete('existingSheetName');

Link sheet

/*
 * excel.link(String 'sheetName', Sheet sheetObject);
 *
 * Any operations performed on (object of 'sheetName') or sheetObject then the operation is performed on both.
 * if 'sheetName' does not exist then it will be automatically created and linked with the sheetObject's operation.
 *
 */

excel.link('sheetName', sheetObject);

Un-Link sheet

/*
 * excel.unLink(String 'sheetName');
 * In order to successfully unLink the 'sheetName' then it must exist in excel.tables.keys
 *
 */

excel.unLink('sheetName');

// After calling the above function be sure to re-make a new reference of this.

Sheet unlinked_sheetObject = excel['sheetName'];

Merge Cells

/*
 * sheetObject.merge(CellIndex starting_cell, CellIndex ending_cell, TextCellValue('customValue'));
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * starting_cell and ending_cell can be identified with Cell Address or by 2D array having row and column Index;
 * customValue is optional
 */

sheetObject.merge(CellIndex.indexByString('A1'), CellIndex.indexByString('E4'), customValue: TextCellValue('Put this text after merge'));

Get Merged Cells List

// Check which cells are merged

sheetObject.spannedItems.forEach((cells) {
  print('Merged:' + cells.toString());
});

Un-Merge Cells

/*
 * sheetObject.unMerge(cell);
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * cell should be identified with string only with an example as 'A1:E4'.
 * to check if 'A1:E4' is un-merged or not
 * call the method excel.getMergedCells(sheet); and verify that it is not present in it.
 */

sheetObject.unMerge('A1:E4');

Find and Replace

/*
 * int replacedCount = sheetObject.findAndReplace(source, target);
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * source is the string or ( User's Custom Pattern Matching RegExp )
 * target is the string which is put in cells in place of source
 *
 * it returns the number of replacements made
 */

int replacedCount = sheetObject.findAndReplace('Flutter', 'Google');

Insert Row Iterables

/*
 * sheetObject.insertRowIterables(list-iterables, rowIndex, iterable-options?);
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * list-iterables === list of iterables which has to be put in specific row
 * rowIndex === the row in which the iterables has to be put
 * Iterable options are optional
 */

/// It will put the list-iterables in the 8th index row
List<CellValue> dataList = [TextCellValue('Google'), TextCellValue('loves'), TextCellValue('Flutter'), TextCellValue('and'), TextCellValue('Flutter'), TextCellValue('loves'), TextCellValue('Excel')];

sheetObject.insertRowIterables(dataList, 8);

Iterable Options

key	description
startingColumn	starting column index from which list-iterables should be started
overwriteMergedCells	overwriteMergedCells is by-defalut set to `true`, when set to `false` it will stop over-write and will write only in unique cells

Append Row

/*
 * sheetObject.appendRow(list-iterables);
 * sheetObject created by calling - // Sheet sheetObject = excel['SheetName'];
 * list-iterables === list of iterables
 */

sheetObject.appendRow([TextCellValue('Flutter'), TextCellValue('till'), TextCellValue('Eternity')]);

Get Default Opening Sheet

/*
 * method which returns the name of the default sheet
 * excel.getDefaultSheet();
 */

var defaultSheet = excel.getDefaultSheet();
print('Default Sheet:' + defaultSheet.toString());

Set Default Opening Sheet

/*
 * method which sets the name of the default sheet
 * returns bool if successful then true else false
 * excel.setDefaultSheet(sheet);
 * sheet = 'SheetName'
 */

var isSet = excel.setDefaultSheet(sheet);
if (isSet) {
  print('$sheet is set to default sheet.');
} else {
  print('Unable to set $sheet to default sheet.');
}

📊 Charts

Excel Community supports creating various types of charts in your Excel files. Each chart type comes with automatic color schemes for professional-looking visualizations.

Available Chart Types

📈 ColumnChart - Vertical bar charts
📉 BarChart - Horizontal bar charts
📊 LineChart - Line charts with markers
🏞️ AreaChart - Area charts with fill
🍰 PieChart - Pie charts
🍩 DoughnutChart - Doughnut charts (pie with center hole)
✨ ScatterChart - Scatter/XY charts
🕸️ RadarChart - Radar/spider charts (with filled option)

📝 Basic Chart Example

// Create an Excel file and add data
var excel = Excel.createExcel();
var sheet = excel['Sheet1'];

// Add headers
sheet.updateCell(CellIndex.indexByString("A1"), TextCellValue("Month"));
sheet.updateCell(CellIndex.indexByString("B1"), TextCellValue("Sales"));
sheet.updateCell(CellIndex.indexByString("C1"), TextCellValue("Expenses"));

// Add data
final months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun'];
final sales = [45, 55, 42, 60, 58, 65];
final expenses = [35, 48, 52, 45, 62, 55];

for (var i = 0; i < months.length; i++) {
  sheet.updateCell(
    CellIndex.indexByColumnRow(columnIndex: 0, rowIndex: i + 1),
    TextCellValue(months[i]),
  );
  sheet.updateCell(
    CellIndex.indexByColumnRow(columnIndex: 1, rowIndex: i + 1),
    IntCellValue(sales[i]),
  );
  sheet.updateCell(
    CellIndex.indexByColumnRow(columnIndex: 2, rowIndex: i + 1),
    IntCellValue(expenses[i]),
  );
}

// Create a chart
var chart = ColumnChart(
  title: "Monthly Sales vs Expenses",
  series: [
    ChartSeries(
      name: "Sales",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$B$2:$B$7",
    ),
    ChartSeries(
      name: "Expenses",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$C$2:$C$7",
    ),
  ],
  anchor: ChartAnchor.at(column: 4, row: 1, width: 12, height: 16),
  showLegend: true,
);

// Add chart to sheet
sheet.addChart(chart);

// Save the file
var bytes = excel.save();

📈 Column Chart

Vertical bar chart ideal for comparing values across categories.

var chart = ColumnChart(
  title: "Sales by Quarter",
  series: [
    ChartSeries(
      name: "Q1",
      categoriesRange: r"Sheet1!$A$2:$A$5",
      valuesRange: r"Sheet1!$B$2:$B$5",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1, width: 10, height: 15),
  showLegend: true,
);

sheet.addChart(chart);

📉 Bar Chart

Horizontal bar chart, better for longer category labels.

var chart = BarChart(
  title: "Revenue by Product",
  series: [
    ChartSeries(
      name: "Revenue",
      categoriesRange: r"Sheet1!$A$2:$A$10",
      valuesRange: r"Sheet1!$B$2:$B$10",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1),
);

sheet.addChart(chart);

📊 Line Chart

Line chart with markers, ideal for showing trends over time.

var chart = LineChart(
  title: "Website Traffic Trends",
  series: [
    ChartSeries(
      name: "Visitors",
      categoriesRange: r"Sheet1!$A$2:$A$13",
      valuesRange: r"Sheet1!$B$2:$B$13",
    ),
    ChartSeries(
      name: "Page Views",
      categoriesRange: r"Sheet1!$A$2:$A$13",
      valuesRange: r"Sheet1!$C$2:$C$13",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1, width: 12, height: 15),
);

sheet.addChart(chart);

🏞️ Area Chart

Area chart with colored fill, useful for showing cumulative values.

var chart = AreaChart(
  title: "Cumulative Growth",
  series: [
    ChartSeries(
      name: "Product A",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$B$2:$B$7",
    ),
    ChartSeries(
      name: "Product B",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$C$2:$C$7",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1),
);

sheet.addChart(chart);

🍰 Pie Chart

Pie chart for showing proportions. Uses only one series.

var chart = PieChart(
  title: "Market Share",
  series: [
    ChartSeries(
      name: "Share",
      categoriesRange: r"Sheet1!$A$2:$A$6",
      valuesRange: r"Sheet1!$B$2:$B$6",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1, width: 10, height: 15),
  showLegend: true,
);

sheet.addChart(chart);

🍩 Doughnut Chart

Similar to pie chart but with a center hole.

var chart = DoughnutChart(
  title: "Department Budget",
  series: [
    ChartSeries(
      name: "Budget",
      categoriesRange: r"Sheet1!$A$2:$A$8",
      valuesRange: r"Sheet1!$B$2:$B$8",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1),
);

sheet.addChart(chart);

✨ Scatter Chart

Scatter/XY chart for showing correlations between two variables.

var chart = ScatterChart(
  title: "Price vs Demand",
  series: [
    ChartSeries(
      name: "Products",
      categoriesRange: r"Sheet1!$A$2:$A$20",  // X values
      valuesRange: r"Sheet1!$B$2:$B$20",      // Y values
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1, width: 12, height: 15),
);

sheet.addChart(chart);

🕸️ Radar Chart

Radar/spider chart for multivariate data. Can be filled or lines-only.

// Filled radar chart
var chart = RadarChart(
  title: "Performance Metrics",
  series: [
    ChartSeries(
      name: "Employee A",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$B$2:$B$7",
    ),
    ChartSeries(
      name: "Employee B",
      categoriesRange: r"Sheet1!$A$2:$A$7",
      valuesRange: r"Sheet1!$C$2:$C$7",
    ),
  ],
  anchor: ChartAnchor.at(column: 5, row: 1),
  filled: true,  // Set to false for lines only
);

sheet.addChart(chart);

Chart Positioning with ChartAnchor

The ChartAnchor defines where and how large your chart appears on the worksheet.

// Simple positioning with automatic sizing
ChartAnchor.at(
  column: 5,      // Starting column (0-indexed)
  row: 1,         // Starting row (0-indexed)
  width: 10,      // Width in columns (default: 8)
  height: 15,     // Height in rows (default: 15)
)

// Or specify exact positions
ChartAnchor(
  fromColumn: 5,
  fromRow: 1,
  toColumn: 15,   // End column
  toRow: 16,      // End row
)

Multiple Charts

You can add multiple charts to the same sheet or different sheets.

var sheet1 = excel['Sales'];
var sheet2 = excel['Analysis'];

// Add first chart to Sales sheet
sheet1.addChart(ColumnChart(
  title: "Monthly Sales",
  series: [...],
  anchor: ChartAnchor.at(column: 5, row: 1),
));

// Add second chart to Sales sheet
sheet1.addChart(LineChart(
  title: "Sales Trend",
  series: [...],
  anchor: ChartAnchor.at(column: 5, row: 18),
));

// Add chart to Analysis sheet
sheet2.addChart(PieChart(
  title: "Distribution",
  series: [...],
  anchor: ChartAnchor.at(column: 2, row: 2),
));

Chart Colors

Charts automatically use a professional 12-color palette:

#4472C4 - Blue
#ED7D31 - Orange
#70AD47 - Green
#FFC000 - Gold
#5B9BD5 - Light Blue
#C5504B - Red
#8064A2 - Purple
#4BACC6 - Cyan
#9BBB59 - Olive
#F79646 - Light Orange
#17B897 - Teal
#E83352 - Crimson

Colors are automatically assigned to each series. If you have more than 12 series, colors will repeat.

For more details about chart colors and customization, see the CHART_COLORS_GUIDE.md file.

Important Notes

Range Format: Use Excel's absolute reference format for ranges (e.g., r"Sheet1!$A$2:$A$10")
Pie/Doughnut Charts: These typically use only one series
Multiple Series: Column, Bar, Line, Area, Scatter, and Radar charts support multiple series
Chart Title: The title parameter is optional but recommended for clarity
Legend: Set showLegend: false to hide the chart legend

💾 Saving

On Flutter Web

// when you are in flutter web then save() downloads the excel file.

// Call function save() to download the file
var fileBytes = excel.save(fileName: 'My_Excel_File_Name.xlsx');

On Android / iOS

For getting saving directory on Android or iOS, Use: path_provider

var fileBytes = excel.save();
var directory = await getApplicationDocumentsDirectory();

File(join('$directory/output_file_name.xlsx'))
  ..createSync(recursive: true)
  ..writeAsBytesSync(fileBytes);

Credits

This project is based on the excel package created by Kawaljeet Singh (justkawal).

We are grateful for the original work and continue to maintain and enhance this library for the community.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Original Author: Kawaljeet Singh (justkawal)
Original Project: https://github.com/justkawal/excel

Current Maintainer: DecksPlayer
Community Fork: https://github.com/DecksPlayer/excel_community

Donation

If you find this package helpful and want to support its development, consider making a donation. Thank you for your support!

Name		Name	Last commit message	Last commit date
Latest commit History 390 Commits
.github		.github
example		example
excel_flutter_example		excel_flutter_example
lib		lib
test		test
xl/charts		xl/charts
.gitignore		.gitignore
.metadata		.metadata
CHANGELOG.md		CHANGELOG.md
CHART_COLORS_GUIDE.md		CHART_COLORS_GUIDE.md
CLEAN_CODE_ARCHITECTURE.md		CLEAN_CODE_ARCHITECTURE.md
LICENSE		LICENSE
README.md		README.md
pubspec.yaml		pubspec.yaml

Folders and files

Latest commit

History

Repository files navigation

Excel Community

Excel Community is a flutter and dart library for reading, creating and updating excel-sheets for XLSX files.

Features

Road-map:

📋 Breaking Changes

Breaking changes from 4.x.x to 5.x.x

Breaking changes from 3.x.x to 4.x.x

Breaking changes from 2.x.x to 3.x.x

If you find this tool useful, please drop a ⭐️

📖 Usage

📄 Read XLSX File

🌐 Read XLSX in Flutter Web

📂 Read XLSX from Flutter's Asset Folder

➕ Create New XLSX File

✏️ Update Cell Values

🎨 Cell-Style Options

🔲 Borders

Make sheet RTL

Copy sheet contents to another sheet

Rename sheet

Delete sheet

Link sheet

Un-Link sheet

Merge Cells

Get Merged Cells List

Un-Merge Cells

Find and Replace

Insert Row Iterables

Iterable Options

Append Row

Get Default Opening Sheet

Set Default Opening Sheet

📊 Charts

Available Chart Types

📝 Basic Chart Example

📈 Column Chart

📉 Bar Chart

📊 Line Chart

🏞️ Area Chart

🍰 Pie Chart

🍩 Doughnut Chart

✨ Scatter Chart

🕸️ Radar Chart

Chart Positioning with ChartAnchor

Multiple Charts

Chart Colors

Important Notes

💾 Saving

On Flutter Web

On Android / iOS

Credits

License

Donation

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages