Functions

Function names are provided on left while their descriptions are on the right.

Import Functions

DataFromDatabase	Fills the values in the target cells by reading from a Database specified.
DataFromDBF.SK	Import data from a DBF File
DataFromDCF	Imports data from DBF.
DataFromEmail.SK	Imports mail details from an Email
DataFromExcel	Imports data from an Excel source and pastes it at a target location.
DataFromHtml.SK	Imports data from a HTML file and pastes it in the target location
DataFromJson	Imports data from a Json source and pastes it at a target location.
DataFromText	Imports data from a delimited or fixed
DataFromWeb	Imports data from a web source and pastes it at a target location.
DataFromXml	Imports data from a Xml source and pastes it at a target location.

Export Functions

ExportRows	(Deprecated. Use ExportToText.SK instead.) Exports the given range into a text file.
ExportSheets	Exports the contents of one or more worksheets to an external file.
ExportToDatabase	Exports the given range into a database
ExportToDBF	Exports the given range into a DBF file.
ExportToExcel	Exports the given range into an Excel file.
ExportToText	Exports the given range into a text file.
ExportToWord	Generates a Word file.
ExportToXml	Generates an XML file.
GenerateXml	(Deprecated. Use ExportToXml.SK instead.) Generates an XML file.

Export to Excel (Template)

Anchor.sk	Used to anchor cells in Export to excel(Template)
Container.SK	Used to get information of grouping the area elements in export to excel(Template)
Enforce.SK	Property of an element to force other elements in export to excel(Template)
FormatCells.SK	Used for conditional formatting of the template cells in UsingTemplate.SK
RepeatDown.SK	Used to get the information of repeating down data in Export to Excel(Template)
RepeatedRanges.SK	Used in Export to Excel(Template) repeat to mark repeated ranges
RepeatRight.SK	Used to get the information of repeating right data in Export to Excel(Template)
TemplateCells.SK	Used to mark reportinf cells in Export to Excel(Template)
UsingTemplate.SK	Used to print data in Export to Excel(Template)

Conditional Functions

And	Returns false if any of the operand is false.
Or	Returns true if any of the operand is true.
Validate	Validates a condition and reports a custom message.
EQ.SK	Validates a condition and reports a custom message.
NEQ	Returns True if both the operands are identical else false
EndsWith	Returns false if both the operands are identical else true
ContainsText	Tests whether a provided text ends with a given subtext.
StartsWith	Tests whether a provided text contains a given subtext.
CompareRows	Compares the rows in two tables and returns an array that can be used to identify changes. The rows in the two tables should be roughly in the same order for this function to return useful results.
FilterBy	Used to filter the data in QueryRows.
PartitionBy	Used to partition the data.
SortBy	Used to sort the data in QueryRows.

Regex Functions

RegexMatch	Tests whether an input string is exactly matched by a regular expression.
RegexReplace	Takes an input string and replaces all matches of a regular expression by a replace pattern.
RegexSearch	Takes an input string and finds the first match by a regular expression. Returns a horizontal array of values matching the groups in the regular expression.
RegexSearchAll	Takes an input string and finds all matches by a regular expression. Returns an array of rows per match. Each row has values matching the groups in the regular expression.
RegexSplit	Splits an input string into an array of substrings at the positions defined by a regular expression pattern.

Count Functions

CountDown	Returns the height of the region of non
CountRight	Returns the width of the region of non

HTTP Functions

HttpRequest.SK	Creates a HTTP Session
HttpStart.SK	Creates a HTTP Session
DownloadFiles	Downloads files from range of urls.
URLEncode	Returns Encoded URL with parameter names and values
UrlEncodedParams.SK	Marks parameters for URL encoding inside HttpRequest.

FTP Functions

FtpDownload.SK	Used to Download File via FTP
FtpListDirectory.SK	Used to list content of a remote directory via FTP
FtpUpload.SK	Used to upload file via FTP

Email Functions

EmailAttachments	Used to gather atttachment information in email
EmailBody	Generates a html email body.
EmailDetails.SK	Used to get the details in an Email
EmailFile.SK	Specifies the email file to be sent
SendEmail	Used to send an email.

Random Functions

RandomCauchy	Pastes vectors of independent random numbers based on the Cauchy distribution at a target location. Each column of the result is an independent variable.
RandomFisherF	Pastes vectors of independent random numbers based on the Fisher F distribution at a target location. Each column of the result is an independent variable.
RandomLogNormal	Pastes vectors of independent random numbers based on the log normal distribution at a target location. Each column of the result is an independent variable.
RandomNormal	Pastes vectors of independent random numbers based on the normal distribution at a target location. Each column of the result is an independent variable.
RandomUniform	Pastes vectors of independent random numbers based on the uniform continuous distribution at a target location. Each column of the result is an independent variable.
RandomUniformBetween	Pastes vectors of independent random numbers based on the uniform discrete distribution at a target location. Each column of the result is an independent variable.
FinalSeed	Gets the seed value of the generator that can be used to generate the next random values in a sequence.

Date Time Function

DateValueEx	Returns numerical date value of the given date text according to the provided format text.
EDATE	Returns the date that is the indicated number of months before or after the start date
EOPERIOD	Returns the last date of the period after adding the number of periods in the second argument
NOW	Returns time of the last run

Format Function

FormatAsTable	Applies a table style to a destination range
FormatBorders	Copies borders from a source range to a destination range
FormatCellContents	Copies number format, font, font size, font style, color and background from a source range to a destination range.

Text Manipulation

