Iview for an Excel spreasheet

[Former Member]

I have loaded an excel spreadsheet in a folder within KM. I have created an iview using 'com.sap.km.docs' as a template to display the spreadsheet. Then I added the iview into a page or a role for a user to view. The first time I tried to display it works fine. Any subsequent access to display it by myself or another person will not work. It seems that the MS Excel program can not read the file again. I get this errors on a windows pop-up screen: "'mso261.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is store on may not be responding."

The mso261.xls file is a temporary file because I did not create it and it is not the file name I gave when I uploaded the spreadsheet.

I tried to change the properties of the file to read-only and vice versa but nothing seems to be working.

Please, let me know if anyone has any solution/ideas on this.

[Former Member]

Ciao Manolis,

This can help:

- make sure iView isolation is set to "URL"

- check around cache settings as well as your browser settings.

- try using URL iView instead

- check MIME settings in portal configuration

- also, make sure MS Excel is working properly. I have seen different behaviours with different versions of Excel (97, 2000, XP, 2003)

- if you click the document within ConsumerExplorer does it open ?

- Try using a document explorer with preview (you need to add XSL as a supported MIME type for preview to work (default is text/* and images/*).

- You could develop a java iView that properly streams (including http headers) the XLS file within an isolated html iframe.

- You may also consider just letting users download the file instead of trying to show it embedded.

hope this helps

Regards

Vitaliano

[former_member374]

Hi Manolis,

This looks like you are not looking for an article, Weblog or document on how to create an iView for an Excel spreadsheet, but more like you are having a concrete problem that you hope someone can help you with.

This is why a better forum than the SDN Content Suggestion forum is the EP Development forum and I will move this post there.

Post a reply if I am wrong and I move it back.

Best, Mark.