Simple web data extraction, java site,using variables in URL


i would like a scraping quote please, to extract data from a public website. I've tried using the Excel Web Query function, but the website uses Java so the data extracted comes through as blanks.

The data I need comes from a single Java web page only, and is always in a fixed place on the page. The data itself changes dependent on 2x string values that are within the URL, in the "[url removed, login to view]" format.

In an Excel file, I will provide a list of these URLs sorted by date. What I would like to do in Excel, is to be able to key in a date, click a macro button, and have the data pulled from the website for each of the URL's for the date selected - and have that inserted into my spreadsheet alongside the URL rows I have provided. If this data is already present, it should be overwritten/refreshed. There are likely to be a maximum of 100 URLs for each date, so it will need to loop through each of them until they are all extracted. There will be just one Excel file, that I will add to over time.

From the website, I need a total of 40 data items for each URL provided, to be inserted into the spreadsheet I will provide. 39 of the data items are simple % figures, the 40th item is a piece of text.

I hope that all makes sense, please let me know if you need me to clarify anything. I need this work done as soon as possible, I think it will be quite a simple task for someone with the correct understanding and skill-set required.



Beceriler: Veri Madenciliği, Excel, Web Scraping

Daha fazlasını gör: web page spreadsheet, the simple web, spreadsheet web page, spreadsheet on web page, spreadsheet in web page, sorted data set, sorted data, one key data, java and excel, fixed web page, data extraction from web, what is macro in excel, what is data scraping, uses for excel, excel uses, web data, Web Data Extraction, simple macro, java+excel, java excel, excel java, java web scraping excel, loop url list, excel macro add, website data java

İşveren Hakkında:
( 0 değerlendirme ) India

Proje NO: #6550539

Bu iş için 11 freelancer ortalamada £125 teklif veriyor


Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of my similar experience: Amazon/Ebay Bots: [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde142%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)

hi i could provide a desktop application that will scrape the site.

in %bids___i_period_sub_35% gün içinde263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)

Hi, kindly reply, waiting for same I have 7 years of experience of developing excel VBA based web crawlers (any script) Please share me sample URL and data fields means i can submit sample before you award this Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Expert in scrapping Please contact me soon ready to work now what is the url? so i can see have made hundreds of bots before

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(4 Değerlendirme)

I understood what you want. I have a done a similar task earlier but that included collecting data from 12 thousand links. My previous scraping tasks include collecting 160 thousand tower data, e-shops, stock exchanges Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

Hello! Emulating browser behavior (web related scripting languages client-side, and not server side, produced content) in an application that's not really a web browser is not an easy task at all. The Excel`s Web Qu Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(3 Değerlendirme)

I have worked on several data scraping projects with my own scripts. I would like to work with you. please let me know further. Regards, Selvan

in %bids___i_period_sub_35% gün içinde158%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hello, I'm new to freelancer.com, so I guarantee I will make this job with high quality to get positive review. I have all necessary knowledge to complete this task.

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)


in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi Martin, I have done similar projects in the past, very much interested in your project. Kindly provide me the input excelsheet so that I can complete the deliverable in Time. Thanks, Kishore

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, expert in web scraping using c#.net, give me url to check . done scraping of youtube, dailymotion, facebook, g+ ,pinterest etc. thanks and reagards....

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Already done alot of programs to scrap such websites, i will extract them all in no time. ping me for more details

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Greetings for the day!!! I have 5 years of experience in VB, VBA Macros with applications like SAP, Internet Explorer, PDF & Text files,Excel functions and formulas,Dashboard creations in excel like Pivots, Charts, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)