editable 1.0.9

⚡️A highly customizable, editable data table (spreadsheet) package for Flutter projects.

Editable

⚡️A highly customizable, editable table package for Flutter projects.

Specs

This package allows you to create editable tables and spreadsheets with ease, either by providing inital row and column count to display an empty table, or use it with predefined rows and column data sets.

It is compatible with Flutter Desktop (Windows, Linux, MacOS), IOS, Android, and Web. ❤️

Features

• Save Edited Rows
• Save Edited cell
• Customize cell data
• Add Empty rows
• Create Empty tables
• Customizable Save button
• Customize Table headers

Spread Some ❤️

Support us

You can buy us a cup of coffee.

Getting started

In the pubspec.yaml of your flutter project, add the following dependency:

dependencies:
  ...
  editable: "^1.0.9"

In your library add the following import:

import 'package:editable/editable.dart';

API

Create Table

To create a new table, use the Editable() widget class and provide the table data properties as follows:

• column: an array of objects example example:

  List cols = [
    {"title":'Name', 'index': 1, 'key':'name'},
    {"title":'Date', 'index': 2, 'key':'date'},
    {"title":'Month', 'index': 3, 'key':'month'},
    {"title":'Status', 'index': 4, 'key':'status'},
  ]; 
  

  [title] is the column heading

  [index] represents a unique id for each column of type [int]

  [key] an identifyer preferably a short string

• rows: an array of objects, where each object key represents a column [key], example:

  List rows = [
    {"name": 'James Joe', "date":'23/09/2020',"month":'June',"status":'completed'}, 
    {"name": 'Daniel Paul', "date":'12/4/2020',"month":'March',"status":'new'}, 
  ];
  

  each objects should have its element positioned in same order as its column

• rowCount: Interger value of number of rows to be generated: Optional if row data is provided

• columnCount: Interger value of number of columns to be generated: Optional if column data is provided

• columnRatio: fraction of the screen width occupied by each column. This is usefull for shrinking and expanding table width example:

  columnRation: 0.8 //sets each column to occupy 80 percent of screen width
  

Customization

• borderColor: Color of table border
• borderWidth: width of table borders
• tdPaddingLeft: Table data cell padding left
• tdPaddingTop: Table data cell padding top
• tdPaddingRight: Table data cell padding right;
• tdPaddingBottom: Table data cell padding bottom;
• tdAlignment: Aligns the table data ;
• tdStyle: Style the table data;
• thPaddingLeft: Table header cell padding left;
• thPaddingTop: Table header cell padding top;
• thPaddingRight: Table header cell padding right;
• thPaddingBottom: Table header cell padding bottom;
• trHeight: Table Row Height, cannot be less than 40.0 ;
• thWeight: Table headers fontweight;
• thSize: Table headers fontSize;
• showSaveIcon: Toogles the save button, if [true] displays an icon to save rows, adds an addition column to the right
• saveIcon: Icon for to save row data, example: dart saveIcon : Icons.add
• saveIconColor: Color for the save Icon
• saveIconSize: Size for the saveIcon
• showCreateButton: displays a button that adds a new row onPressed
• createButtonAlign: Aligns the button for adding new rows;
• createButtonIcon: Icon displayed in the create new row button;
• createButtonColor: Color for the create new row button;
• createButtonShape: border shape of the create new row button createButtonShape: RoundedRectangleBorder( borderRadius: BorderRadius.circular(8) )
• createButtonLabel: Label for the create new row button

Save methods

• onSubmitted: [onSubmitted] callback is triggered when the enter button is tapped (for desktop users) Or when edit is complete(on mobile) on a table data cell it returns a value of the edited cell data

• onRowSaved: [onRowSaved] callback is triggered when a [saveButton] is pressed. returns only values if row is edited, otherwise returns a string ['no edit']

Screenshots

Editable Table with Data

Empty SpreadSheet

Table with Save Icon

Roadmap

The following are immediate work In progress for the next version of the project:

• Sortable column
• Perform mathematical operations between columns
• Search row data
• flexible column width customization
• export table to different formats

Contribution

I highly encourage the community to step forward and improve this library further. You can fix any reported bug, propose or implement new features, write tests, etc.

Here is a quick list of things to remember

• Check the open issues before creating a new one,
• Help me in reducing the number of open issues by fixing any existing bugs,
• Check the roadmap to see if you can help in implementing any new feature,
• You can contribute by writing unit and integration tests for this library,
• If you have any new idea that aligns with the goal of this library, feel free to raise a feature request and discuss it.

Author

This Editable table package for Flutter is developed by Godwin Asuquo

Also, as always, please give us a star to help!