Welcome Guest! Log in


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

 

You have no rights to post comments

Articles

Suggest a new Article!