[C#] Can't arrange data retrieved from a table on another site

[IM1337]

Hi guys

I used

You must be registered to see links

to retrieve a table from

You must be registered to see links

YQL Query:
select * from html where url='http://www.uob.com.sg/personal/loans/personal-loan.html#rates-tenors' and xpath='//div[@class="nova-table-container"]'

Ok, in case you guys are confused...

To sum it all up, I'm trying to get this table



From

You must be registered to see links

And here is my failed result

You must be registered to see links

Thanks in advance!

 

[Taiga]

The

You must be registered to see links

tag can help you spread it across the rows.
Plus it's not C# it's just Javascript & JQuery.

 

[NubPro]

if you were to examine the source codes from

You must be registered to see links

, you will notice that it has used rowspan in the td tag.



Also, there's a minor bugs in your codes.
Replace <table> with this, and you should be able to understand what's wrong.

<table border="1" cellspacing="0" cellpadding="5">

 

[IM1337]

if you were to examine the source codes from

You must be registered to see links

, you will notice that it has used rowspan in the td tag.



Also, there's a minor bugs in your codes.
Replace <table> with this, and you should be able to understand what's wrong.

You must be registered to see links

Don't have much time left. This is all I could do. Guess it could work too..



:

Could you help me out with this one:

You must be registered to see links

The end product when I put into my website looks like this:

select * from html where url='http://www.hsbc.com.sg/1/2/personal/loans/personal-loan?utm=a&device=d' and xpath='//div[@id="tbl-1"]'

 

[NubPro]

You must be registered to see links

Don't have much time left. This is all I could do. Guess it could work too..

View attachment 152935

:

Could you help me out with this one:

You must be registered to see links

The end product when I put into my website looks like this: View attachment 152936

<td> </td> notice the closing the tag.

Also, that's some pretty terrible coding right there.

 

[IM1337]

<td> </td> notice the closing the tag.

Also, that's some pretty terrible coding right there.

Hahaha I know, I'm sorry.

Couldn't think of how to properly retrieve the table, so I decided to retrieve every single data 1 by 1 and pluck it into my own table's rows and columns.

Don't really have much time left, so I guess I'll just have to make do with this.

 

[NubPro]

You must be registered to see links

You might want to understand every single part of it, so please don't copy my codes blindly.

 

[IM1337]

You must be registered to see links

You might want to understand every single part of it, so please don't copy my codes blindly.

Thank you so much!