Hi raphael,
From you Excel sheet snippet and the Connect code it is not very clear to me what you are trying to achieve. From the Excel sheet snippet it looks like you are trying to read a 3-dimensional set where the labels are found in
A2:C4. But in the Connect code you specified a data range of
A1:C3. In addition, by specifying
rowDimension: 0 and
columnDimension: 1, you are instructing the
ExcelReader to read a 1-dimensional set from the specified data range where the labels are found in the first data row. If you actually want to read a 3-dimensional set you would need the
ExcelReader instructions to be like this:
Code: Select all
- ExcelReader:
file: Lego-Edit.xlsx
symbols:
- name: testSet
range: Hindex_new!A2:C4
rowDimension: 3
columnDimension: 0
type: set
A
rowDimension of
3 indicates that the first three columns of the data range will be interpreted as the labels.
Aileen