VBScript excel Methods

Below are the few commonly used VBScript Excel  methods / functions

1) GetSheetCount : Returns the total number of sheets in the run-time data table

2) Import Method: Imports the stecified microsoft excel file to the run-time data table
Syntax : DataTable.Import(Filename)

3) ImportSheetMethod: Imports a sheet of a specified file to a specified sheet in the run-time data table.
Syntax: DataTable.ImportSheet(Filename, sheetsource, SheetDest)

4) SetCurrentRow Method: Sets the specified row as the current(active)row in the run - time data tabe.
Syntax:DataTable.SetCurrentRow(number)

5) SetNextRow Method:Sets the row after the current(active)row as the new current row in the run-time data table.

6) SetPrevRow Menthod:Sets the row above the current(active)row as the new current(active)row in the run-time data table.