vbarros
13 years agoOccasional Contributor
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 ();
}
}
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 ();
}
}