Question

1
Replies
287
Views
AbhishekP2468 Member since 2016 6 posts
Tech Mahindra
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

Unable to open External Attachment file (Excel) in browser using tools.sendFile

Hi All,

I'm having a screen in my application where I have option to upload files of type .xlsx format. Once the user uploads a file, it gets stored in DB in Base64 format. Once uploaded I'm giving an option to the user for download of the same file. In order to download I'm using "Open URL in Window" on click action of the file link where I'm calling an Activity which has the following java for download of the file:

ClipboardPage myPage = tools.findPage("DataAdministrationPage");
String sErrorMessage = tools.sendFile(myPage, "UploadFileSource", true, null, "Export.xlsx", false, null, true);

where the DataAdministrationPage in clipboard contains the filename and the file data (Base64 format in UploadFileSource property)

But when on click the file gets downloaded from new window I'm unable to open it both in browser and Microsoft Excel. It says "Excel cannot open the file because the file format or file extension is not valid".

Please let me know if I'm doing anything wrong. It's urgent.

Low-Code App Development Low-Code App Development Dev/Designer Studio Data Integration Java and Activities SR Exists
Moderation Team has archived post
Share this page LinkedIn