Record to Excel widget : how to download the excel

I had the requirement to let users upload entries through excel and then provide them a report of failed/passed entries.

I have all the data ready in an excel but how should I let the user download that.

I used RecordListToExcel widget to convert data in the excel.

What i want is, after uploading the excel user should get a pop up showing success/failed counts and option to view the report. If they say "Ok" then the reportExcel should download.

So kind of alert box after successful upload.

Any pointers please.

Hello Tanuj,

To download a file, just use the Download statement at the end of a screen action. You need to pass to it the content (the result of the RecordListToExcel statement), the name of the file and the MIME type (you can find a list of valid mime types in google.