Re: Re: Re: Re: Pagebreaks in Excel-HTML transformer

Charles/Jon,

I was thinking that it might be possible to find an easier fix
for the problem I have than introducing such Excel binary file solution
(and POI technology which I am totally unfamiliar with)
Mind you, it is a problem with only 2 reports (all others are fine).
It would be pretty undesirable that they behave totally different
from the user's perspective.
But I will look more into it.

>If you can tell me what element will cause Excel to create a new worksheet,
I
>can show you how to insert it into your output.
I did not find the answer after some googling around, but is it possible that
simply replacing <page-break> with "</x:WorkSheet><x:WorkSheet>" can do that
?
And subsequent HTMLSerializer with mime type Excel will interpret it.
That would be a much much simplier solution.

What do you think ?

I will also experiment more with regard to why me and Charles
are seeing different results with page-break after that transformation.

Thank you,
Oleg.


On 2/9/06, Jon Gorman <jonathan.gorman@xxxxxxxxx> wrote:
> > I was suggesting that you use some other means (other than XSLT) to
> > produce a binary native Excel file that you output to disk and insert a
link
> > into the HTML output that would download the binary file when clicked.
>
> Oleg, as I mentioned before and Charles mentioned again here, if you
> want to produce Excel worksheets, the most reliable way is to create a
> binary file.  Did you look at the information I sent in my last email
> about how to use Cocoon pipelining to produce a binary excel file?  As
> far as I can tell it seems a typical thing to do with Cocoon.  I do
> believe I've also seen Cocoon pipelines that did things like take in a
> SVG source and produced a variety of images from it.
>
>
>
> Jon Gorman