I have data pulled into a retool table but I am unable to export it into Excel when I use a custom export button.
Event Handler
Please see the screenshot for details. When I click on the button, nothing happens. No file will be downloaded.
Custom Script
Please see the screenshot for details. I had a few different versions to make sure that I did not have a syntax error. However, no line would allow me to export the table into Excel. No error message but no download either. The only way to download is to change the fileType to CSV. However, I hope to get formatted data and therefore CSV is not desired.
If anyone can provide some insights that'd be very helpful.