(Using Version 7.7.0)
So, I’m trying to convert a HTML file to a excel sheet but I’m finding that one of the cells with specific information in doesn’t seem to get the correct (or expected) field data when loading as a worksheet using the cells api.
The field in question looks like this:
If I drag the html file directly into excel 2013, the field in question will show the text between the first anchor tag (“text i want to show”) and strip out the anchor tag (dont know why!), but through the api it comes through as 3 spaces (i assume the blank spaces between the 2 anchor tags " ").
What im interested in getting is the display text from the anchor tag. Works fine with just 1 url in there (as expected).
To reproduce create a blank file and throw in this;
Some Title Here
|1234||2345||3456||text i want to show|