Forum Discussion

shankar_r's avatar
shankar_r
Community Hero
9 years ago

DDT driver not reading Excel cell values with Carriage Return character?

DDT driver not reading Excel cell values with Carriage Return character.   Or is there any way to get the cell values with the Carriage Return character.   If i get any quick answer that would be...
  • tristaanogre's avatar
    tristaanogre
    9 years ago

    I was right... in the Excel cell, what is separating the lines is not a CR but an LF only... so, in other words, your code should be

     

    aqString.ListSeparator = "\n"
aqString.GetListItem(mycellvalue,0);

    This worked for me... see if it works for you.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

Can you describe how you are entering the carriage return into the cell?  I've attempted to do so by using ALT-ENTER within a cell and what I get does return a string with multiple lines. 

 

shankar_r's avatar
shankar_r
Community Hero
9 years ago

You are right, I got the value.

 

If  i want to split the value by carriage return(New Line) how can i do that?

  • shankar_r's avatar
    shankar_r
    Community Hero
    9 years ago

    Using Javascript i tire the below options,

     

    1)

    mycellvalue.split("\r\n")

     

    2)

    var testRE = RegExp("\r\n");

    mycellvalue.split(testR)

     

    3)

    mycellvalue.split(chr(13);

     

    nothing is working for me..

     

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      9 years ago

      I haven't tried it myself, but have you looked into the aqString.Split() method? That is not using native JavaScript but an internal function of TestComplete so it MIGHT work differently.

      • shankar_r's avatar
        shankar_r
        Community Hero
        9 years ago

        I guess instead of aqString.Split() we should use aqString.GetListItem() after setting up the aqString.ListSeparator.

         

        I have tried that too.

         

        aqString.ListSeparator = "\r\n"
        aqString.GetListItem(mycellvalue,0);

        aqString.ListSeparator = chr(13)
        aqString.GetListItem(mycellvalue,0);

         

        but no luck.