Exporting Excel To Remote Server

I need some Technical Support about exporting Excel file to remote server. 
but the thing is the excel fine generation will not be triggered by user action but programmatically.
This is how it goes, 
1.Excel Being Generated Periodically in Web Server 
2.The generated file gets posted to WAS
3.WAS handles the post request, and save the excel file to somewhere intended. 
 
Bottom line is, is it possible to generate files and trigger exporting API to remoter server AUTOMATICALLY?
 

3 answers

Public
Tanya Gryshko Flexmonster November 1, 2018

Hello!
If you want to export Excel file to remote server programmatically, the most convenient option is to use PhantomJS. It allows using Flexmonster’s exportTo API call without showing the pivot grid. Using a small script, it is possible to load a page with Flexmonster. For more details please refer to this doc: https://www.flexmonster.com/doc/export-and-print/#!phantomjs
I hope this information would be helpful.
Regards,
Tanya

Public
KIMYEONGSEOK November 2, 2018

Thanks for the reply, but it has not clearly answered my question. So to be clear, 
Is it possible to export the generated file to REMOTE SERVER? or only possible to export to the WEB SERVER’s local directory that Flexmonster Javascript is running on ?

Public
Tanya Gryshko Flexmonster November 2, 2018

Hello!
Thanks for a quick update.
Yes, the generated file can easily be exported to the remote server. Here is a sample:

var params = {
destinationType: 'server',
url: 'your server-side script'
};
flexmonster.exportTo('excel', params);

Please note that url is a path to the server-side script which can save this file.
Does it help?
Regards,
Tanya

Please login or Register to Submit Answer