we are trying to export Data into Excel using the servoyguy_servoycom - Plugin with the following function:
- Code: Select all
function onExcelExportTest(event) {
/**@type {Packages.com.servoyguy.servoycom.JSCOM}*/
var _excelObject;
/**@type {Packages.com.servoyguy.servoycom.JSCOM}*/
var _workBooks;
/**@type {Packages.com.servoyguy.servoycom.JSCOM}*/
var _workSheet;
/**@type {String}*/
var _fileName;
/**@type {Array<java.lang.Object>}*/
var _object;
if(!plugins.servoyguy_servoycom.isJACOBInstalled()) {
globals.DIALOGS.showErrorDialog('Excel export error', 'plugins.servoyguy_servoycom.isJACOBInstalled()', 'OK');
return;
}
// excel com-object
_excelObject = plugins.servoyguy_servoycom.getNewClientJSCOM("excel.application");
if(!_excelObject) {
globals.DIALOGS.showErrorDialog('Excel export error', 'plugins.servoyguy_servoycom.getNewClientJSCOM("excel.application")', 'OK');
return;
}
_excelObject.put("DisplayAlerts",false);
// create workbook
_workBooks = _excelObject.getChildJSCOM("WorkBooks");
_workBooks.call("add");
// add worksheet
_object = [1];
_workSheet = _excelObject.getChildJSCOM("WorkSheets", _object);
// save
_fileName = "gde_exceltest";
try {
var x1 = _workSheet.call("SaveAs", _fileName);
var x2 = _workSheet.call("SaveAs", "c:\\temp\\" + _fileName);
var x3 = _workSheet.call("SaveAs", "f:\\" + _fileName);
var x4 = _workSheet.call("SaveAs", plugins.file.getDefaultUploadLocation() + "\\" + _fileName);
} catch (error) {
globals.DIALOGS.showErrorDialog('Excel export error', '_workSheet.call("SaveAs", _fileName)', 'OK');
}
_excelObject.call("Quit");
_excelObject.release()
globals.DIALOGS.showErrorDialog('Excel export', 'Fertig, x1=' + x1 + ', x2=' + x2 + ', x3=' + x3 + ', x4=' + x4, 'OK');
}
Testing it in the developer works fine. But on the Application Server it seems, that the command '_workSheet.call("SaveAs", ...)' doesn't work. There is no error occuring in the serverlog or anywhere else.
Does anyone have any idea how to solve this problem?
Thank you for your answers.
Winnie