Excel sheet in portal

[Former Member]

Hi All!

Is there a way to show in portal only a part of an excel sheet.

For instance, I've got a file, residing in KM, examp.xls.

And I want to have an iView, that shows only rows 1,2,3 and columns CDE from sheet named 'example'.

Is it possible, or am I asking for a miracle? 🐵

Regards,

DK

[detlev_beutner · Accepted solution]

Hi Dennis,

this could be done by some development. You could read the XLS by http://jakarta.apache.org/poi/hssf and then give back the values in the form of a new sheet through hssf or more simple through a HTML table (which can be read by Excel), setting the content type correspondingly so that the browser opens Excel.

Hope it helps

Detlev

[Former Member · Accepted solution]

Hi Detlev!

Thanks for quick reply!

So there's no 'direct' way? I mean without programming... With some kind of 'appintegrator' or something 🐵

Other thing. My idea was not to open excel itself, but to open this sheet (or whole file) in an iview in iFrame.

[detlev_beutner · Accepted solution]

Hi Dennis,

no, "of course" not...

Of course you can open the sheet (or some part of it) as a Excel plugin (indeed, this calls Excel, but you only see the plugin part). This only depends on what you set on the http header additionally (setting the response as attachement opens Excel completely, so if you don't want it, just don't do it).

Hope it helps

Detlev

[Former Member · Accepted solution]

This excel plugin is a part of POI-HSSF? or standard portal functionality?

Can You please provide some more details?

[detlev_beutner · Accepted solution]

Hi Dennis,

it's just part of Excel/IE interoperability. No magic at all

Hope it helps

Detlev

[Former Member · Accepted solution]

Hi!

Yeah! Understood.

But in asks if file should be saved or opened... I suppose it's some architectural problem... Tried with both URL iView and KM document iview.

[detlev_beutner · Accepted solution]

Hi Dennis,

re-thinking about it, I'm unsure if Excel is pluggable / has an IE plugin. A colleague of mine thinks he has already watched this, but I cannot remember that. So maybe it's really not possible to open XLS <i>inside</i> IE. Anyhow, if you would programatically access some XLS and extract values from it, you could present them in your own table, for example.

Hope it helps

Detlev

[Former Member · Accepted solution]

Hi Detlev!

I rewarded you with 10, because seems that my problem is solved (as fully as it could be).

I just created two iViews (URL and KM document), and point them to an excel file. While opening, they ask whether to save or open file, but if I set mark to 'always perform that action' (or something simmilar), file opens in an iView.

Whole file is opened, but I understood that it's impossible to open part of it without programming.

Thank You very much!

Regards,

DK