While working on some of the file operations, found that COMCreateObject is only supported in Windows servers. (As expected) and we cannot be using this if your siebel servers are based on AIX/Unix.
Alternative is to use Clib File operations.
Although it cannot open Excel, convert your excel to CSV or a Tab delimted or any delimited file and then try the operation.
Following is the sample code snippet : Enjoy coding 🙂
function WebApplet_PreInvokeMethod (MethodName)
if(MethodName == “ReadSpreadSheet”)
var fp = Clib.fopen(csvFileName, “r”);
var bo = TheApplication().GetBusObject(“CRS Action”);
var bc = bo.GetBusComp(“CRS Action”);
for(var line = Clib.fgets(fp); line != null; line = Clib.fgets(fp))
var cells = line.split(“;”);
var test = cells;
SetFieldValue(“Description”,”Test For Siebel from Excel”);
bc = null;
bo = null;