New CSV2XL.SBX function allows you to set various print features:
//XL,SetPrint,attribute=value,attribute=value,...
where the possible attributes and values are:
|
Attribute |
Value |
Description/Comment |
|
orientation |
landscape, portrait |
Set initial orientation when printing |
|
header |
<text> |
Set print header text. May contain macros. |
|
footer |
<text> |
Set print footer text. May contain macros. |
|
hmargin |
<number of inches> |
Set margin for header, footer, left, top, right, bottom |
|
fmargin | ||
|
lmargin | ||
|
tmargin | ||
|
rmargin | ||
|
bmargin | ||
|
repeatrows |
<number> |
Set number of rows to repeat at top of each page |
|
repeatcols |
<number> |
Set number of columns to repeat at left edge of each page |
Note that all of the above attributes affect the current page, and thus should be specified after the page is initiated. For example, they might come after the first row data on the page.
Macros
The following macros may be used with the header and footer attributes.
|
Macro |
Action |
|
Macro |
Action |
|
&L |
Start of left-justified section |
|
&E |
Set double-underline text attribute |
|
&P |
Current page # |
|
&R |
Start of the right-justified section |
|
&N |
Total # of pages |
|
&Z |
Workbook file path |
|
&## |
Specify font size (## points), e.g. &14 |
|
&F |
Workbook file name |
|
&S |
Set strikethrough text attribute |
|
&A |
Current sheet name |
|
&Y |
Set subscript text style |
|
&"font" |
Font, e.g. &"Times New Roman" |
|
&C |
Start of the center-justified section |
|
&B |
Set bold text attribute |
|
&D |
Current date |
|
&I |
Set italic text attribute |
|
&T |
Current time |
|
&& |
Literal ampersand |
|
&U |
Set underline text attribute |
|
|
|