aspose 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 | 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
Marshal

Joined: Mar 22, 2005
Posts: 42596
    
  65
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Editing an Excel Sheet using javascript