I'm working with the ExcelJS library to manipulate an Excel file in my React application. I have a template Excel file that already contains some auto filters applied to the rows
After I edit the contents of this Excel file, I proceed to download it. However, the cells with filters from the previous template are missing. I have tried reapplying the filters by setting them back to the columns, but I get the error: "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." It seems like the existing filter properties are being overwritten, causing the issue. Do you have any approach or a library that can retain the Excel properties (like filters) during manipulation?
