Is it possible to edit an excel sheet using javascript...??? I want to create dynamic comboboxes in my excel sheet is there a to do this using javascript..?? Is there any api which I can refer to...??
Thanks
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 32765
posted
0
There may be some ActiveX controls you can use in Internet Explorer, but generally, that's not possible.
I did use ActiveX Control tried opening an excel sheet, entering some values inside the excel sheet, even closing the excel sheet is possible but didnt find a way to create dynamic comboboxes. Heres the code that i wrote in javascript
var Excel, Book;// Declare the variables // Create the Excel application object. Excel = new ActiveXObject("Excel.Application"); Excel.Workbooks.Open("C:/Final templates/MyExcel.xls"); Excel.Visible = true;// Make Excel invisible. Book.ActiveSheet.Cells(1,1).Value = document.all.my_textarea1.value; Book.SaveAs("C:\Final templates\MyExcel.xls"); Excel.Quit();// Close Excel with the Quit method on the
Thnx
amey mahadik
Greenhorn
Joined: Mar 27, 2008
Posts: 8
posted
0
I did use ActiveX Control and tried opening an excel sheet, entering some values inside the excel sheet, even closing the excel sheet is possible but didnt find a way to create dynamic comboboxes. Heres the code that i wrote in javascript
var Excel, Book;// Declare the variables // Create the Excel application object. Excel = new ActiveXObject("Excel.Application"); Excel.Workbooks.Open("C:/Final templates/MyExcel.xls"); Excel.Visible = true;// Make Excel invisible. Book.ActiveSheet.Cells(1,1).Value = document.all.my_textarea1.value; Book.SaveAs("C:\Final templates\MyExcel.xls"); Excel.Quit();// Close Excel with the Quit method on the