Working with data Tables

'Reading Data table

DataTable.Value(ParameterID [, SheetID])

DataTable(ParameterID [, SheetID])

'Writing Data table

DataTable.Value(ParameterID [, SheetID])=NewValue

DataTable(ParameterID [, SheetID]) =NewValue

'AddSheet method to create the new sheet in run-time Data Table

Variable=DataTable.AddSheet ("NewSheet").AddParameter("Name", "SuperMan")

'Deletes the specified sheet from the run-time Data Table.

DataTable.DeleteSheet "Source"

'Saves a copy of the run-time Data Table in the specified location

DataTable.Export ("C:\DEstination.xls")

'Exports a specified sheet of the run-time Data Table to the specified file.

DataTable.ExportSheet "C:\Destination.xls" ,name or index

'Returns the current row of the Data Table

Current_Row= DataTable.GetCurrentRow

'Returns the total number of rows in the longest column

Row_Count= DataTable.GetSheet("MySheet").GetRowCount

'Returns the total number of sheets in the run-time Data Table.

Sheets= DataTable.GetSheetCount

'Imports the specified Microsoft Excel file to the run-time Data Table. (The imported table replaces all data in the existing run-time Data Table )

DataTable.Import ("C:\Runtime.xls")

'The data in the imported sheet replaces the data in the destination sheet

DataTable.ImportSheet "C:\Runtime.xls" ,Source name or index ,destination name or index ' Index starts from 1

'Sets the specified row as the current row

DataTable.SetCurrentRow(i)'Global

DataTable.GetSheet("MySheet").SetCurrentRow(i) 'User Sheet

'Sets the Next row

DataTable.SetNextRow

DataTable.GetSheet("MySheet").SetNextRow

'Sets the Previous row

DataTable.SetPrevRow

DataTable.GetSheet("MySheet").SetPrevRow

'Accessing Global sheet with GlobalSheet

DataTable.GlobalSheet.AddParameter "Col_Name", "NewValue"

'Accessing Local Sheet with GlobalSheet

DataTable.LocalSheet.AddParameter "Col_Name", "NewValue"

'Raw Value returns the formula from excell

Raw_Value = DataTable.RawValue (ParameterID or "Name" ,SheetIndex or "Name" )

FormulaVal= DataTable.GetSheet("ActionA").GetParameter("Date").RawValue

VAlueByRow= DataTable.GetSheet("ActionA").GetParameter("Destination").ValueByRow(4)

'Delete Colom

DataTable.GetSheet("dtGlobalSheet").DeleteParameter("OldColumn")

'Counting the Row and col

rowcount = DataTable.GetSheet("MySheet").GetRowCount

paramcount = DataTable.GetSheet("MySheet").GetParameterCount

'Returns the name of the run-time data sheet.

Sheetname = DataTable.LocalSheet.Name

'Load Environment File

Environment.LoadFromFile("C:\Environment.xml")

'Read and update Environment Variable

x = Environment("MyVarName")

Environment("MyVarName") = x