View Full Version : Excel Sheet and Javascript and VBScript

03-04-2003, 09:31 AM
Hi All,
In the Client Side I want to know how to read a data from the Excel Sheet and I have to send the data to the Server.
Any Idea. If it works in IE5.5+. Its more than enough.

Thanks in Advance
Thanks and Regards

03-05-2003, 07:58 AM
if the excel sheet is also on the client, and you know the name, you can go activeX:

var xlApp = new ActiveXObject("Excel.Application");
xlApp.visible = true //set this to false if you are sure the whole thing works correctly
xlDoc = xlApp.Open("hereyourfilename");

go on with the excel-instance to read the data, check the vba documentation to find out how to extract the cell data you want.

at the end, close the document and close the excel instance

xlDoc.Close(1); // you should provide some constant here, to prevent excel from asking to save changes i believe its 1