File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Register / Login


Win a copy of Practical Unit Testing with TestNG and Mockito this week in the Testing forum!
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Reply 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: 32765
There may be some ActiveX controls you can use in Internet Explorer, but generally, that's not possible.


Android appsImageJ pluginsJava web charts
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
 
IntelliJ Java IDE
 
subject: Editing an Excel Sheet using javascript
 
Threads others viewed
Making excel file uneditable HElp needed Urgent
jxl.jar Help needed
How to create New Excel File
Excel macro and javascript
Copying a sheet from an excel file to another excel file using Apache POI
MyEclipse, The Clear Choice