Forum Discussion

anumolu9999's avatar
anumolu9999
Contributor
10 years ago

my script is asking to open the excel file

Below is the function to get data from excel. But getting error while running if the file is closed. Do this need to add any line in the script to open excel in the background. Can any one help me out...
baxatob's avatar
baxatob
Community Hero
10 years ago

 

 

  • anumolu9999's avatar
    anumolu9999
    Contributor
    10 years ago
    Baxtob attached the screenshot of code
  • anumolu9999's avatar
    anumolu9999
    Contributor
    10 years ago
    I am not able to see those options Under RichText. I think the network that I am currently in is blocking attachments/formatting text
    • baxatob's avatar
      baxatob
      Community Hero
      10 years ago

      Ok. Please check:

       

      function getControlData(index) { 

	ctrlData = ODT.Classes.NewArray(); 
	DatafileName = "MCT_ControlsNtestData.xlsx"; 
	sCurPath = Sys.OleObject("Scripting.FileSystemObject").GetAbsolutePathName("."); 
	excelPath = sCurPath + "\\Data\\" + DatafileName;
	DDT.ExcelDriver(excelPath, "WSI_Controls"); 
	while(!DDT.CurrentDriver.EOF()) { 
		colCount = DDT.CurrentDriver.ColumnCount 
		for(var j=0; j<=colCount-1; j++) { 
			if(DDT.CurrentDriver.Value("index")==index) 
				ctrlData.AddItem(DDT.CurrentDriver.Value(j)); 
			else break; 
			} 
		DDT.CurrentDriver.Next();
		} 
	DDT.CloseDriver(DDT.CurrentDriver.Name); 
	return ctrlData; 
	}

      What exact error do you receive?

      • anumolu9999's avatar
        anumolu9999
        Contributor
        10 years ago
        Its showing.......Javascript runtime error......An attempt to work with a closed driver.........it is triggering at the line (while(!DDT.CurrentDriver.EOF())).............. Thanks, Anumolu