Click to See Complete Forum and Search --> : Excel through javascript?


geuis
04-06-2003, 09:25 AM
Is it possible, using Javascript or some other scripting language, to write data to an excel spreadsheet directly or indirectly?

khalidali63
04-06-2003, 09:27 AM
Not with JavaScript,
I won't be surprse though,if there is an activex control by MS to get this done in VBScript..

Cheers

Khalid

AdamGundry
04-06-2003, 10:54 AM
You can, but only if running the JavaScript from the JS file (external to a web page, not even linked in). This will require your users to download the file then run it, but if it's for something locally you could use it.

If you're using Windows, try the sample JS files in C:\Windows\Samples\Wsh.

Basically, you create an Excel object using a call to the Windows Scripting Host:
var objXL = WScript.CreateObject("Excel.Application");

Be aware you cannot use this in a webpage and it probably will only work on Windows, with the WSH installed (I'm not certain).

Adam