Description
Currently, transferring over 10,000 records from the backend to the frontend for Excel generation is inefficient and leads to performance issues. Handling large datasets in the frontend causes delays and can impact user experience.
Create a new NPM package to be used on the backend that handles the generation of Excel files directly. This solution will allow large datasets to be processed on the backend, reducing the need to send large amounts of data to the frontend, improving performance and overall efficiency.
One alternative is to continue transferring large datasets to the frontend and using packages like @impler/react for Excel generation. However, this approach results in high data transfer and performance issues with large records.
This new NPM package will simplify the process of generating Excel files on the backend, optimize performance, and avoid heavy data transfer between the frontend and backend.