<< Click to Display Table of Contents >> Navigation: Daten und Datensatz > Output aufbereiteter Daten > OfficeExport > Syntax-Übersicht |
Der Export von Tabellen und Diagrammen in MS Office-Dateien wird mit den folgenden Statements gesteuert:
OfficeExport |
definiert Name und Dateiformat der Ausgabedatei |
---|---|
OfficeExportOptions |
beschreibt das Layout der Tabellenausgabe |
OfficeTitlePage |
produziert ein Deckblatt |
OfficeChapterPage |
erstellt ein Zwischenblatt |
OfficeContentPage |
erzeugt ein Inhaltsverzeichnis |
OfficeChart |
steuert die Charterzeugung auf Basis der Tabellendaten |
OfficeChartDefaults |
definiert Eigenschaften gleichartiger Diagramme |
Weitere Optionen |
|
Die Statements und ihre Optionen:
OFFICEEXPORT = <filename>;
OFFICEEXPORTOPTIONS [EDIT] =
| USEPOSTSCRIPTFONT <boxtype> : [YES|NO]
| USEPOSTSCRIPTCOLORS <boxtype> : [YES|NO]
| USEPOSTSCRIPTALIGN <boxtype> : [YES|NO]
| TRANSLATE <postcriptfontname> : <excelfontname>
[OPTION [BOLD|ITALIC|UNDERLINE]]
| BOXFONT <boxtype> : <FONTNAME> SIZE <NUMBER>
[OPTION [BOLD|ITALIC|UNDERLINE]]
| BACKGROUND <boxtype> : <color>
| FOREGROUND <boxtype> : <color>
| FIRSTCOLUMN : <number>
| ELEMENTFONT <cellelement> : <fontname> SIZE <number>
[STYLE [BOLD|ITALIC|UNDERLINE]]
| ELEMENTCOLOR <cellelement> : <color>
| VERTICALALIGN <boxtype> : [TOP|VCENTER|BOTTOM]
| HORIZONTALALIGN <boxtype> : [LEFT|HCENTER|RIGHT]
| DRAWBOX [<boxtype>] : [WEIGHT [THIN|MEDIUM|BOLD]]
[COLOR <color>] [BORDERS [TOP|LEFT|BOTTOM|RIGHT]]
| CONNECTEXCELCELLS <boxtype> : [YES|NO]
| XLABELSIGNCHARBOX LABELS X : [YES|NO]
| WRAPTEXT <boxtype> : [YES|NO]
| FLOWTEXT <boxtype> : [YES|NO]
| SUPPRESSGRIDLINES : [YES|NO]
| FIXLABELCOLUMN : [YES|NO]
| FIXLABELROWS : <number>
| TEXTROWHEIGHT <box> : <pixels>
| LABELWIDTH : <number>
| COLUMNWIDTH : <number>
| OFFICEFORMAT <cellelement> : <formatstring>
| THOUSANDS <cellelement> : [YES|NO]
;
OFFICETITLEPAGE “<sheetname>“ =
| TEXTBOX
: POSITION <cellrange>
: VERTICALALIGN [TOP|VCENTER|BOTTOM]
: HORIZONTALALIGN [LEFT|HCENTER|RIGHT]
: BACKGROUND <color>
: FOREGROUND <color>
: DRAWBOX WEIGHT [THIN|MEDIUM|BOLD] [COLOR <color>]
[BORDERS [TOP|LEFT|BOTTOM|RIGHT]]
: OFFICEFONT <fontname> SIZE <number>
[OPTION [BOLD|ITALIC|UNDERLINE]]
: TEXT “text“
| OFFICEPICTURE
: POSITION “<cellrange>“
: FILEPATH “<filepath>“
: SIZE X <points>
: SIZE Y <points>
;
OFFICECHAPTERPAGE: analog zu OFFICETITLEPAGE
[OFFICEEXPORTOPTIONS EDIT] OFFICECONTENTPAGE =
| NAME : <sheettext>
| TITLE
: POSITION <cellrange>
TEXT <title>
FONT <officefont>
SIZE <size>
FOREGROUND <color> [OPTION [BOLD|ITALIC|UNDERLINE]]
| TEXTBOX
: BOXTEXT "<text>"
: POSITION "<cell1>:<cell2>"
FONT "<Fontname>"
SIZE <number>
DRAWBOX WEIGHT [ THIN | MEDIUM | THICK ]
BORDERS [ TOP | BOTTOM | LEFT| RIGHT | ALL ]
COLOR $<number> FOREGROUND $<number> BACKGROUND $<number>
| CONTENT
: POSITION <cellrange>
FONT <officefont>
SIZE <size>
FOREGROUND <color> [OPTION [BOLD|ITALIC|UNDERLINE]]
;
OFFICECHART =
| CHARTTITLE : <title>
| INVERSE : [YES | NO]
| POSITION <excelcell>
| LEGENDPOSITION : [TOP | BOTTOM | LEFT | RIGHT]
| FORM : [BARS | COLUMNS | LINES | PIE]
| OPTION : [CLUSTERED | STACKED | PERCENTSTACKED]
| BACKGROUND : <color>
| FRAMECOLOR : <color>
| SIZE : <width> <height>
| USE3D : [YES | NO]
| LABELS : [0 | 1 | 2]
| ROWS : [TOTALROW | <startrow>[: <endrow>]]
| COLUMNS : [TOTALCOLUMN | <startcol>[: <endcol>]]
;
OFFICECHARTDEFAULTS [ EDIT ] =
| AUTO : [YES | NO]
| CHARTTITLE : <title>
| INVERSE : [YES | NO]
| LEGENDPOSITION : [TOP | BOTTOM | LEFT | RIGHT]
| FORM : [BARS | COLUMNS | LINES | PIE]
| OPTION : [CLUSTERED | STACKED | PERCENTSTACKED]
| BACKGROUND : <color>
| FRAMECOLOR : <color>
| SIZE : <width> <height>
| USE3D : [YES | NO]
| LABELS : [0 | 1 | 2]
| ROWS : [TOTALROW | <startrow>[: <endrow>]]
| COLUMNS : [TOTALCOLUMN | <startcol>[: <endcol>]]
;
Weitere Optionen:
SHEETNUMBERCHAR = <char>;