@@ -242,10 +242,10 @@ worksheet.getRangeByName('C9').setText('Madrid');
242
242
worksheet.getRangeByName('C10').setText('Marseille');
243
243
244
244
// Intialize filter range.
245
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
245
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
246
246
247
247
// Add text filter.
248
- final AutoFilter autofilter = worksheet.autofilters [ 0] ;
248
+ final AutoFilter autofilter = worksheet.autoFilters [ 0] ;
249
249
autofilter.addTextFilter(<String >{'Owner'});
250
250
worksheet.getRangeByName('A1: C10 ').autoFitColumns();
251
251
@@ -298,8 +298,8 @@ worksheet.getRangeByName('C9').setText('Madrid');
298
298
worksheet.getRangeByName('C10').setText('Marseille');
299
299
300
300
// Intialize filter range.
301
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
302
- final AutoFilter autofilter = worksheet.autofilters [ 0] ;
301
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
302
+ final AutoFilter autofilter = worksheet.autoFilters [ 0] ;
303
303
304
304
// First condition.
305
305
final AutoFilterCondition firstCondition = autofilter.firstCondition;
@@ -360,10 +360,10 @@ worksheet.getRangeByName('C9').setText('Madrid');
360
360
worksheet.getRangeByName('C10').setText('Marseille');
361
361
362
362
// Intialize filter range.
363
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
363
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
364
364
365
365
// Add date filter.
366
- final AutoFilter autofilter = worksheet.autofilters [ 1] ;
366
+ final AutoFilter autofilter = worksheet.autoFilters [ 1] ;
367
367
autofilter.addDateFilter(DateTime(2002), DateTimeFilterType.year);
368
368
autofilter.addDateFilter(DateTime(2009, 5), DateTimeFilterType.year);
369
369
@@ -416,10 +416,10 @@ worksheet.getRangeByName('C9').setText('Madrid');
416
416
worksheet.getRangeByName('C10').setText('Marseille');
417
417
418
418
// Intialize filter range.
419
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
419
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
420
420
421
421
// Add dynamic filter.
422
- final AutoFilter autofilter = worksheet.autofilters [ 1] ;
422
+ final AutoFilter autofilter = worksheet.autoFilters [ 1] ;
423
423
autofilter.addDynamicFilter(DynamicFilterType.quarter2);
424
424
worksheet.getRangeByName('A1: C10 ').autoFitColumns();
425
425
@@ -496,10 +496,10 @@ worksheet.getRangeByName('C9').cellStyle.fontColor = '#000000';
496
496
worksheet.getRangeByName('C10').cellStyle.fontColor = '#FF0000';
497
497
498
498
// Intialize filter range.
499
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
499
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
500
500
501
501
// Add font color filter.
502
- final AutoFilter autofilter = worksheet.autofilters [ 2] ;
502
+ final AutoFilter autofilter = worksheet.autoFilters [ 2] ;
503
503
autofilter.addColorFilter('#0000FF', ExcelColorFilterType.fontColor);
504
504
505
505
// Save and dispose workbook.
@@ -571,10 +571,10 @@ worksheet.getRangeByName('C9').cellStyle.fontColor = '#000000';
571
571
worksheet.getRangeByName('C10').cellStyle.fontColor = '#FF0000';
572
572
573
573
// Intialize filter range.
574
- worksheet.autofilters .filterRange = worksheet.getRangeByName('A1: C10 ');
574
+ worksheet.autoFilters .filterRange = worksheet.getRangeByName('A1: C10 ');
575
575
576
576
// Add cell color filter.
577
- final AutoFilter autofilter = worksheet.autofilters [ 0] ;
577
+ final AutoFilter autofilter = worksheet.autoFilters [ 0] ;
578
578
autofilter.addColorFilter('#FF0000', ExcelColorFilterType.cellColor);
579
579
580
580
// Save and dispose workbook.
0 commit comments