exceltoanything

Description:

exceltoanything

exceltoanything #
A package that allows you to transform your excel to the following format:

Excel To JSON
Excel to SQLite

Getting Started #
At current the package allows you to use the following two functions (note: currently xlsx file type gives perfect results):
1.excelToJson() #
- automatically lets you pick an excel file and returns a string containing the entire converted json<br /><br />
copied to clipboard
2.excelToSql({@required tableName,Database db,dbExist=true,tableExist=false,dbName}) #
- 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 />
copied to clipboard

For implementation have a look at the attached example file in the github repository.
Installing #
1. Depend on it #
Add this to your package's pubspec.yaml file:
dependencies:
exceltoanything: ^0.0.1
copied to clipboard
2. Install it #
You can install packages from the command line:
with pub:
$ pub get
copied to clipboard
with Flutter:
$ flutter packages get
copied to clipboard
3. Import it #
Now in your Dart code, you can use:
import 'package:exceltoanything/exceltoanything.dart';
copied to clipboard
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.