Focal Point
[Solved]Error saving big EXCEL output as .xlsx in WF 8.1.0.5 Window

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6207027886

December 21, 2017, 01:17 AM
Chaudhary
[Solved]Error saving big EXCEL output as .xlsx in WF 8.1.0.5 Window
Hi,

I need to save the WF output as .xlsx .
If I run with ON TABLE PCHOLD FORMAT EXL2K ,it came out OK.
If I run with ON TABLE PCHOLD FORMAT XLSX, it come out with 0 bytes.

Then



Please advise

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


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
December 21, 2017, 04:35 AM
Sakir
The last one

SET EXCELSERVURL = ''

works on my environment.

Have you seen edaprint.log for the class.path? Is it right?

Otherwise, put this SET at the top of your .fex
December 21, 2017, 05:37 AM
Chaudhary
Thanks Sakir,

I will check Java service , Is that active or not .


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
December 21, 2017, 07:42 AM
MartinY
You can also try by changing the "Excel Server URL" Default option to : Reporting Server JSCOM.

This setting can be found under : Administration Console / Client Settings. Then "Save" and "Clear Cache" (top right menu)


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
December 21, 2017, 02:33 PM
Chaudhary
Thanks Martin,

Java servises was not running. We corrected tha java path.

Now output came out in xlsx.


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10