In Microsoft JScript on the server, none of the contstants work. Is there any reference for the constants used in the Open command?
I have found several issues with the following code.
var excel2003=6; ///Where should I get this number?
var aspose=new ActiveXObject("Aspose.Excel.Excel");
aspose.Open(templatePath,excel2003);
var awrksht=aspose.Worksheets.item(0);
var workSheetName=awrksht.name;
var cells=awrksht.cells;
var Cell1=cells.item(0);//This is the only call that works.
var Cell1=cells[0]; //This returns null
var Cell1=cells[0,0]; //This returns null
var Cell1=cells.GetAt("A1"); //This returns MethodNotFound
var Cell1=cells.item("A1"); //The throws ObjectDoesNotSupportAutomation
Cell1.PutValue("new val");////The throws ObjectDoesNotSupportAutomation
Cell1.PutValue("new val",0);////The throws invalide number of parameters