|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Pulling and displaying data from excel spreadsheet
I am trying to develop a javascript application that opens an excel spreadsheet and pulls data from one of the worksheets for display. I've seen the codes that can display data the same as excel. but I don't want to display the data in a spreadsheet format. I want to be able to take the data from the spreadsheet and display it any way I want to.
Could anyone walk me through what I need to do? Thanks. |
|
#2
|
||||
|
||||
|
i really dont think that is possible because files like .doc load seperatly through word, the only way i have seen this happen is between .doc files and .xls files
dont take my answer literally, im not a complete expert colton22 |
|
#3
|
|||
|
|||
|
How to read/write to Excel using JavaScript
Reply (if still looking now?!):
U can read from Excel and write to Excel using the following code (for a webpage): Code:
<html>
<script>
function mytest1() {
var Excel, Book; // Declare the variables
Excel = new ActiveXObject("Excel.Application"); // Create the Excel application object.
Excel.Visible = false; // Make Excel invisible.
Book = Excel.Workbooks.Add() // Create a new work book.
Book.ActiveSheet.Cells(1,1).Value = document.all.my_textarea1.value;
Book.SaveAs("C:/Documents and Settings/ProGamer/Desktop/word to text/TEST.xls");
Excel.Quit(); // Close Excel with the Quit method on the Application object.
}
function mytest2() {
var Excel;
Excel = new ActiveXObject("Excel.Application");
Excel.Visible = false;
form1.my_textarea2.value = Excel.Workbooks.Open("C:/Documents and Settings/ProGamer/Desktop/word to text/TEST.xls").ActiveSheet.Cells(1,1).Value;
Excel.Quit();
}
</script>
<body>
<form name="form1">
<input type=button onClick="mytest1();" value="Send Excel Data"><input type=text name="my_textarea1" size=70 value="enter ur data here">
<br><br>
<input type=button onClick="mytest2();" value="Get Excel Data"><input type=text name="my_textarea2" size=70 value="no data collected yet">
</form>
</body>
</html>
But u will have to go into your browser's internet options and enable ActiveX controls. Have fun, Nick |
|
#4
|
|||
|
|||
|
Append Data to Excel Spreadsheet
Hi Guys, Hope someone can help me, I fairly new scripting and I found the code below that is almost exactly what I want, except I need to append to the the spreadsheet on the next available line, instead of creating a new document each time - hope someone can help.
Cheers Jason. [code] <html> <script> function mytest1() { var Excel, Book; // Declare the variables Excel = new ActiveXObject("Excel.Application"); // Create the Excel application object. Excel.Visible = false; // Make Excel invisible. Book = Excel.Workbooks.Add() // Create a new work book. Book.ActiveSheet.Cells(2,2).Value = document.all.my_textarea1.value; Book.SaveAs("C:/temp/TEST.xls"); Excel.Quit(); // Close Excel with the Quit method on the Application object. } function mytest2() { var Excel; Excel = new ActiveXObject("Excel.Application"); Excel.Visible = false; form1.my_textarea2.value = Excel.Workbooks.Open("C:/temp/TEST.xls").ActiveSheet.Cells(1,1).Value; Excel.Quit(); } </script> <body> <form name="form1"> <input type=button onClick="mytest1();" value="Send Excel Data"><input type=text name="my_textarea1" size=70 value="enter ur data here"> <br><br> <input type=button onClick="mytest2();" value="Get Excel Data"><input type=text name="my_textarea2" size=70 value="no data collected yet"> </form> </body> </html> [code] |
|
#5
|
|||
|
|||
|
Could not run in IE7.0
Quote:
|
![]() |
| Viewing: Dev Articles Community Forums > Programming > JavaScript Development > Pulling and displaying data from excel spreadsheet |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|