Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


This article shows how to select only a part of an Excel Sheet, and then reversing it as a datastore.

This article is a Work In Progress. We might also change its structure and category soon.
Please feel free to suggest improvements at the bottom of the page.

Selecting the area

The selection of the area is done during metadata creation.

For an existing metadata, Right Click on the root node of the Excel Metadata > Actions > Launch wizard to get the Configuration Window.

The modification consists of:

1 - Adding a parameter to the url of the file.

The syntax is:

definedNamed:"<nameWantedForTheArea>"="<fileName>"."<sheetName>$!<area>"

2 - Choose the selected area which should next appear in the datastore reverse window with the name defined in the url.

 

Example:

We have this file, and we want only the second part: A6 to C10

 excelFile

URL used:

jdbc:stambia:excel://<pathToTheFile>/customers2.xlsx?forceDatatypeAsString=true&columnNameStyle=PRESERVE&definedNamed:"myArea"="customers2"."sheet1$!A6:C10"

 

metadata

 

Next, the area can be found in datastore reverse window:

datastore

 

Articles

Suggest a new Article!