QuickTable | Thread - load website into QuickTable and copy to excel.

QuickTable
Home \| API \| Tutorial \| Download \| Support \| Contact

QuickTable

User Cp | Register | Members | Search | Help

\|- QuickTable Discussion Forums > General QuickTable Support/Help	Post New Topic Post A Reply
load website into QuickTable and copy to excel.	printer friendly version next newest post \| next oldest post

Author	Messages
Dan Bromberg Unregistered	Posted Monday, July 11, 2005 @ 21:41:32 Can I use QuickTable to somehow copy stock quotes at a website into your Table and then download them into Excel?
Admin Board Owner Gender: Unspecified Location: Registered: Jul 2003 Status: Offline Posts: 9	Posted Monday, July 11, 2005 @ 22:01:36 QuickTable directly doesn't support this. But you can use java.net.URLConnection object to connect to a website and download the html and then parse the html using HTMLEditorKit class. You can parse the html and create a vector of vectors of the data and the load the vector of vectors into QuickTable using the refresh(Vector) method. A few samples to use URLConnection and HTMLEditorKit http://www.cs.huji.ac.il/course/2003/dbi/2003/Exercises/LinkExtractor.java http://www.java2s.com/ExampleCode/Swing-JFC/HTMLDocumentDocumentIteratorExample.htm http://www.dimi.uniud.it/labs/documentazione/java/tips/Tip16.html
danny Unregistered	Posted Monday, July 11, 2005 @ 23:16:57 I look forward to following up on your suggested links - thanks very much! Danny

Post New Topic Post A Reply

Jump to:

All times are GMT -5 Hours.

Welcome to QuickTable Forums, Guest!

Username	:
Password	:

In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!