We have requirement to generate an excel(.xlsx) file using email script, we were able to get the .csv but need it in .xlsx. Please help us on how to achieve this.
What you can do is create a custom table with a Supplier field and Other fields to store records data, make sure you are avoiding duplicate suppliers while creating the record in a custom table. Now, you can report on a custom table and associate the report with a scheduled email report. I believe you can create a custom table with no cost by extending tables (Such as dl_matcher etc..). In your script include you can work on the logic to populate the supplier data into a custom table.
