spreadsheet_decoder 0.3.2 copy "spreadsheet_decoder: ^0.3.2" to clipboard
spreadsheet_decoder: ^0.3.2 copied to clipboard

outdatedDart 1 only

Spreadsheet files decoder

Spreadsheet Decoder #

Build Status Coverage Status Pub version

Spreadsheet Decoder is a library for decoding spreadsheets for ODS and XLSX files.

Usage #

On server-side #

import 'dart:io';
import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';

main() {
  var bytes = new File.fromUri(fullUri).readAsBytesSync();
  var decoder = new SpreadsheetDecoder.decodeBytes(bytes);
  var table = decoder.tables['Sheet1'];
  var values = table.rows[0];
  ...
}

On client-side #

import 'dart:html';
import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';

main() {
  var reader = new FileReader();
  reader.onLoadEnd.listen((event) {
    var decoder = new SpreadsheetDecoder.decodeBytes(reader.result);
    var table = decoder.tables['Sheet1'];
    var values = table.rows[0];
    ...
  });
}

Features not yet supported #

This implementation doesn't support following features:

  • annotations
  • spanned rows
  • spanned columns
  • hidden rows (visible in resulting tables)
  • hidden columns (visible in resulting tables)

For XLSX format, this implementation only supports native Excel format for date, time and boolean type conversion. In other words, custom format for date, time, boolean aren't supported and then file exported from LibreOffice as well.

106
likes
0
pub points
93%
popularity

Publisher

unverified uploader

Spreadsheet files decoder

Repository (GitHub)
View/report issues

License

unknown (LICENSE)

Dependencies

archive, xml

More

Packages that depend on spreadsheet_decoder