We recently migrated to WF8 and are experiencing issues with XLSX reports. Using a simple request like so:

 
TABLE FILE CAR
PRINT 
     CAR
ON TABLE PCHOLD FORMAT XLSX
END
 

We get an error saying Excel cannot open the file ... because the file format or file extension is not valid ...

I have tried changing all the redirection settings for .xlsx to no avail. Currently it is to to redirect NO save YES. Has anyone else experienced this difficulty? EXL2K works fine.

-J

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

Try throwing this into your program

SET EXCELSERVURL = ''
  

Thanks MattC, that was just what I needed.

-J

quote:

SET EXCELSERVURL = ''

doesn't seem to work from the edasprof.
Does anyone know a way to make this setting global so i don't have to edit every single fex?

Hi
You can set it from the webfocus client console general settings

Yours

Eran

Admin Console > Configuration > Client Settings > General > IBIF_excelservurl.

In v7.7.05 we set it to "&URL_PROTOCOL://&SERVER_NAME&IBIF_webapp", the initial value.

In v8.0.08 we set it to blank.

Yep, i did that, Frankie.
that's what i needed to know... where in the wfac to look and what to look for.
thanks.

works with IE9
doesn't work with IE8
its Oracle Access Manager that is breaking it.
on our servers that haven't had OAM put on yet, it works fine in IE8 too.

"IE8"? And I thought we were living in the past with IE9.

i'm still writing in 768
yes i'm sooooo old