For storing documents as the basic Microsoft Excel format, right up to the Excel 2007 version, used its own binary format of files (BIFF) and the file extension was «.xls». In Excel 2007/2010, the basic format is the Microsoft Office Open XML format and stores document in files with the «.xlsx» extension. The Excel 2007 is compatible with binary formats such as CSV, DBF, SYLK, DIF, and others.
Export Settings
The export parameters of the Excel 2007 export are described in the StiExcel2007ExportSettings class. The description of all class properties are in the table below.
Name
|
Type
|
Description
|
ImageQuality
|
float
|
image quality; may have values from 0.0 (the lowest quality) to1.0 (the highest quality); by default 0.75
|
ImageResolution
|
float
|
image resolution, dot per inch; may have any value, by default 100
|
UseOnePageHeaderAndFooter
|
bool
|
remove from a report all page headers (except the first one) and all page footers (except the last one); by default false
|
ExportDataOnly
|
bool
|
export data only, e.g. all components which are placed on data bands; by default false
|
ExportPageBreaks
|
bool
|
export page breaks; by default false
|
ExportObjectFormatting
|
bool
|
export object formatting; by default true
|
ExportEachPageToSheet
|
bool
|
export each page of a report as a sheet; by default false
|
The ExportObjectFormatting property works only if the ExportDataOnly is true.
|
Static Options
Static properties of export to Excel 2007.
Name
|
Type
|
Description
|
AllowImageComparer
|
bool
|
use the image comparer, e.g. replace image duplicates (see Common export settings); if false then an image is exported "as is"; by default true
|
ColumnsRightToLeft
|
bool
|
set the order of columns from right to left; by default false
|
MaximumSheetHeight
|
int
|
maximal number of rows on a sheet; odd rows are moved to the next sheet; by default 1048574
|
RemoveEmptySpaceAtBottom
|
bool
|
remove empty space on the bottom of a page; by default true
|
|