Saturday, June 04, 2011

Working with the Data Table Object

AddSheet Method

Adds the specified sheet to the run-time Data Table
Syntax: DataTable.AddSheet(SheetName)
Example:
Variable=DataTable.AddSheet ("MySheet").AddParameter("Time", "8:00")

DeleteSheet Method

Deletes the specified sheet from the run-time Data Table.
Syntax: DataTable.DeleteSheet SheetID
Example: DataTable.DeleteSheet "MySheet“

Export Method

Saves a copy of the run-time Data Table in the specified location.
Syntax: DataTable.Export(FileName)
Example: DataTable.Export ("C:\ahamad.xls")

ExportSheet Method

Exports a specified sheet of the run-time Data Table to the specified file.
Syntax: DataTable.ExportSheet(FileName, DTSheet)
Example: DataTable.ExportSheet "C:\ahamad.xls" ,1

GetCurrentRow Method

Returns the current (active) row in the run-time global data sheet.

GetRowCount Method

Returns the total number of rows in the longest column in the global data sheet or in the specified data sheet of the run-time Data Table.
Example:
rowcount = DataTable.GetSheet("MySheet").GetRowCount

GetSheet Method

Returns the specified sheet from the run-time Data Table.
Example:MyParam=DataTable.GetSheet ("MySheet").AddParameter("Time", "8:00")

GetSheetCount Method

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

Import Method

Imports the specified Microsoft Excel file to the run-time Data Table.
Syntax: DataTable.Import(FileName)
Example: DataTable.Import ("C:\ahamad.xls")

ImportSheet Method

Imports a sheet of a specified file to a specified sheet in the run-time Data Table.
Syntax:  DataTable.ImportSheet(FileName, SheetSource,SheetDest)
Example: DataTable.ImportSheet "C:\name.xls" ,1 ,"name"

SetCurrentRow Method

Sets the specified row as the current (active) row in the run-time Data Table.
Example: DataTable.SetCurrentRow (2)

SetNextRow Method

Sets the row after the current (active) row as the new current row in the run-time Data
Table.

SetPrevRow Method

Sets the row above the current (active) row as the new current (active) row in the run-time
Data Table.

GlobalSheet Property

Returns the Global sheet of the run-time Data Table.
Example:
DataTable.GlobalSheet.AddParameter "Time", "5:45"

LocalSheet Property

Returns the current (active) local sheet of the run-time Data Table.
Example:
MyParam=DataTable.LocalSheet.AddParameter("Time", "5:45")

RawValue Property

Retrieves the raw value of the cell in the specified parameter and the current row of the run-time
Data Table.
Syntax: DataTable.RawValue ParameterID [, SheetID]
SheetID can be the sheet name, index or dtLocalSheet, or
dtGlobalSheet.

Value Property

Retrieves or sets the value of the cell in the specified parameter and the current row of the run-time Data Table.
Syntax:DataTable.Value(ParameterID [, SheetID])

No comments:

Post a Comment