How to open the generated Excel File without downloading?
Hi,
I am generating Excel File using OOTB activity MSOGenerateExcelFile. This activity generates and downloads the file to user's machine but my requirement is to Open the generated Excel file upon Button click without downloading. Could anyone please suggest a solution for this?
***Moderator Edit: Vidyaranjan | Updated Categories***
Pegasystems Inc.
US
See if this might help you.
https://jwcooney.com/2014/03/31/remove-internet-explorer-open-or-save-popup/
Commonwealth Bank of Australia
AU
Thanks Rett. I am looking for a solution that can be implemented from Pega so that users don't have to change their generic system settings. I was able to achieve this for PDF generation by making a minor change in the OOTB activity 'Code-Pega-PDF.View' which is being called in 'pyViewAsPDF' activity. I am looking for something similar to this.
Pegasystems Inc.
US
Hello,
I don't really know the answer to your question, but the excel file is really an HTML stream that excel can read, so in theory, if you can tweak the rules that generate the stream, and instead of sending them the to client, you pass that onto the clipboard and call some sort of show HTML method, you should have what you need. Although I have no idea what it looks like directly in a browser, so it may need to be formatted to look pretty, but that's where I'd start.
Thanks,
Mike
PEG
IN
Hello,
Can you keep DownloadFile parameter to false which is responsible for downloading the file? In calling activity of MSOGenerateExcelFile you can make this parameter to false?
Hope this helps!