Will there be any new method added to write cells ? Because of restriction placed on updateCell only those cells with existing values can be replaced. What to do when have to write cells which do not have any value?

I converted this package to NNBD. I can provide a PR, however publishing will be only possible once archive has been converted which still is blocked by crypto, which needs to be converted first.

See https://github.com/sma/spreadsheet_decoder/tree/nullsafety

thank you! when i decode a new created empty xlsx, and then insertRow() or insertColumn()， it will cause a exception, because the SpreadsheetTable's _maxRows and _maxCols's initial value is -1, but not 0, so the "if (rowIndex < 0 || rowIndex > _tables[sheet]._maxRows)" will always be true.

E/flutter (15982): #0      ZipDirectory._findSignature (package:archive/src/zip/zip_directory.dart:149:5)
E/flutter (15982): #1      new ZipDirectory.read (package:archive/src/zip/zip_directory.dart:28:20)
E/flutter (15982): #2      ZipDecoder.decodeBuffer (package:archive/src/zip_decoder.dart:21:30)
E/flutter (15982): #3      ZipDecoder.decodeBytes (package:archive/src/zip_decoder.dart:15:12)
E/flutter (15982): #4      new SpreadsheetDecoder.decodeBytes (package:spreadsheet_decoder/src/spreadsheet.dart:75:32)
E/flutter (15982): #5      _LoginPageState.readData (package:studentsocialgooglecalendar/login_page.dart:27:38)
E/flutter (15982): #6      _LoginPageState.readFileSync (package:studentsocialgooglecalendar/login_page.dart:20:5)
E/flutter (15982): <asynchronous suspension>
E/flutter (15982): #7      _LoginPageState.build.<anonymous closure> (package:studentsocialgooglecalendar/login_page.dart:58:11)
E/flutter (15982): #8      _InkResponseState._handleTap (package:flutter/src/material/ink_well.dart:706:14)
E/flutter (15982): #9      _InkResponseState.build.<anonymous closure> (package:flutter/src/material/ink_well.dart:789:36)
E/flutter (15982): #10     GestureRecognizer.invokeCallback (package:flutter/src/gestures/recognizer.dart:182:24)
E/flutter (15982): #11     TapGestureRecognizer.handleTapUp (package:flutter/src/gestures/tap.dart:486:11)
E/flutter (15982): #12     BaseTapGestureRecognizer._checkUp (package:flutter/src/gestures/tap.dart:264:5)
E/flutter (15982): #13     BaseTapGestureRecognizer.handlePrimaryPointer (package:flutter/src/gestures/tap.dart:199:7)
E/flutter (15982): #14     PrimaryPointerGestureRecognizer.handleEvent (package:flutter/src/gestures/recognizer.dart:467:9)
E/flutter (15982): #15     PointerRouter._dispatch (package:flutter/src/gestures/pointer_router.dart:76:12)
E/flutter (15982): #16     PointerRouter._dispatchEventToRoutes.<anonymous closure> (package:flutter/src/gestures/pointer_router.dart:117:9)
E/flutter (15982): #17     _LinkedHashMapMixin.forEach (dart:collection-patch/compact_hash.dart:379:8)
E/flutter (15982): #18     PointerRouter._dispatchEventToRoutes (package:flutter/src/gestures/pointer_router.dart:115:18)
E/flutter (15982): #19     PointerRouter.route (package:flutter/src/gestures/pointer_router.dart:101:7)
E/flutter (15982): #20     GestureBinding.handleEvent (package:flutter/src/gestures/binding.dart:218:19)
E/flutter (15982): #21     GestureBinding.dispatchEvent (package:flutter/src/gestures/binding.dart:198:22)
E/flutter (15982): #22     GestureBinding._handlePointerEvent (package:flutter/src/gestures/binding.dart:156:7)
E/flutter (15982): #23     GestureBinding._flushPointerEventQueue (package:flutter/src/gestures/binding.dart:102:7)
E/flutter (15982): #24     GestureBinding._handlePointerDataPacket (package:flutter/src/gestures/binding.dart:86:7)
E/flutter (15982): #25     _rootRunUnary (dart:async/zone.dart:1138:13)
E/flutter (15982): #26     _CustomZone.runUnary (dart:async/zone.dart:1031:19)
E/flutter (15982): #27     _CustomZone.runUnaryGuarded (dart:async/zone.dart:933:7)
E/flutter (15982): #28     _invoke1 (dart:ui/hooks.dart:273:10)
E/flutter (15982): #29     _dispatchPointerDataPacket (dart:ui/hooks.dart:182:5)
E/flutter (15982): 

