Posted  by  admin

Excel Package

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

Also checkout our new animations library: AnimatedText

Represents an Excel 2007/2010 XLSX file package. This is the top-level object to access all parts of the document. C# (CSharp) OfficeOpenXml ExcelPackage - 30 examples found. These are the top rated real world C# (CSharp) examples of OfficeOpenXml.ExcelPackage extracted from open source projects. You can rate examples to help us improve the quality of examples. The readxl package makes it easy to get data out of Excel and into R. Compared to many of the existing packages (e.g. Gdata, xlsx, xlsReadWrite) readxl has no external dependencies, so it’s easy to install and use on all operating systems. The package contains datasource to import data from Excel and a powerful engine to export data to Excel. If you store your data in several excel files, the excel package is able to load your data from those sources at once and produce a combination result. Then the result can be easily saved to another excel file.

  • Usage
    • Update Cell
    • Insert Row Iterables

1. Depend on it #

Add this to your package's pubspec.yaml file:

2. Install it #

You can install packages from the command line:

with pub:

with Flutter:

3. Import it #

Now in your Dart code, you can use:

Breaking Changes for those moving from 1.0.8 and below ----> 1.0.9 and above versions #

The necessary changes to be made to updateCell function in order to prevent the code from breaking.

Imports #

Read XLSX File #

Read XLSX from Flutter's Asset Folder #

Excel packaging equipment

Create New XLSX File #

Update Cell values #

Cell-Style Options #

keydescription
fontFamilyeg. getFontFamily(FontFamily.Arial) or getFontFamily(FontFamily.Comic_Sans_MS) There is total 182 Font Families available for now
fontSizespecify the font-size as integer eg. fontSize = 15
boldmakes text bold - when set to true, by-default it is set to false
italicmakes text italic - when set to true, by-default it is set to false
underlineGives underline to text enum Underline { None, Single, Double } eg. Underline.Single, by-default it is set to Underline.None
fontColorHexFont Color eg. '#0000FF'
backgroundColorHexBackground color of cell eg. '#faf487'
wrapText wrapping enum TextWrapping { WrapText, Clip } eg. TextWrapping.Clip
verticalAlignalign text vertically enum VerticalAlign { Top, Center, Bottom } eg. VerticalAlign.Top
horizontalAlignalign text horizontally enum HorizontalAlign { Left, Center, Right } eg. HorizontalAlign.Right

Copy sheet contents to another sheet #

Excel Package

Rename sheet #

Delete sheet #

Link sheet #

Un-Link sheet #

Merge Cells #

Get Merged Cells List #

Un-Merge Cells #

Find and Replace #

Insert Row Iterables #

Excel Package C#

Iterable Options #

keydescription
startingColumnstarting column index from which list-iterables should be started
overwriteMergedCellsoverwriteMergedCells is by-defalut set to true, when set to false it will stop over-write and will write only in unique cells

Append Row #

Get Default Opening Sheet #

Set Default Opening Sheet #

Open Excelpackage Tutorial

Saving XLSX File #

Package

Having Trouble using excel i.e: every version of some_other_library depends on version..... blah blah blah#

Similar issues have been solved in the past :#26, #25, #11

Excel

Features coming in next version #

Excel Package Tracker

On-going implementation for future:

  • Formulas
  • Password Protection
  • Conversion to PDF

Donate (Be the first one) #

Excel Package Tracking

Buy me some food to survive, I will add more features, If I remain alive.