Forum Discussion

vbarros's avatar
vbarros
Occasional Contributor
13 years ago

Record information in Excel spreadsheet

I'm trying to store data in Excel spreadsheet, can anyone help me with that?



NOTE: I have something similar to capture data from a spreadsheet



EX: function Test ()

{

   var value;



   / / Initialize the iterator

   Project.Variables.DBVar1.Reset ();

  

   / / Iterate through rows

   while (! Project.Variables.DBVar1.IsEOF ())

   {

     / / Retrieve the value

     Project.Variables.DBVar1.Value value = ("ColumnName");

  

     / / ...

     / / Use the value needed in the way

     / / ...



     / / Forward the iterator to the next row

     Project.Variables.DBVar1.Next ();

   }

}