I'm getting this exception in Line 288 of xlsx.dart when trying to read a .xlsx that has been exported from Apple Numbers. The code expects a <worksheet> element as the last child of the loaded document, but the last child is a Text with a \n.

A more robust approach could be to search for the element instead of assuming it is always the last one:

var workbench = content.findElements('worksheet').first;

Hi,

If I run the example/spreadsheet_decoder.dart with archive 3.2.1 I get the error:

Unhandled exception:
type 'Null' is not a subtype of type 'List<int>' in type cast
#0      ZipEncoder.getFileCrc32 (package:archive/src/zip_encoder.dart:91:34)
#1      ZipEncoder.addFile (package:archive/src/zip_encoder.dart:136:15)
#2      ZipEncoder.encode (package:archive/src/zip_encoder.dart:65:7)
#3      SpreadsheetDecoder.encode (package:spreadsheet_decoder/src/spreadsheet.dart:175:25)
#4      main (file:///home/adrian/Documents/repos/git/other/spreadsheet_decoder/example/spreadsheet_decoder.dart:34:32)
#5      _delayEntrypointInvocation.<anonymous closure> (dart:isolate-patch/isolate_patch.dart:295:32)
#6      _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:192:12)

Example works with archive version 3.1.10. Not sure if there is a quick fix or something we should report to the archive package maintainers.

Thanks, Tony

HI , I am trying to read rows from excel file which in selected from Html page and give to spreadsheet decoder , but nothing is come later .

