- Xlsx Template
- What Is Xlsx In Excel
- Excel 2003 Xlsx Compatibility
- Excel Xlsx To Xls Converter
- Free Microsoft Xlsx To Xls
Excel is a flutter and dart library for reading, creating and updating excel-sheets for XLSX files.
View and edit.xlsx,.xls,.csv,.tsv,.ods,.sxc files online, for free. View any Microsoft Excel or OpenOffice Calc file via Zoho Sheet. XLSX and XLS files are Microsoft Excel Spreadsheets commonly used to store financial data and to create mathematical models. These files store data in worksheets that contain cells arranged as a grid of rows and columns. Excel spreadsheets may also contain charts, mathematical functions, and various kinds of cell formatting. Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a green 'X' on a green-and-white background. If you already have an Excel document that contains your data, double-click the document to open it in Excel 2007, then skip ahead to finding the mean.
Also checkout our new animations library: AnimatedText
- 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 #
Create New XLSX File #
Update Cell values #
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 |
fontColorHex | Font Color eg. '#0000FF' |
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 |
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 #
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 |
Xlsx Template
Append Row #
Get Default Opening Sheet #
Set Default Opening Sheet #
Saving XLSX File #
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
What Is Xlsx In Excel
Features coming in next version #
On-going implementation for future:
Excel 2003 Xlsx Compatibility
- Formulas
- Password Protection
- Conversion to PDF
Excel Xlsx To Xls Converter
Donate (Be the first one) #
Free Microsoft Xlsx To Xls
Buy me some food to survive, I will add more features, If I remain alive.