Below is a description of all options supported by the XLS Export module. These options can be set by the application program with the NTPSetOption function.
NTPOPTION_XLSEXP_RESOLUTION
Defines the resolution in dpi for graphic generation.
Default: 300dpi.
NTPOPTION_XLSEXP_BITSPERPIXEL
Specifies the color depth of the generated graphics. 256 colors are usually sufficient for XLS export, and it should be remembered that with a higher color depth the graphic files can very soon become very large.
1 = black-and-white
4 = 16 colors
8 = 256 colors
24 = 24bit True Color
Default: 8
NTPOPTION_XLSEXP_RECTANGLE
Configures the way in which rectangle objects should be exported.
0 = Ignore object
1 = Object as rectangle
2 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_BARCODE
Configures the way in which bar code objects should be exported.
0 = Ignore object
1 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_DRAWING
Configures the way in which graphic objects should be exported.
0 = Ignore object
1 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_ELLIPSE
Configures the way in which ellipse objects should be exported.
0 = Ignore object
1 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_LINE
Configures the way in which line objects should be exported.
0 = Ignore object
1 = Object as line
2 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_TEXT
Configures the way in which text objects should be exported.
0 = Ignore object
1 = Object as text object
2 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_RTF
Configures the way in which RTF objects should be exported.
0 = Ignore object
1 = Object as normal text without formatting
2 = Object as graphic
Default: 1
NTPOPTION_XLSEXP_TABLE
Configures the way in which table objects should be exported.
0 = Ignore object
1 = as a complete table object
Default: 1
NTPOPTION_XLSEXP_EXTENDOBJECTS
Configures the way in which LLX objects (OLE, HTML, chart) should be exported.
0 = Ignore object
1 = as graphic
Default: 1
NTPOPTION_XLSEXP_XLSFONTSCALING
Scaling factor by which font sizes are corrected. This is necessary because the texts in Excel come out rather higher than in normal output.
Default: 89 (=89% font size)
NTPOPTION_XLSEXP_XLSPRINTINGZOOM
Scaling factor by which the overall project is corrected. This is necessary because in Excel the printer's nonprinting margin is always kept free.
Default: 95 (=95% zoom)
NTPOPTION_XLSEXP_XLSTITLE
Specifies the title of the XLS document to be generated.
Default: "NotesToPaper XLS Report"
NTPOPTION_XLSEXP_ONLYONETABLE
Enables only the data from table cells to be exported.
0 = All objects are exported
1 = Only table cells are exported with their data
Default: 0
NTPOPTION_XLSEXP_XLSIGNOREGROUPLINES
Allows group headers and footers to be ignored, if these should not appear in the resulting Excel file. Only effective if NTPOPTION_XLSEXP_ONLYONETABLE is set.
0 = Group lines are exported
1 = Group lines are ignored
Default: 1
NTPOPTION_XLSEXP_XLSIGNOREHEADERFOOTER
Allows headers and footers to be ignored, if these should not appear in the resulting text file. Only effective if NTPOPTION_XLSEXP_ONLYONETABLE is set.
0 = Headers and footers are exported
1 = Headers and footers are ignored
Default: 1
NTPOPTION_XLSEXP_IGNORELINEWRAP
Allows line breaks to be ignored. Only effective if NTPOPTION_XLSEXP_ONLYONETABLE is set.
0 = Line breaks are transferred to Excel
1 = Line breaks are ignored
Default: 1
NTPOPTION_XLSEXP_CONVERTNUMERIC
This can be used to enable/disable automatic formatting of numeric values in the generated Excel file. Only effective if NTPOPTION_XLSEXP_ONLYONETABLE is set.
0 = No automatic formatting takes place
1 = Numeric values are formatted according to the setting in the Designer under Project > Options
Default: 1
NTPOPTION_XLSEXP_FILE
Gives the file name for the XLS document to be generated. If blank, the file selection dialog is displayed.
NTPOPTION_XLSEXP_PATH
Gives the path for the XLS document to be generated.
NTPOPTION_XLSEXP_QUIET
Says whether the export process should be executed with user interaction.
0 = Interactivity/dialogs allowed
1 = There is no file selection dialog (supposing Export.File is set) and no "Overwrite?" inquiry.
Default: 0
NTPOPTION_XLSEXP_SHOWRESULT
Specifies whether, following the export, the application linked to the file extension should automatically be started.
0 = No display of the result
1 = Executes a ShellExecute() on NTPOPTION_XLSEXP_FILE, so that usually Microsoft Excel® or similar should be started
Default: 0
NTPOPTION_XLSEXP_ALLPAGEONESHEET
Allows a separate worksheet to be created per page in the generated Excel file.
0 = A separate worksheet is created per page
1 = All pages are generated in the same worksheet
Default: 1
NTPOPTION_XLSEXP_SHEETNAME
Gives the name for the worksheet(s) in the generated Excel file. You can use the format identifier "%d" in the name: it will be replaced at runtime by the page number (e.g. "Report Page %d").