SunQuest
 
           JavaScript Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsProgrammingJavaScript Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread 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  
Old February 27th, 2006, 03:12 PM
Thorsun Thorsun is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2006
Posts: 1 Thorsun User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 35 m 19 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old June 30th, 2006, 04:39 PM
colton22's Avatar
colton22 colton22 is offline
\ ^_^ / - Moderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2006
Location: near chicago, Illinois
Posts: 471 colton22 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 Days 1 h 9 m 44 sec
Reputation Power: 3
Send a message via AIM to colton22 Send a message via MSN to colton22 Send a message via Yahoo to colton22
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

Reply With Quote
  #3  
Old September 7th, 2006, 06:46 AM
nickf nickf is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2006
Posts: 1 nickf User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 m 35 sec
Reputation Power: 0
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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingJavaScript Development > Pulling and displaying data from excel spreadsheet


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway