[SOLVED] Excel slow in converting xht to xls ( a bit of topic )

Hello all,

I'm wondering. I know this is not really a WF issue, but it is because of WF that I have this problem. And I can not be the only one. One of you might have a clue...

I have a fex with this output:
1 excel worksheet with 150 lines of data ( approx 25 columns )
1 excel worksheet with 10000 lines of data ( approx 25 columns )
Together in one file.

It is an xls, but internally it's .xht
The file is 8 MB.

When opening this document excel takes 100% CPU for about 5-10 min. on a decent PC. But we've also got end-users using a NC ( like Citrix ). On those tiny machines it takes ages...

When then saved as a real xls or xlsx it's only 2 MB. When reopening in excel again it takes just seconds.

I know "this is the way WF works", but to me it's a bit odd. Finally we've got a fast native tool and a good datawarehouse to deliver the data fast... ...and then you have to wait 15 min before your workstation can open the data.

Anybody else experiencing this? Any help, clues?

Greets,
Dave

This message has been edited. Last edited by: Kerry,

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Tony A

Expert

posted

Hide Post

Dave,

Are you using templates?

If so are you programmatically changing any page settings within the excel worksheets?

In case you are, excel opens the printer properties dialog internally for every single page setting that is made. If you have 50 odd setting changes then that can be an awful amount of time if you have one of these latest fancy "does everything but the washing up" printers with their humongous drivers.

If this is your situation then change your default printer to something innocuous like the XPS writer in Windows and see how much difference it makes.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Dave

Master

posted

Hide Post

Tony,

thanks for the reply, but I don not use a template.
Just styling. ( and even without styling it does not speed up ).

I guess it just the time it takes to convert all those

<TR><TD></TD>...</TR>

's to excel cells.

I'm just wondering if we are alone in this?

Greets,Dave

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Ignored post by Dave posted

Show Post

<JG>

posted

Your main problem is iSeries.

If you were windows then you could use Tony's method of using VB script to convert it to a binary.

Only other real option is to upgrade to 7701 then you can use FORMAT EXL07 (excel 2007 Binary)

Dave

Master

posted

Hide Post

JG, thanks for your input.

But it's not an iSeries issue.
When prompted I can choose to save the file directly. When I do this to my windows workstation C-drive. It works fine ( and fast ).

When I try to open that local file it also takes very long to open. ( and consume local CPU% ). iSeries is not involved in this proces.

I know there might be work-arounds, but I still feel this is not the way it should work. It's way to slow... ...and if I'm really the only one, I wonder what wrong with my workstation. ( and those of my co-workers ).

WF 7701 might be a solution if EXL07 is really binary.

Lucky me