wood burning stoves 2.0*
The moose likes HTML, CSS and JavaScript and the fly likes Editing an Excel Sheet using javascript Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "Editing an Excel Sheet using javascript" Watch "Editing an Excel Sheet using javascript" New topic
Author

Editing an Excel Sheet using javascript

amey mahadik
Greenhorn

Joined: Mar 27, 2008
Posts: 8
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: 41124
    
  45
There may be some ActiveX controls you can use in Internet Explorer, but generally, that's not possible.


Ping & DNS - my free Android networking tools app
Mohammed Yousuff
Ranch Hand

Joined: Oct 17, 2007
Posts: 198
For Your information there are some JavaScript API by which you can create a table which will look like a Excel sheet .


My Thoughts : http://passion4java.blogspot.com
Try not to become a man of success but rather to become a man of value.
amey mahadik
Greenhorn

Joined: Mar 27, 2008
Posts: 8
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
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

Thnx
 
jQuery in Action, 2nd edition
 
subject: Editing an Excel Sheet using javascript
 
Similar Threads
Copying a sheet from an excel file to another excel file using Apache POI
Excel macro and javascript
How to create New Excel File
Making excel file uneditable HElp needed Urgent
jxl.jar Help needed