0

need to read and write to xls (excel sheet) using javascript
read and write should be to specific cell in that sheet
if its possible , please help do it
thanx .

3
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by kosofi
1

need to read and write to xls (excel sheet) using javascript
read and write should be to specific cell in that sheet
if its possible , please help do it
thanx .

you will need Exel activeX object for this.

This is a demo code from MSDN:

var ExcelApp = new ActiveXObject("Excel.Application");
var ExcelSheet = new ActiveXObject("Excel.Sheet");
// Make Excel visible through the Application object.
ExcelSheet.Application.Visible = true;
// Place some text in the first cell of the sheet.
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";
// Save the sheet.
ExcelSheet.SaveAs("C:\\TEST.XLS");
// Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit();

Edited by Troy III: n/a

0

is it impossible to do it without that active x?

Edited by happygeek: fixed formatting

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.