xSkrape Reference Guide

This page includes documentation for all versions of xSkrape: for Excel (Add-in), for SQL Server and for SSIS.

There are different views of XS.QL documentation: at a summary level here, for URL's here, and for queries here.

You can pick a specific version to filter results:

Product Filter:   

Common to all versions of xSkrape is our xSkrape Fundamentals document (PDF). We suggest you start here to get familiar with common concepts that help when reading examples and reference documentation.


Function Reference
Function Overview Product / Version
WebGetSingle

Extract a single value (number, text, etc.) from a source reference, using query conditions that identify the value of interest.

For Excel (2.0)

For SQL Server (2.0)

WebGetSingleFromTable

Extract a single value (number, text, etc.) from a source reference, using query conditions that identify both a table and the row(s) and column that contain the specific data value of interest.

For Excel (2.0)

For SQL Server (2.0)

WebGetTable

Extract tabular data (rows and columns) from a source reference, using query conditions to identify the characteristics of the data in the event there are multiple tables that could be identified in the source.

For Excel (2.0)

For SQL Server (2.0)

Send SMS/EMail

Send an E-Mail or SMS message to a fixed distribution list, with text content coming from text in your worksheet. One could for example dynamically create a message that includes specific metrics that can be shared without sending or sharing the entire workbook.

For Excel "Web" Add-in (3.0) only