Excel Web Scrapping Expert Needed
Budget: $12 – $30 SGD
Dear Programmer, this spreadsheet details the requirements of this project.
1. The Windows version I am using is LTSC Professional Plus 2021
2. Please test it before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up
3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job.
4. The link for each of the table is listed in the RED weblink.
5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7.
6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it is.
7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex.
8. Requirement- must be able to add to this list as it is not complete and there are always changes
For 2nd link
3. In the Worksheet "Link 2", this is for the pasting of data from the weblink
4. The link for testing is https://live3.bola010.com/basketball/analysis/538565 , cell A2.
5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference.
6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query.
7. Requirement- if you are creating a macro, please test it with this version of Office as i have tried many times with many settings changes.
8. Requirement- You can create a macro, so that it starts to download when triggered.
If there is something wrong with my settings, you can point out to me , if i can get the data in, i don’t mind to pay you a fee to learn it and overcome it.
1. The Windows version I am using is LTSC Professional Plus 2021
2. Please test it before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up
3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job.
4. The link for each of the table is listed in the RED weblink.
5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7.
6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it is.
7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex.
8. Requirement- must be able to add to this list as it is not complete and there are always changes
For 2nd link
3. In the Worksheet "Link 2", this is for the pasting of data from the weblink
4. The link for testing is https://live3.bola010.com/basketball/analysis/538565 , cell A2.
5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference.
6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query.
7. Requirement- if you are creating a macro, please test it with this version of Office as i have tried many times with many settings changes.
8. Requirement- You can create a macro, so that it starts to download when triggered.
If there is something wrong with my settings, you can point out to me , if i can get the data in, i don’t mind to pay you a fee to learn it and overcome it.