excel export with servoyguy_servoycom
Posted: Thu Jan 23, 2014 2:46 pm
Hi,
we are trying to export Data into Excel using the servoyguy_servoycom - Plugin with the following function:
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
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