PDA

View Full Version : could not get single (last) element while looping through class name (web scraping)



syed_iqbal
03-18-2017, 01:50 PM
HI,

In the attached file I written code to get elements from html code. last "For loop" (loop through class name) in the code is not working properly. With this code i want to get all 8 elements. But i got first 7 elements only. i did not get 8th element value ( AI column value - yellow colored Cells). Pls go through the code and help me.


Regards
syed

offthelip
03-20-2017, 01:55 PM
The solution is really really simple all I did was cut and paste the formatting from AH3 to AI3 to AI15 and all the numbers appear, even without running anything.

mdmackillop
03-20-2017, 04:29 PM
There is a first character CHR(32) in the results cells which is pushing the data onto the next line