Question
Coforge
IN
Last activity: 11 Jun 2018 6:02 EDT
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.