Forum Discussion

abrar22's avatar
abrar22
Frequent Contributor
9 years ago

Trimming " from excel Sheet

HI,   I am passing the Elements from Excel sheet to my code and in the process test complete is putting \ in elements and looking for something else which I am not passing. For Example I want to pa...
chrisb's avatar
chrisb
Regular Contributor

I use DDT and havent seen this issue. How are your cells formatted in the spreadsheet?

abrar22's avatar
abrar22
Frequent Contributor
9 years ago

Looks something like this:

 

ElementToCheckTypeComparisonTypeExpectedValue
"ComboBox","" , 1"wText"cmpEqual"European"
"Finder", "", 1"SelectedValue"cmpEqual"EUR/USD"
  • NisHera's avatar
    NisHera
    Valued Contributor
    9 years ago

    what version of XL you are using?

    and what language scrpts are written?

    • abrar22's avatar
      abrar22
      Frequent Contributor
      9 years ago

      I am using Excel 2010 and JScript for Language .

      • joseph_michaud's avatar
        joseph_michaud
        Moderator
        9 years ago

        Need more information.  You can use the sample code in Using DDT Drivers to view your spreadsheet data.  In my simple testing, the data seems to be read correctly from an XLS file.  As you debug your script/keyword test, what values are read in?  How do you use this data?  What evidence makes you say that TestComplete is modifying the data?