Forum Discussion

tinauser's avatar
tinauser
Frequent Contributor
14 years ago

Reading from xls file for some cell

Hi there, I have made a very simple DDT, and it seems TC cannot read it. I tried to post a log with the content of column 2 without success. Can you tell me why?
anna_v's avatar
anna_v
Icon for Staff rankStaff
14 years ago

Hi,


Could you please clarify how you populated the myXlsTable variable in your project? Is it a Project or ProjectSuite variable?


I have created a ProjectSuite variable and the following script code works correctly with your Excel table:



function Test2()

{

  ProjectSuite.Variables.myXlsTable.Reset();

  while(!ProjectSuite.Variables.myXlsTable.IsEOF())

  {

  Log.Message(ProjectSuite.Variables.myXlsTable.Value("Msg"));

  ProjectSuite.Variables.myXlsTable.Next();

  }


Ann