Focal Point
[CLOSED] Excel Gridlines - Turn Off

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

December 14, 2010, 01:58 PM
jhasty
[CLOSED] Excel Gridlines - Turn Off
When running a report in excel format, is there a way to turn off the grid lines in excel? Preferably without creating an excel template.

The report I am running would look much cleaner if they weren't there.

Thanks in advance for any assistance anyone can offer.

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


WebFOCUS 8008
Windows, All Outputs
December 14, 2010, 02:58 PM
Dan Satchell
A possible workaround?

TABLE FILE CAR
 SUM DEALER_COST
 BY COUNTRY
 ON TABLE SET STYLE *
  TYPE=REPORT, GRID=OFF, $
 ENDSTYLE
 ON TABLE HOLD FORMAT HTMTABLE
END
-*
SET HTMLFORMTYPE=XLS
-RUN
-*
-HTMLFORM BEGIN
!IBI.FIL.HOLD ;
-HTMLFORM END



WebFOCUS 7.7.05
December 15, 2010, 08:04 AM
jhasty
Thanks Dan - this looks like it might work. One thing I neglected to mention though is that the report I am running is a compound report where I am outputting to 3 separate tabs. Would like to turn the grid lines off on all three tabs if possible.

Any thoughts on how to implement what you suggested above with the use of compound reports?


WebFOCUS 8008
Windows, All Outputs
December 15, 2010, 10:13 AM
Francis Mariani
According to the WebFOCUS New Features v7.6.9 document, you can play with borders in EXL2K formatted reports:

quote:
Excel (EXL2K Format) Style Enhancements
The StyleSheet options ORIENTATION=LANDSCAPE and BORDER=ON are now supported for EXL2K report output.
The BORDER attribute supports the same options as currently available for FORMAT PDF except for border options available in Adobe PDF but not available in Microsoft Excel


Unfortunately I can't test this, we have v7.6.8.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 15, 2010, 02:56 PM
Hua
If you don't mind applying a background color, will automatically give you gridless report.
 TABLE FILE CAR
 SUM DEALER_COST
 BY COUNTRY
 ON TABLE SET STYLE *
  TYPE=REPORT, BACKCOLOR=YELLOW, $
 ENDSTYLE
 ON TABLE PCHOLD FORMAT EXL2K
END
 



Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
December 16, 2010, 10:00 AM
BobV
I use background color = white

ON TABLE SET STYLE *
TYPE=REPORT, BACKCOLOR=WHITE, $
ENDSTYLE

I often use it at the column level rather than the whole report. That way I still have grids in headers, footers, titles etc


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8