Hi ,
Am going through some examples given here
https://es.infragistics.com/products/ignite-ui-angular/angular/components/excel-library-using-tables
consider below line used for creating table
var table = worksheet.tables().add("A1:G10", true);in my case i already have data and want to apply table for the region where the data is available dynamically based on spreadsheet content
Hello Peru,
This forum thread appears to be somewhat of a duplicate to the questions you have asked here, regarding the dynamic table definitions: https://es.infragistics.com/community/forums/f/ignite-ui-for-angular/125002/spreadsheet-sorting-and-customizations/547089?focus=true. I have recently answered your questions there, so I would recommend taking a look.
Regarding programmatically applying a filter to the table, I would recommend taking a look at the following documentation: https://es.infragistics.com/products/ignite-ui-angular/angular/components/excel-library-using-tables#filtering-tables.
You can clear the filter similarly, by calling the clearFilter() method on the WorksheetTableColumn element returned by table.columns(0) in the code snippet at that documentation topic.
Please let me know if you have any other questions or concerns on this matter.