PDA

View Full Version : how to export to excel using ajax?



melaos
21 May 2008, 09:40 AM
hi guys,
i'm a total noob web developer currently using a combination of perl cgi, javascript, xml+xlst on axkit, running apache in unix environment, whew~

i have a page with two tables. classes and student activities in a class. select levels and click on a generate button, and i update the classes table via ajax. and click on a class name will show the student activities table.

both of these tables have a export to excel button. i want to make it so that the export will auto reflect the current table showing. i.e. if i choose another class, the activities report will refresh and if i click on the export to excel for activities report, it will export this table to excel instead older one.

what's the best way to do this?
all i know thus far is using stuff like this to update the innerHtml,

// use ajax to update form parameters
xmlHttp = GetXmlHttpObject() ;
xmlHttp.open("GET", URL, true);
xmlHttp.onreadystatechange = updateActivityReport;
xmlHttp.send(null);


thanks in adv
~webN00b