spreadsheet_decoder
所属分类：智慧办公
开发工具：Dart
文件大小：175KB
下载次数：0
上传日期：2023-04-12 11:23:47
上 传 者：
sh-1993
说明： 电子表格解码器是一个用于解码ODS和XLSX文件的电子表格的库。
(Spreadsheet Decoder is a library for decoding spreadsheets for ODS and XLSX files.)
文件列表:
.travis.yml (79, 2023-02-15)
CHANGELOG.md (1041, 2023-02-15)
LICENSE (1091, 2023-02-15)
analysis_options.yaml (40, 2023-02-15)
bin (0, 2023-02-15)
bin\dump_content.dart (336, 2023-02-15)
example (0, 2023-02-15)
example\spreadsheet_decoder.dart (1377, 2023-02-15)
lib (0, 2023-02-15)
lib\spreadsheet_decoder.dart (223, 2023-02-15)
lib\src (0, 2023-02-15)
lib\src\ods.dart (10680, 2023-02-15)
lib\src\spreadsheet.dart (7584, 2023-02-15)
lib\src\xlsx.dart (16723, 2023-02-15)
pubspec.yaml (325, 2023-02-15)
test (0, 2023-02-15)
test\common.dart (41297, 2023-02-15)
test\common_html.dart (119109, 2023-02-15)
test\common_io.dart (617, 2023-02-15)
test\files (0, 2023-02-15)
test\files\absolute_target.xlsx (5093, 2023-02-15)
test\files\default.ods (6811, 2023-02-15)
test\files\default.xlsx (8746, 2023-02-15)
test\files\empty_column.ods (7891, 2023-02-15)
test\files\empty_column.xlsx (4698, 2023-02-15)
test\files\format.ods (9107, 2023-02-15)
test\files\format.xlsx (9181, 2023-02-15)
test\files\numbers_to_xlsx.xlsx (6330, 2023-02-15)
test\files\perl.ods (10355, 2023-02-15)
test\files\perl.xlsx (7103, 2023-02-15)
test\files\phonetic.xlsx (9554, 2023-02-15)
test\files\test.ods (10107, 2023-02-15)
test\files\test.xlsx (8268, 2023-02-15)
test\files\unsupported.zip (160, 2023-02-15)
test\html_test.dart (318, 2023-02-15)
test\io_test.dart (311, 2023-02-15)
tool (0, 2023-02-15)
... ...
# Spreadsheet Decoder
[](https://travis-ci.org/sestegra/spreadsheet_decoder?branch=master)
[](https://coveralls.io/r/sestegra/spreadsheet_decoder?branch=master)
[](https://pub.dartlang.org/packages/spreadsheet_decoder)
Spreadsheet Decoder is a library for decoding and updating spreadsheets for ODS and XLSX files.
## Usage
### On server-side
import 'dart:io';
import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';
main() {
var bytes = File.fromUri(fullUri).readAsBytesSync();
var decoder = SpreadsheetDecoder.decodeBytes(bytes);
var table = decoder.tables['Sheet1'];
var values = table.rows[0];
...
decoder.updateCell('Sheet1', 0, 0, 1337);
File(join(fullUri).writeAsBytesSync(decoder.encode());
...
}
### On client-side
import 'dart:html';
import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';
main() {
var reader = FileReader();
reader.onLoadEnd.listen((event) {
var decoder = SpreadsheetDecoder.decodeBytes(reader.result);
var table = decoder.tables['Sheet1'];
var values = table.rows[0];
...
decoder.updateCell('Sheet1', 0, 0, 1337);
var bytes = decoder.encode();
...
});
}
## 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.
## License
The MIT License, see [LICENSE](https://github.com/sestegra/spreadsheet_decoder/raw/master/LICENSE).
近期下载者：
相关文件：
收藏者：