Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Important jsp

 
sandeep balyan
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
sandeep balyan
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 356
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Anthony Villanueva
Ranch Hand
Posts: 1055
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree with Shubhrajit. Please see this Macromedia article
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic