website help needed

dipsomaniac

does anyone know how i can take the information from the following website and add a column on the end with a caculation. if i just copy and paste into excel the information ends up all over the place.


Uploaded with ImageShack.us

timmeh_2

Not sure what engines are available to you but I'd personally use PHP + cURL. You can then get the contents of the page and display the contents as you like.

Lil306

dipsomaniac wrote: »

does anyone know how i can take the information from the following website and add a column on the end with a caculation. if i just copy and paste into excel the information ends up all over the place.


Uploaded with ImageShack.us

This MAY work.... so worth a quick try

- Copy info
- Open notepad + paste (all formatting will be removed so only data exists)
- Copy all
- Open excel + paste

I've done that once or twice and even though it looks out of line, excel usually fixes it up again

I'm not saying it will work, but it's free advice

dipsomaniac

Lil306 wrote: »

This MAY work.... so worth a quick try

- Copy info
- Open notepad + paste (all formatting will be removed so only data exists)
- Copy all
- Open excel + paste

I've done that once or twice and even though it looks out of line, excel usually fixes it up again

I'm not saying it will work, but it's free advice

didn't work unfortunately, it is the same as paste special > text only. php + curl is above my head at the moment timmeh. will have a look at exel web query

Lil306

Can you post the URL to the site where you have that info, I can see if I can grab the info another way for you

googler

Select All within the webpage
Copy to clipboard
Open Notepad
Paste into Notepad
Where you want the existing data split into columns, either insert a Tab, or a suitable delimiter (I use . If it's already tabbed, fine.
Save the Notepad data as a *.txt file

Open Excel, place cursor at cell A1, open the 'Data' menu, select 'Import External Data'
Navigate to the txt file you just saved, and specify the delimiter option you used - tab or '='.
Follow the prompts, and it should import your data nicely formatted in columns.

Lil306

googler wrote: »

Select All within the webpage
Copy to clipboard
Open Notepad
Paste into Notepad
Where you want the existing data split into columns, either insert a Tab, or a suitable delimiter (I use . If it's already tabbed, fine.
Save the Notepad data as a *.txt file

Open Excel, place cursor at cell A1, open the 'Data' menu, select 'Import External Data'
Navigate to the txt file you just saved, and specify the delimiter option you used - tab or '='.
Follow the prompts, and it should import your data nicely formatted in columns.

Worth a shot, my post didn't put formatting in with delimited but may work

loudcox

Try right clicking the table and selecting "Export to Microsoft Excel".

http://www.youtube.com/watch?v=NOmyKi6S9tE for a video

googler

Lil306 wrote: »

Worth a shot, my post didn't put formatting in with delimited but may work

"Damned with faint praise" would sum this up.

Your version didn't use the 'Import External Data' option either.

dipsomaniac

Lil306 wrote: »

Can you post the URL to the site where you have that info, I can see if I can grab the info another way for you

thanks for this. i am just going to try the other methods now.

hxxp://www.betbrain.com/?website=1#/viewer/nextMatches-0/site/0?dayId=0

dipsomaniac

loudcox wrote: »

Try right clicking the table and selecting "Export to Microsoft Excel".

http://www.youtube.com/watch?v=NOmyKi6S9tE for a video

i did try this but the data ends up all over the place