Hi,
Is it possible to add an Excel range for example one of the Yellow fields to an Expression, I can't get it work properly see image and I'm sure I use the right table etc.
Hi Wayne,
Thanks now it's working, it Seems I had the wrong value I needed only this one "excelRange1.Value"
Thanks
//Christiaan
Hi Christiaan,
I have attached an excel file and a dgn with the example.
You may have to re-link the excel. I had is located in C:\Temp folder.
The file has 2 examples, first(in blue) just a single series taken from the values in excel.
The second (in orange) uses a series function but has a slider so you can select different rows in excel. Starting from 0(Row 1 in the example excel) up to 9.
hope that helps
Wayne
Series.xlsxExcel-Series.dgn
If it's possible to give me an example file this will be helpful for me.
christiaan.postATSweco.nl
I think the error is in the way you are trying to target the data from excel.
I notice you don't have anything in the excelRange2 RangeAddress.
maybe this should be "A3:C3"
Then you could update the Series to Series(excelRange2.Value[0],excelRange2.Value[1],excelRange2.Value[2])
I think of the excel node as just grabbing the data from excel and placing it into a list or an array.
In the case of "A3:C3" it would be a simple list.
For example it might return from excel {1,10,2}
Then you target it with the index of each item in the list, for example number 1 would be index 0, number 10 would be index 1 and number 2 would be index 2.
Hope that helps.
Maybe I could send you an example file for you to reference.
Just keep struggling with the range, I think I do something wrong or I put it in the wrong fields
Try to make this series form my excel sheet.
Series(excelRange2.Value[A3],excelRange2.Value[B3],excelRange2.Value[C3])