ExcelRange input for Expressions?

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.

   

Parents
  • Hi Christiaan,

    A couple of things I can think of. 
    In the expression I believe you need to target you want the value. 
    so you can put in excelRange1.Value. 


    That however would not work the way you would like if you have mixed content like Series(x,x,x). It will he returned as a string from excel. 
    I recall there was a way to remove the string from mixed content but I can’t recall at the moment. ToInt works for values but not in mixed I believe. 

    However you have all the information you need in excel. Columns A,B,C has the building blocks for the series function. 
    so you could just use those values directly. 

    Series(excelRange1.Value[0],excelRange1.Value[1],excelRange1.Value[2])

    That should do the job if you wanted a single Series from an excel range say ”A1:C1”

    You could also skip the expression node as well but sometimes it is nice to see the values :) 

    hope that helps

    Wayne

Reply
  • Hi Christiaan,

    A couple of things I can think of. 
    In the expression I believe you need to target you want the value. 
    so you can put in excelRange1.Value. 


    That however would not work the way you would like if you have mixed content like Series(x,x,x). It will he returned as a string from excel. 
    I recall there was a way to remove the string from mixed content but I can’t recall at the moment. ToInt works for values but not in mixed I believe. 

    However you have all the information you need in excel. Columns A,B,C has the building blocks for the series function. 
    so you could just use those values directly. 

    Series(excelRange1.Value[0],excelRange1.Value[1],excelRange1.Value[2])

    That should do the job if you wanted a single Series from an excel range say ”A1:C1”

    You could also skip the expression node as well but sometimes it is nice to see the values :) 

    hope that helps

    Wayne

Children