Accessing Excel worksheet using jsp...


  Hi,
    I need to open an excel workbook using JSP, the problem here is i need to show a particular work sheet among available sheets as active work sheet and also i need to show a specific cell as active cell in that work sheet.
Example:
  Workbook contains sheet1, sheet2,... sheet10. Here i need to show sheet3 as active worksheet(by default sheet1 will be shown as active). In sheet3, i want to show C3 as active cell, that is, cursor should be on C3 cell.

Plz give me a solution to handle this issue(if an example is provided that will be very useful to me).

  regards,
  Narayan

 
n_moorthy_techAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KaraaCommented:
simple approach of setting the content type to application/x-msexcel and then sending html tables which get converted to excel.
or you can use POI as mentioned here
http://jakarta.apache.org/poi/
POI will allow you to read and write Excel spreadsheets with pure java code.  You can do all kinds of formatting.
0
kennethxuCommented:
The answer to you question is NO with just java/jsp technology.
You'd better look into M$ solution like ActiveX.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
applekannaCommented:
these links mught help .. they contain a few code snippets

http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=000766
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JSP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.