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