exceltoanything 0.1.1

  • Readme
  • Changelog
  • Example
  • Installing
  • 38

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.

[0.0.1] - Initial Release on 28th May 2020 #

[0.1.0] - First version launched on 28th May 2020 #

[0.1.1] - Fixed format specifications and readme changes #

example/main.dart

import 'package:flutter/material.dart';

import 'home.dart';

void main() => runApp(MyApp());

class MyApp extends StatelessWidget {
  // This widget is the root of your application.
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Flutter Demo',
      theme: ThemeData(
        // This is the theme of your application.
        //
        // Try running your application with "flutter run". You'll see the
        // application has a blue toolbar. Then, without quitting the app, try
        // changing the primarySwatch below to Colors.green and then invoke
        // "hot reload" (press "r" in the console where you ran "flutter run",
        // or simply save your changes to "hot reload" in a Flutter IDE).
        // Notice that the counter didn't reset back to zero; the application
        // is not restarted.
        primarySwatch: Colors.blue,
      ),
      home: Home(),
    );
  }
}

Use this package as a library

1. Depend on it

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


dependencies:
  exceltoanything: ^0.1.1

2. Install it

You can install packages from the command line:

with pub:


$ pub get

with Flutter:


$ flutter pub get

Alternatively, your editor might support pub get or flutter pub get. Check the docs for your editor to learn more.

3. Import it

Now in your Dart code, you can use:


import 'package:exceltoanything/exceltoanything.dart';
  
Popularity:
Describes how popular the package is relative to other packages. [more]
10
Health:
Code health derived from static analysis. [more]
55
Maintenance:
Reflects how tidy and up-to-date the package is. [more]
80
Overall:
Weighted score of the above. [more]
38
Learn more about scoring.

We analyzed this package on Jul 9, 2020, and provided a score, details, and suggestions below. Analysis was completed with status completed using:

  • Dart: 2.8.4
  • pana: 0.13.13
  • Flutter: 1.17.5

Health issues and suggestions

Fix lib/Excelifiers.dart. (-43.75 points)

Analysis of lib/Excelifiers.dart failed with 2 errors:

line 15 col 42: The named parameter 'update' isn't defined.

line 61 col 42: The named parameter 'update' isn't defined.

Document public APIs. (-1 points)

9 out of 9 API elements have no dartdoc comment.Providing good documentation for libraries, classes, functions, and other API elements improves code readability and helps developers find and use your API.

Maintenance issues and suggestions

No valid SDK. (-20 points)

The analysis could not detect a valid SDK that can use this package.

Dependencies

Package Constraint Resolved Available
Direct dependencies
Dart SDK >=2.1.0 <3.0.0
excel ^1.0.3 1.1.0
file_picker ^1.9.0+1 1.12.0
flutter 0.0.0
path_provider ^1.6.9 1.6.11
sqflite ^1.3.0 1.3.1
Transitive dependencies
archive 2.0.13
args 1.6.0
charcode 1.1.3
collection 1.14.12 1.14.13
convert 2.1.1
crypto 2.1.5
file 5.2.1
file_picker_platform_interface 1.2.0
flutter_plugin_android_lifecycle 1.0.8
intl 0.16.1
meta 1.1.8 1.2.1
path 1.7.0
path_provider_linux 0.0.1+2
path_provider_macos 0.0.4+3
path_provider_platform_interface 1.0.2
petitparser 3.0.4
platform 2.2.1
plugin_platform_interface 1.0.2
process 3.0.13
sky_engine 0.0.99
sqflite_common 1.0.2+1
synchronized 2.2.0+1
typed_data 1.1.6 1.2.0
vector_math 2.0.8 2.1.0-nullsafety
xdg_directories 0.1.0
xml 4.2.0
Dev dependencies
flutter_test