The following piece of code generates the output with no borders/grids. How do we get the borders/grids in EXL2K format?
TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST
SALES
BY COUNTRY NOPRINT
BY CAR

ON COUNTRY SUBTOTAL AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.097222,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=ON,
$
ENDSTYLE
END

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

Unless someone knows something I don't, you can use BORDER attributes in a StyleSheet in an HTML, PDF, or PS reports only. Grids can be used in HTML only.

If someone knows of a work around, I'd been interested too.

Glenda

Thanks a lot for your help.
Now I am able to do it

Hi Code Digger,

Styles do not translate to Excel, you will need to employ templates.

Hope this helps.

Cheers,

Kerry

kerry ,
i was wondering whether we can use macros to generate Gridlines and every time the report is opened in EXL2K format ..macros run automatically and the gridlines are displayed...
Is it possible??even i am facing the same problem of Grid lines??

Please Advice

Arvind,

Yes you can but, as Kerry mentions, you would have to use Excel Templates so that you can program in your Miscrosoft VBA code into the .mht file used for the template.

T

There have been at least three threads within the last week regarding this EXACT same question and probably that many as well regarding use of Excel templates. This information is also documented in the user manuals.

PLEASE people - do a cursory search of information that is already available before posting new questions. I understand that not everyone is aware that this is available (though it's not too hard to find), but you only have to use the forum a few times before the topics of using "Find" and searching documentation are brought up.

Maybe the forum moderator should create a ! document with some of these common helps and courtesies for using the forum. Or have them sent to new users as they sign up to use the forum.

This isn't an attack on CodeDigger, but it occurs frequently and something of this nature may address the issue.

Darin,

Reign it in mate. Arvind was asking a question of Kerry's post above. You have to read the context and flow of the posts to realise that his question is/was fairly valid.

Rule: Get a good understanding of the flow before placing foot into mouth

I think Darin's got a point that having a FAQ section might be a good idea. (My favourite candidate is functions in DM not preserving alpha type - this has cropped up loads - remember wasting 1/2 day on it myself back in 1988! ).

Kerry

Would it be possible to have a FAQ section which I think would have to be under the control of the moderator, but uses the input of posters?

John

IMHO so far the list reads

1. Excel templates for styling spreadsheets.
2. Using functions with Alpha Arguments in DM.

Any more suggestions?

Hi John and all,

A FAQ section sounds interesting. Let me bring this suggestion in and see what/how/where we can start from.

Keep the suggestions/comments coming please.

Cheers,

Kerry

This code sample may be what you are looking for.

-* File BordersInExcel.fex
TABLE FILE CAR
PRINT SALES SEATS
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE HOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=COUNTRY,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-HTMLFORM HOLD

I've never seen the HTMLFORMTYPE setting before. Learned something new. Anyway, this is interesting since we've been telling everyone that borders could not be carried into Excel. In fact, they aren't but you've found a way around it by specifying HTML format which then opens as a spreadsheet.

I had to add a -MRNOEDIT to the beginning of the -HTMLFORM line to get it to work properly in MRE.

I wouldn't be TOO surprised if there are still some things that don't translate but this is the quick answer to the "borders and grids in excel" question.

hey thanks for the MRNOEDIT tip..but still the report is not exported to Excel format.. and whenever i copy and paste it in another Excel2000 file,,the grid lines are not visible in the print preview ...i guess the only way is to create Excel templates ..any suggestions???

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

quote:

and whenever i copy and paste it in another Excel2000 file,,the grid lines are not visible in the print preview

Arvind,

This is, as has been mentioned before, an Excel / MS Clipboard problem in as much as you will have to set Excel to print grid lines.

T

thank you sir

Forgot about the grid lines part. I do get borders with the technique, but still no grid lines. Back to the templates solution...

Second thought, you might try adding

TYPE=REPORT, BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,$

to the stylesheet. This adds borders around the fields and sort groups. It may get you closer to what you're looking for. This LOOKS like grids are on, but is really just adding borders around EVERYTHING.

Darin,

The important piece about Arvind's problem is that he is cutting and pasting content from the output into an MS Excel worksheet (why? I wouldn't want to guess ) and then using print preview.

T

quote:

Originally posted by dab448:
This code sample may be what you are looking for.

-* File BordersInExcel.fex
TABLE FILE CAR
PRINT SALES SEATS
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE HOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=COUNTRY,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-HTMLFORM HOLD

Based on this method to get borders on Excel, is it possible to use for Set Compound reports??
SET COMPOUND='OPEN NOBREAK'
Report 1:


Report 2:
SET COMPOUND=CLOSE