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
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
      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        10 years ago

        Two things:

        1) Make sure that your Excel workbook is not open already somewhere else. There are various problems with accessing the file via DDT if it is already open.

        2) Double check your version of Excel.  If you are using Excel 2007 or later, you should use the following:

        DDT.ExcelDriver(excelPath, "WSI_Controls", true);