exceltoanything

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

  1. Excel To JSON
  2. 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 />

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 />

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

2. Install it

You can install packages from the command line:

with pub:

$  pub get

with Flutter:

$  flutter packages get

3. Import it

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.

Libraries

Excelifiers
exceltoanything
globals