A package that allows you to transform your excel to the following format:
- Excel To JSON
- Excel to SQLite
At current the package allows you to use the following two functions (note: currently xlsx file type gives perfect results):
- automatically lets you pick an excel file and returns a string containing the entire converted json<br /><br />
- lets you choose an excel file<br />
- also creates a db for you if dbExist is set to false,note that here dbName has to be given<br />
- create a table for you using the given header and automatically interprets the required data-type based on the rows of the data<br />
- parameters: tableName is required<br />
- note the primary key is set as the first column by default<br />
For implementation have a look at the attached example file in the github repository.
Add this to your package's pubspec.yaml
file:
dependencies:
exceltoanything: ^0.0.1
You can install packages from the command line:
with pub
:
$ pub get
with Flutter
:
$ flutter packages get
Now in your Dart
code, you can use:
import 'package:exceltoanything/exceltoanything.dart';
Currently Working On:-
1. Allowing update queries to already uploaded excel files
2. Converting given excel to pdf
3. incorporating more file types such as csv.
4. Allowing more data types currently supports TEXT,REAL,NULL AND INTEGER
This package depends on several other packages such as Excel,Path Provider,
SQFLITE,File Picker. A great thanks to these packages as well for an improved implementation
This project is a starting point for a Dart package, a library module containing code that can be shared easily across multiple Flutter or Dart projects.
For help getting started with Flutter, view our online documentation, which offers tutorials, samples, guidance on mobile development, and a full API reference.