GetInnerHtml returning values too big for Excel cell

Ask general questions here.
gilbar16
Posts: 109
Joined: Wed Mar 26, 2014 6:23 pm

GetInnerHtml returning values too big for Excel cell

Post by gilbar16 » Tue Nov 03, 2015 1:23 am

Hello,

Ranorex Support gave us a solution for handling/validating contents of a webelement drop down list using GetInnerHtml.
For many of the combo or listboxes that have few entries, the solution works perfectly.
For some, the returned value of GetInnerHtml is too big that when pasted on Excel cell, the result gets split into two or more cells or rows. This is mainly due to a very long list of items and the value contains many data not needed by your script like:
<option value="Select">Select</option><option value="Option1">Option1</option><option value= and so on.

Do you have a module/function for validating list items in a drop down control list?

Is there an option in GetInnerHtml to exclude those "<option value="Any">Any</option>" to just return the actual values you are interested of getting so that the input data in Excel does not get too big?
When I copied/pasted the value on MS Word, the returned value took up 12 pages, for example, since the list items are in the hundreds. In Excel, it took at least two cells.

Thanks.
Gilbert

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: GetInnerHtml returning values too big for Excel cell

Post by Support Team » Fri Nov 06, 2015 8:15 pm

Hello Gilbert,

Now that your site has been published and available to the public, lets go ahead and handle this issue via the Support Email channel. Can you please send us an email with the issue below?

Thanks,
Andy