Focal Point
Excel Issue

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

March 07, 2008, 06:29 AM
Gobinath Velusamy
Excel Issue
HI

In Excel format output if the lines Exceeds(64000)

Then it may cause the issue in generating the report .. Is any option available to handle it in webfocus

Thanks
Gobinath Velusamy


WebFOCUS 7610
Windows
March 07, 2008, 09:03 AM
RickW
That's an Microsoft Excel limitation not a WebFOCUS issue. Unfortunately, WebFOCUS does not have a "magic" feature.

I think the latest version of Excel upped the limitation to 1M rows.


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
March 07, 2008, 09:36 AM
Kamesh
Check this discussion on our forum,

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/5831071272


WFConsultant

WF 8105M on Win7/Tomcat
March 07, 2008, 10:39 AM
Gobinath Velusamy
Hi

If i use EXL2K BYTOC , ihe issue will be solved ?


WebFOCUS 7610
Windows
March 07, 2008, 10:57 AM
Glenda
BYTOC will resolve the issue only if the field you sort by does not have more than 65000 records per sort category.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
March 07, 2008, 11:44 AM
Kamesh
Try to use the solution I suggested. In that way, if the row is more than 65000 it will go to the next worksheet.


WFConsultant

WF 8105M on Win7/Tomcat
March 07, 2008, 01:06 PM
RickW
I stand corrected - that's pretty cool.


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle