The Artima Developer Community
Sponsored Link

Java Answers Forum
Excel Spread Sheet data access

2 replies on 1 page. Most recent reply: Mar 5, 2002 2:28 PM by Samuel

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 2 replies on 1 page
Samuel

Posts: 2
Nickname: sam
Registered: Mar, 2002

Excel Spread Sheet data access Posted: Mar 1, 2002 7:22 AM
Reply to this message Reply
Advertisement
As you all know the proven methodology to access the data in Excel spread sheets is using the JDBC-ODBC bridge with the excel drivers. But when the file is expected from the client (browser or Swing GUI)
1. Is there a way to convert the Excel data into delimtted flat file ( or Java objects) on the client itslef
2. If has to be done by the server, what is the way to do dynamically without the need to create DSN etc..

A fast response is very well appreciated. Thanks


Alain Ravet

Posts: 19
Nickname: aravet
Registered: Feb, 2002

Re: Excel Spread Sheet data access Posted: Mar 5, 2002 2:05 PM
Reply to this message Reply
There are many commercial products.
FormulaOne (www.tidestone.com) is one of them.

(I've never used it)

Samuel

Posts: 2
Nickname: sam
Registered: Mar, 2002

Re: Excel Spread Sheet data access Posted: Mar 5, 2002 2:28 PM
Reply to this message Reply
Sincere thanks for the response..As a matter of fact we are using it now !!!

But I do wish to make it as a simple task by writing my own custom implementation on the fly at the client itself.

Flat View: This topic has 2 replies on 1 page
Topic: Arrays Previous Topic   Next Topic Topic: classes

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use