Skip to content
pubscout

spreadsheet_decoder

2.3.0, released 2 years ago by an unverified publisher

A lightweight library for parsing and updating ODS and XLSX spreadsheet documents.

WASM-ready
$ flutter pub add spreadsheet_decoder
Source repository

What it does

It allows developers to decode ODS and XLSX spreadsheet files into structured tables, access cell values, update specific cells, and encode them back into bytes. It supports both server-side and client-side environments.

AI-written summary of version 2.3.0, based on the package's README and metadata. Report an inaccuracy

Use it when

  • You need to read or update Excel (XLSX) or OpenDocument Spreadsheet (ODS) files in Dart.
  • You are working with spreadsheet data on either the client-side or server-side.

Skip it when

  • You need to parse complex spreadsheet features like annotations, spanned rows or columns, and hidden rows or columns.
  • You rely on custom formatting for dates, times, or booleans exported from non-native tools like LibreOffice.

Strengths

  • Supports both ODS and XLSX file formats.
  • Enables reading and updating spreadsheet cells.
  • Works in both server-side and client-side Dart environments.

Weaknesses

  • Does not support annotations, spanned rows/columns, or hidden rows/columns.
  • Limited support for custom date, time, and boolean formats in XLSX files.

Setup

Kind
Pure Dart
Effort
Low
Code generation
No
Direct dependencies
2

not documented

import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';

main() {
  var decoder = SpreadsheetDecoder.decodeBytes(bytes);
  var table = decoder.tables['Sheet1'];
  var values = table.rows[0];
  decoder.updateCell('Sheet1', 0, 0, 1337);
  var encodedBytes = decoder.encode();
}

Works with

Packages commonly used together with spreadsheet_decoder: ones it builds on, ones built on it, and its own family.