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:
  #1  
Old February 2nd, 2008, 07:39 PM
griffinmt griffinmt is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2008
Posts: 4 griffinmt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 54 sec
Reputation Power: 0
Question Other - Using Excel with Javascript

I have looked at several posts on this subject, but none seem to help me with my needs.
1) I have the html output from an excel file(sheet) that has been stored into a large text field in a mysql database.
2) I would like to launch excel into an iframe window of the browser and 'give' it the contents of this field to work with rather than opening up a file.
3) Later I would like to extract the html format date from excel and store it back into the database field.

Martyn

Reply With Quote
  #2  
Old February 7th, 2008, 02:22 PM
Mittineague's Avatar
Mittineague Mittineague is offline
Contributing User
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jul 2005
Location: West Springfield, Massachusetts
Posts: 548 Mittineague User rank is Private First Class (20 - 50 Reputation Level)Mittineague User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Week 1 Day 6 h 35 m 44 sec
Reputation Power: 4
excel in HTML page

Hi griffinmt, welcome to the forums,
AFAIK there is no way to use javascript to parse excel files.
The excel file is offered as a download because the browser settings need to be set to "open files of this type with this app". That is, the launching of excel is in the realm of the browser's control, not the web page.
If this is only for your use, you should be able to do this however.
If you have PHP, there is a PEAR package - Spreadsheet Excel Writer http://pear.php.net/package/Spreadsheet_Excel_Writer - that should solve your problem as this is server-side and independent of browser settings.
__________________
WP plugins - Error Reporting, Clean Options
http://www.mittineague.com/dev/er.php
http://www.mittineague.com/dev/co.php

Last edited by Mittineague : February 7th, 2008 at 02:30 PM. Reason: linkification

Reply With Quote
  #3  
Old February 8th, 2008, 01:04 PM
griffinmt griffinmt is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2008
Posts: 4 griffinmt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 51 m 54 sec
Reputation Power: 0
Actually, I have just discovered how I can do this. Since every client has MS Office 2003 (at least), I can use the Web Component loaded as an ActiveX Object. It is not 100% the same as native Excel, but more than close enough for my application.

The only real issue now is that the spreadsheet (which is stored in a server side DB in HTML or XML format) will have to make the network trip back and forth several times. These are from 30kb to 170kb chunks, so this part of the app won't be overly fast!!

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingJavaScript Development > Other - Using Excel with Javascript


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 4 hosted by Hostway