save data in excel using javascript

[ranjiths]

hi,
i am trying to export data to excel from html using javascript, but i am getting an error as it opens saveas window. Please do the needful

[tswaters]

hi,
i am trying to export data to excel from html using javascript, but i am getting an error as it opens saveas window. Please do the needful

try vbscript, using the COM object for handling excel files.... what is it .... createObject("M icrosoft.Excel" ) ? I can't remember....

sum of it is, can't use javascript for something like this due to javascript's inability to save to the client's filesystem

[rnd me]

luckily, i don't belive in can't.

function dataUrlStr(data) {
return "data:application/vnd.ms-excel," + escape(data);
}

var mysheet=[
"a\tb\tc\n\
1\t2\t3\t\n\
4\t5\t6"][0]


window.open(dataUrlStr(mysheet))

firefox only, use activex for an ie version