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 .

Recommended Answers

All 4 Replies

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();

is it impossible to do it without that active x?

> is it impossible to do it without that active x?

AFAIK, yes, it's not possible.

Troy III , thank you , that was helpful .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.