• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Important jsp

 
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 7001
6
Eclipse IDE Python C++ Debian Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 356
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?

 
Ranch Hand
Posts: 1055
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I agree with Shubhrajit. Please see this Macromedia article
reply
    Bookmark Topic Watch Topic
  • New Topic