0

I am inserted an href Link to open Excel Sheet(already existing in Server directory) in a JSP page. It is working perfectly fine in local eclipse browser but unable to open the sheet in InternetExplorer (client side). The snippet is as below.

<a href="C:\Sheet\SparesUsed.xls#Sheet1!A1"> This link will open the Excel Sheet </a>

Now, it is working perfectly fine in InternetExplorer 7 (client side) also, because I have used the server path in workspace of eclipse to store the excel sheet folder , the path is as follows Server path for File :C:\workspace.metadata.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Log‌​inExample\Sheet\SparesUsed.xls.

But when i open and try to edit the excel sheet , it is giving me error "Sparesused.xls is read only". To save a copy ,click ok, then give workbook new name in saveas dialog box". But I cannot allow the user to change the location of the file using saveas button because this same sheet would be used and open again & again using href link of jsp. i am using Tomcat6.0 version of server

ACJ
  • 11
  • 9
  • 1
    Why are you posting comments on your own question? Please edit your question to place your second and third thoughts and insights into the question itself, instead of expecting people to read through a comment trail to understand your problem. – teylyn Feb 19 '14 at 07:57

2 Answers2

0

The snippet you posted is incomplete html code. If the anchor tag is closed properly, browsers will offer to download the file or open it with Excel. This very much depends on the browser and version used. "not working in IE" is a bit too broad, since there are several generations of Internet Explorer active out there that all behave differently in some situations.

IE does not "open" an Excel spreadsheet by default. If anything, it will push the file to load with Excel.

What do you expect to happen?

Browsers don't open Excel files. Some servers support Excel Web apps and you may be able to open the odd Excel file and it will display in the browser, and if you are lucky, you may even be able to change a text value or a number. But be aware that currently this is the exception.

As a general rule: a complex Excel file can not be opened and edited in just any browser of your choice.

Excel is a quite complex application and it cannot be expected that all of Excel's funcionality magically appears in your browser, just because you post a link to an Excel file.

If that is not what you expected to hear, please rephrase your question.

teylyn
  • 34,374
  • 4
  • 53
  • 73
  • I have edited the question now. Also to add here, I have already closed anchor tag properly but was missing in the question here. I am referring to IE 7. is new link Iam providing – ACJ Feb 19 '14 at 08:27
  • I am not trying to open the Excel Sheet in browser. It is using MS_ excel application to open the sheet but I am unable to edit that same sheet again stored in server path. Secondly It is not a complex sheet but a simple sheet with only three columns not other function in sheet. i am using Tomcat6.0 version – ACJ Feb 19 '14 at 08:45
  • It might be a good idea to tag this question with the software you are using. And StackOverflow may not be the best place to look for an answer to a Tomcat (whatever that is) question. Maybe use a Tomcat forum instead. – teylyn Feb 19 '14 at 08:58
0

Iam Using This Approach now.

  1. Iam using Server Path to save/store the Excel Sheet , which can be browsed anywhere from client side.

  2. <a href="Sheet/SparesUsed.xls#Sheet1!A1" target="_blank">DownLoad Excel Sheet </a>.

Thanks for Help.

ACJ
  • 11
  • 9