Reads a range object from an XML file that contains multiple range objects (Up to 15 range objects) written via the function WriteXLRange2(). You specify the range object you wish to read via an index number.

The function returns the queried range object.

This function is useful, for example from an Excel environment, if you wish to read several range object that have been stored within ONE xml file independently from a spreadsheet.

XML files can be saved to a central location where other users can also read these ranges back in via the ReadXLRange2() function.

The ReadXLRange2() function simply uses the an index number (1-based) to locate the range you wish to extract.

The index number used depends on the order in which range objects were passed to the WriteXLRange2() function.

The first range passed in takes on index number 1, the second range, index number 2 etc... You must pass in a range object for the first parameter, but all other parameters are optional (or null objects if using the API functions).

You can also pass in range objects just for parameter 1 and 7 only, thus the indexes used during the reading of these ranges will be 1 and 7 respectively within the ReadXLRange2() function.

Variant CTQueryDB.ReadXLRange2( _
String FileName, _
String Path, _
Long nIndex)

=CT.XML.ReadXLRange2(
Excel String Cell FileName,
Excel String Cell Path,
Excel Numeric Cell nIndex)

static CTRangeDataCPP ReadXLRange2(
std::string FileName,
std::string Path,
long nIndex);

CTRangeData CTQueryDBSA.ReadXLRange2(
System.String FileName,
System.String Path,
System.Int32 nIndex);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.