aspose file tools*
The moose likes JSP and the fly likes Important jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Important jsp " Watch "Important jsp " New topic
Author

Important jsp

sandeep balyan
Ranch Hand

Joined: Jul 25, 2001
Posts: 134
Hi
Iam having some of my web forms in which iam taking user data
Hi
I want to do
Once i have data in my database i have to use application in Excel
that takes this data and work accordingly..
is there a way that i can select and use data in excel iam using jsp
second is there a way by using browser that i can show this application
that is of excel to my users also ..
any help appreciated
regds


Want to do something great will do one day
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
From your description above I'm not sure exactly what you want. In the past, though, I have found that one of the easiest ways to "talk" to Excel from Java is to map a DSN to your Excel spreadsheet and use JDBC to treat the rows like a database.
Is this possible in your case ?


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
sandeep balyan
Ranch Hand

Joined: Jul 25, 2001
Posts: 134
Hi u r very much correct
c Iam connecting using dsn only but
gives me problem
cant find test file which is excel one
and if i place dollar sign after file name
it gives exception wrong character
regds
Shubhrajit Chatterjee
Ranch Hand

Joined: Aug 23, 2001
Posts: 356
JDBC - ODBC bridge driver from sun is not thread-safe and hence it is unsuitable to be used from a production environment. If you use only one connection, and synchronize access, there will probably be a hell of a performance issue.
My 2 cents
Originally posted by Frank Carver:
From your description above I'm not sure exactly what you want. In the past, though, I have found that one of the easiest ways to "talk" to Excel from Java is to map a DSN to your Excel spreadsheet and use JDBC to treat the rows like a database.
Is this possible in your case ?


Shubhrajit
Anthony Villanueva
Ranch Hand

Joined: Mar 22, 2002
Posts: 1055
I agree with Shubhrajit. Please see this Macromedia article
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Important jsp
 
Similar Threads
Tiles problem with opening response in excel
Excel Charts and JSPs
Refreshing frame containing xls table?
Jsp to Excel
Inserting Image in Spreadsheet Using XSL