Excel 2007/2010
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**