JoinText	Combines the text with the given delimiter.
MergeCellsInColumn.SK	Merge same values in a column
MergeCellsInRow.SK	Merge cells in a row based on same value cells in a criteria range. If criteria range is not specified then the same values are merged. This operation is only performed in Export to Sheets

Data Generation

Combinations	Returns an array of all possible combinations of rows from its arguments.
FillDown	Copies a range of cells downwards over a range of the specified height.
FillRight	Copies a range of cells rightwards over a range of the specified width.
MergeCellsInRow.SK	Merge cells in a row based on same value cells in a criteria range. If criteria range is not specified then the same values are merged. This operation is only performed in Export to Sheets
ReshapeColumns	Returns an array of a desired size produced by arranging the values of the input array. Columns are accessed left to right. Within each column, values are accessed top to bottom.
ReshapeRows	Returns an array of a desired size produced by arranging the values of the input array. Rows are accessed top to bottom. Within each row, values are accessed left to right.

String Converter

TableToText.SK	Converts a table arrary to a single text value
TextToColumns	Converts a column of delimited or fixed
TextToTable.SK	Converts text value to table array

Array Function

SelectRows	Returns an array of filtered columns based on a condition. Columns where the condition evaluates to TRUE are included in the result. Other columns are excluded. If no condition is specified, columns with error values are excluded.
ContinueArray	Returns a chunk of the result of an array formula.
GetRegionColumns	Returns a a 2 column array. The first row contains column numbers of the first and last columns with a non blank cell in the entire range. Subsequent rows contain column numbers of the first and last columns of non blank regions within the range.
GetRegionRows	Returns a a 2 column array. The first row contains row numbers of the first and last rows with a non blank cell in the entire range. Subsequent rows contain row numbers of the first and last rows of non blank regions within the range.
WriteArray	Expands a formula as an array.
StackColumns	Returns an array produced by arranging the values of each input argument from left to right.
StackRows	Returns an array produced by arranging the values of each input array one below the other.

Region Function

RegionAcross	Returns the largest region of non blank cells that is bounded by a fully blank row and column.
RegionDown	Returns the region of non blank cells downwards from the specified row range.
RegionRight	Returns the region of non blank cells rightwards from the specified column range.

Range Function

RangeAcross	Returns a range of cells downwards and rightwards from the specified cell with the specified height and width.
RangeDown	Returns a range downwards from the specified row range with the specified height.
RangeRight	Returns a range rightwards from the specified column range with the specified width.

ZIP Function

ExtractZip.SK

Extracts the given ZIP File

CMD Function

CommandLine.SK	Constructs a command line from a program name and argument
RunCommand	uses cmd.exe to run a command. The output / errors produced by the command can be pasted into the worksheet.

Pivot Function

PivotRowsBy	Row label(s) in a pivot table. Used to sort the data in QueryRows.
PivotTable	Returns an array of filtered columns based on a condition, and after pivoting by columns.

Look Up

VLookup	Matches each row of a given data set in a second data set and returns values from specified columns in matching rows of the second data set. #N/A values are returned for rows without a match.
MatchBy	Used to match a column in Vlookup.SK.
VLookup2D	Matches each row of a given data set in a second data set and returns value from cell in matching row
MultiMatchBy	Used to group columns before match multi to one column in Vlookup.SK.

Report Function

GetAllFiles	Get all files from a given location.
GetCurrentUser.SK	Used to get the details of the current user
GetOutput.SK	Returns the activity output value
WaitForActivity.SK	Returns Activity Run Status
Identity	Returns the input as passed to the funtion.
Index	Returns an array of values at the given row and column locations from source arrays.
IntoFiles	Used to get file name after partition the data in files.
LoadFile	Returns file path from File Id .
RefAddress	Returns the full address of a range in A1 format.
Report	Used to report a column in QueryRows.
ReportHeaders	Used to report a column name.
SerialNumber.SK	Returns Sequence of specified numbers of rows starting from Start Number.
SheetNames	Pastes a vertical array of sheet names in a specified workbook to a specified location.
SolveFunction	Finds the value at which the specified function evaluates to zero.
StoreFile	Returns file Id of a file from a table in database.

SQL Function

DeleteRowsFromTable	Deletes the given range from the database table
SqlProc	Used to form Sql procedure name.
SqlTable	Used to form Sql table name.

Offset Function

OffsetDown	Offsets a range downwards by a specified number of rows while ensuring that the result range lies within a nonblank region or within an area of a specified height.
OffsetRight	Offsets a range rightwards by a specified number of columns while ensuring that the result range lies within a nonblank region or within an area of a specified width.

Path Function

RelativePath	Constructs a path relative to the active workbook or library.
ResolveFilePath.SK	Resolve the given file path with respect to the transaction sandbox
StaticPath.SK	Constructs a path relative to active workbook or library
TempPath.SK	Generates a temporary path without creating a file

Miscellaneous

CallFunction	Calls a function with the parameters, passed in the exact same order as per the original function specification.
DefineFunction	Defines a custom function with the specified name. If there are no Output arguments, last argument identifies the result.
FixRef	References in the given expression are not considered as lambdas.
Formula	Formula Info details
Headers	Headers above data info for the arguments of the function
HorizontalDir	Static Fields range in horizontal direction in ExportToWord.SK.
IntoTable.SK	Used to process the data in Export to Excel
RemoveDuplicates	Returns an array of unique rows from a range or array by removing duplicates according to an optional criterion.
StartActivity	Enables an activity to be run multiple times with different sets of arguments. If there are no Output arguments, last argument identifies the result.
VerticalDir	Static Fields range in vertical direction in ExportToWord.SK.