LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Get data from cells on a webpage (https://www.linuxquestions.org/questions/linux-software-2/get-data-from-cells-on-a-webpage-4175564265/)

Pedroski 01-18-2016 08:16 AM

Get data from cells on a webpage
 
Don't know where to start with this one, so I thought I would ask here.

My son needs to get the data from the last column of this webpage for a project:

http://www.jisilu.cn/data/sfnew/#tlink_3

This column is dynamically updated. It seems to consist just of dates, like 2017-06-16 .

How to download/get just this column from the webpage??

Any tips? Maybe a bash script??

jdkaye 01-18-2016 02:38 PM

It would help if one could read Chinese. There may be an indication on the webpage about how to do what you want (or even just download the spreadsheet) but all this requires an ability to read Chinese. Do you or your son read Chinese?
jdk

Pedroski 01-18-2016 04:08 PM

Chinese is not the problem, we live here in Nanjing.

The thing is, I am not a computer person. I could probably do this in a Libre Office spreadsheet, but this a an html page, probably written using javascripts.

The dates are the times when bonds mature or come up for renewal.

Maybe you have a tip where I might better ask this question?

NGIB 01-18-2016 04:13 PM

Just highlight the data (start at the first column, hold down the left button and drag). When all is highlighted, right click and "copy", open a blank spreadsheet and hit "paste". Delete columns you dont want. Just did it, worked fine...

Pedroski 01-18-2016 05:12 PM

Thanks a lot, that's a good start! I'll tell him.

He's just doing some practical training in the winter break. The Shanghai Stock Exchange apparently closes at 11:30 until 13:00. In the break they play Texas Hold'em Poker. My son is an ace at that years of experience at pokerstars!


All times are GMT -5. The time now is 06:48 AM.