Connecting Tech Pros Worldwide Forums | Help | Site Map

Export data of a table from a dynamic webpage in MS Excel

Newbie
 
Join Date: Nov 2008
Posts: 1
#1: Nov 22 '08
Hi

We have a dynamic website in my office where all the data is stored in a table. we need to copy the data from that table and paste in excel accordingly, also i have to click next to get the next set of data from the table. This becomes very tiresome as we have 2 - 3 hundred pages to be copied and pasted in excel manually can we have a code that can do the same. Most importantly we can’t get data from server directly, could any one please help me in this. It can save 3-4 hours of time a day for me.

Thanks in Advance.

gits's Avatar
Moderator
 
Join Date: May 2007
Location: Munich, Germany
Posts: 4,136
#2: Nov 23 '08

re: Export data of a table from a dynamic webpage in MS Excel


could you explain why you cannot get the data directly? please explain in more detail what need or better, want to have automated ... but i think the best way to do that is a serverside solution. in case you call pages from domains that are not yours then we are ready here because we cannot cross-site-script with javascript ... except you search for a firefox-extension that might help you and which has more privileges ... but as i said ... a serverside solution would be much better and much easier to implement ...
Reply


Similar JavaScript / Ajax / DHTML bytes