|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
February 27th, 2006, 03:12 PM
|
|||
|
|||
|
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
June 30th, 2006, 04:39 PM
|
||||
|
||||
|
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
September 7th, 2006, 06:46 AM
|
|||
|
|||
|
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
|
|
| 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 |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
