This week's book giveaway is in the Server-Side JavaScript and NodeJS forum.
We're giving away four copies of Micro Frontends in Action and have Michael Geers on-line!
See this thread for details.
Win a copy of Micro Frontends in Action this week in the Server-Side JavaScript and NodeJS forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Important jsp

 
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
 
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
 
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 ?

 
Ranch Hand
Posts: 1055
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree with Shubhrajit. Please see this Macromedia article
 
I'm THIS CLOSE to ruling the world! Right after reading this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic