[syncfusion_flutter_xlsio] Tables with filters not working.

[lukaszciastko]

I am trying to create a Table with auto filters. When I save the document and try to open it in Excel, I'm getting an error.

I use this code to create a Worksheet with a Table:

  final workbook = Workbook();

  final sheet = workbook.worksheets[0];

  sheet.getRangeByName('A1').setText('Fruit');
  sheet.getRangeByName('A2').setText('Banana');
  sheet.getRangeByName('A3').setText('Cherry');
  sheet.getRangeByName('A4').setText('Strawberry');

  sheet.getRangeByName('B1').setText('Price');
  sheet.getRangeByName('B2').setNumber(2.50);
  sheet.getRangeByName('B3').setNumber(7.0);
  sheet.getRangeByName('B4').setNumber(3.50);

  final range = sheet.getRangeByName('A1:B4');

  sheet.tableCollection.create('Table1', range)
    ..showHeaderRow = true
    ..builtInTableStyle = ExcelTableBuiltInStyle.tableStyleLight1;

  sheet.autoFilters.filterRange = range;

  final bytes = workbook.saveAsStream();
  final directory = await getApplicationDocumentsDirectory();
  final path = '${directory.path}/Report.xlsx';

  await File(path).writeAsBytes(bytes);

  workbook.dispose();

When I try to open the Document in Excel, I see this error:

How can I create a Table with filters so it works correctly?

[SivakumarRamya]

Hi

Greetings from Syncfusion.

We have logged a feature report as Support for auto filters in the table but do not have any immediate plans to implement this feature in near future. You can track the status of the feature report through the following feedback link.

Track Status: https://www.syncfusion.com/feedback/37918/support-for-auto-filters-in-the-table-in-flutter

Regards,
Ramya.