This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
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


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
Rancher

Joined: Mar 22, 2005
Posts: 42955
    
  73
There may be some ActiveX controls you can use in Internet Explorer, but generally, that's not possible.
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Editing an Excel Sheet using javascript