Step1 : this how i got file . InputElement uploadInput = FileUploadInputElement(); uploadInput.click(); uploadInput.multiple = false; uploadInput.draggable = true; uploadInput.onChange.listen((e) { // read file content as dataURL final files = uploadInput.files; final file = files[0]; });

Step 2 :

final reader = new FileReader(); reader.onLoadEnd.listen((e) { var bytes = reader.result;

Logs.debug("process 1"); var decoder = Excel.decodeBytes(bytes, verify: true); // FROM HERE NOTHING , Logs.debug("process 2"); print("************************************************************"); for (var table in decoder.tables.keys) { Logs.debug(table); Logs.debug("${decoder.tables[table].maxCols}"); Logs.debug("${decoder.tables[table].maxRows}"); for (var row in decoder.tables[table].rows) { Logs.debug("$row"); } } }); reader.readAsDataUrl(file);

after the log "process1" nothing is happening,

please help me out

Problem

Some excel library (for example, Styleframe as python library) outputs excel file which contains xl/_rels/workbook.xml.rels file's Target differently as follows.

With the current spreadsheet_decoder, it generates error.

How to reproduce

To generate excel file which has the problem, execute the following python file.

from styleframe import StyleFrame
from datetime import date


sf = StyleFrame({
    'a': [1],
    'b': [2],
})


ew = StyleFrame.ExcelWriter(r'data.xlsx')
sf.to_excel(ew, 'sheet1')
ew.save()

With the above file, run the following command.

$ pip install styleframe 
$ python convert.py

There will be "data.xlsx" in the same directory.

When read the above file with the current spreadsheet_decoder, it says the following error. You can use the following file and command to generate the error.

import 'dart:io';

import 'package:spreadsheet_decoder/spreadsheet_decoder.dart';

Future<void> main(List<String> arguments) async {
  final tmp = 'data.xlsx';
  final bytes = File(tmp).readAsBytesSync();
  final decoder = SpreadsheetDecoder.decodeBytes(bytes);
}

$ dart convert_excel.dart 
Unhandled exception:
type 'Null' is not a subtype of type 'List<int>'
#0      XlsxDecoder._parseTable (package:spreadsheet_decoder/src/xlsx.dart:314:49)
#1      XlsxDecoder._parseContent.<anonymous closure> (package:spreadsheet_decoder/src/xlsx.dart:301:7)
#2      Iterable.forEach (dart:core/iterable.dart:279:35)
#3      XlsxDecoder._parseContent (package:spreadsheet_decoder/src/xlsx.dart:300:39)
#4      new XlsxDecoder (package:spreadsheet_decoder/src/xlsx.dart:116:5)
#5      _newSpreadsheetDecoder (package:spreadsheet_decoder/src/spreadsheet.dart:39:14)
#6      new SpreadsheetDecoder.decodeBytes (package:spreadsheet_decoder/src/spreadsheet.dart:76:12)
#7      main (...)
#8      _delayEntrypointInvocation.<anonymous closure> (dart:isolate-patch/isolate_patch.dart:295:32)
#9      _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:192:12)```

How to fix

When Target has absolute path, the variable name namePath on the fixed code should not be with xl/$target but target.substring(1).

Related issue

https://github.com/OfficeDev/Open-XML-SDK/issues/88 https://github.com/tidyverse/readxl/issues/294

Hello,

I run into an issue while using another package that depends on xml ^4.1.0, while this package still runs on ^3.0.0. It would be nice if the xml version of this could be updated.

Here is the Exception that I get:

Because flutter_svg >=0.18.0 depends on xml ^4.1.0 and 
spreadsheet_decoder 1.1.0 depends on xml ^3.0.0, flutter_svg >=0.18.0 
is incompatible with spreadsheet_decoder 1.1.0.

And because no versions of spreadsheet_decoder match >1.1.0 <2.0.0, 
flutter_svg >=0.18.0 is incompatible with spreadsheet_decoder ^1.1.0.

Hello there

I've updated an excel sheet that includes cells that their values depend on those which have been updated (via a formula)

how to force the excel sheet to refresh and reflect the actual values of the cells depending on the updates done via the spreadsheet_decoder;

regards

Hi,

I would like to know how is possible to create a new xls file and fill it with values. I've seen an encode method, it can be used to encode xls file and then save to file?

Do you have any examples? to play on?

Thank you.

Hi, Thanks for a great plugin! I am loading excel with date/time fields, and I noticed that they are one hour later than they should. Like the wrong timezone is decoded. How it is possible ? Date value in the cell: 5/5/2021 6:38:00 AM is decoded in futter as:2021-05-05T07:38:00.000

I put the template Excel file in the asset folder and tested it.

sample codel:

  var _excel = SpreadsheetDecoder.decodeBytes(bytes, update: true);

  String sheet = _excel.tables.keys.first; 
  print('Sheet:>>>>${sheet}');
  _excel
    ..updateCell(sheet, 0, 1, "aaaaaaaaaa")
    ..updateCell(sheet, 1, 1, 'bbbbbbbbbb')
    ..updateCell(sheet, 2, 1, 'cccccccccc')
    ..updateCell(sheet, 1, 2, 8880.3)
    ..insertRow(sheet, 1)
    ..insertRow(sheet, 20)
    ..updateCell(sheet, 0, 09, 'A14=========}')
    ..updateCell(sheet, 0, 15, 'A13---------}')
     ..insertColumn(sheet, 0);


  var b = _excel.encode();

Error:

Error: RangeError: Invalid value: Not in inclusive range 0..12: 20
    at Object.throw_ [as throw] (http://localhost:56557/dart_sdk.js:5063:11)
    at spreadsheet_decoder.XlsxDecoder.new.insertRow (http://localhost:56557/packages/spreadsheet_decoder/spreadsheet_decoder.dart.lib.js:227:19)
    at spreadsheet_decoder.XlsxDecoder.new.insertRow (http://localhost:56557/packages/spreadsheet_decoder/spreadsheet_decoder.dart.lib.js:855:13)
    at http://localhost:56557/packages/pronto/pages/base_product_page/excel_upload/product_excel_repository.dart.lib.js:198:12
    at testexcel (http://localhost:56557/packages/pronto/pages/base_product_page/excel_upload/product_excel_repository.dart.lib.js:203:9)
    at testexcel.next (<anonymous>)
    at http://localhost:56557/dart_sdk.js:40192:33
    at _RootZone.runUnary (http://localhost:56557/dart_sdk.js:40062:59)
    at _FutureListener.thenAwait.handleValue (http://localhost:56557/dart_sdk.js:34983:29)
    at handleValueCallback (http://localhost:56557/dart_sdk.js:35551:49)
    at Function._propagateToListeners (http://localhost:56557/dart_sdk.js:35589:17)
    at _Future.new.[_completeWithValue] (http://localhost:56557/dart_sdk.js:35437:23)
    at async._AsyncCallbackEntry.new.callback (http://localhost:56557/dart_sdk.js:35458:35)
    at Object._microtaskLoop (http://localhost:56557/dart_sdk.js:40330:13)
    at _startMicrotaskLoop (http://localhost:56557/dart_sdk.js:40336:13)
    at http://localhost:56557/dart_sdk.js:35811:9
ProductCount:168

Hi ,

I am trying to save some values in the excel sheet as numbers that will later be used in Formulas. I am using SpreadsheetDecoder in Dart . The problem is , I am able to save the data , but the data saved is in Text format and so it being text i am not able to use in Formula that need Number. The code I am using is provided below.

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

File file = File('FileToUpdate.xlsx'); List requiredRow; SpreadsheetDecoder decoder; Uint8List bytes; /* Row number (rowNum) for various values in excel sheet 'aValue':14 , int 'bValue':15 int 'cValue':16 double */ int rowNum = 14; int newValue = 5;

void main(List args) { bytes = file.readAsBytesSync(); decoder = SpreadsheetDecoder.decodeBytes(bytes, update: true); final table = decoder.tables['SheetName']; requiredRow = table.rows[rowNum]; var requiredValue = requiredRow[0] as String; print(requiredValue);

setValue(newValue);

final valueStored = getValue(); print(valueStored);

}

void setValue(int value) { decoder.updateCell('SheetToUpdate', 1, rowNum, value); File(join('FileToUpdate.xlsx')) ..createSync(recursive: true) ..writeAsBytesSync(decoder.encode()); }

String getValue() { String returnValue = requiredRow[1].toString(); return returnValue; }

Hello,

I am trying to parse an xlsx file on client right after selecting it on an input. I am following the steps suggested in readme file but it seems that the file is not loaded correctly into the archive.

My code: void onFileUpload(Event event) { final List<File> files = (event.target as InputElement).files; final File file = files[0]; final FileReader reader = FileReader(); reader.onLoad.listen((_) { var decoder = SpreadsheetDecoder.decodeBytes(reader.result); var table = decoder.tables['Sheet1']; var values = table.rows[0]; print(values); }); reader.readAsArrayBuffer(file); }

Note that the above code works for images, so i am pretty sure that this part is OK. The exception that I get: EXCEPTION: NoSuchMethodError: invalid member on null: 'decompress' STACKTRACE: package:spreadsheet_decoder/src/xlsx.dart 285:9 [_parseTable] package:spreadsheet_decoder/src/xlsx.dart 274:7 <fn> dart:sdk_internal 14797:11 forEach package:spreadsheet_decoder/src/xlsx.dart 273:30 [_parseContent] package:spreadsheet_decoder/src/xlsx.dart 110:5 new package:spreadsheet_decoder/src/spreadsheet.dart 38:14 _newSpreadsheetDecoder package:spreadsheet_decoder/src/spreadsheet.dart 76:12 decodeBytes

So, the problem is in xlsx.dart file, inside _parse table line 285, var file = _archive.findFile("xl/$target"); does not find the file in the archive and returns null.

BRs / Kostas