SSpread.ExportExcelBookEx Method

Explanation Export to an Excel format file.

An extension of the ExportExcelBook method. How to handle formulas can be specified.

Use the ExportToExcelEx method to specify the sheet name.

Call format ExportExcelBookEx(Writer, flags)

Return value None

Arguments Writer Export destination Writer Object

flags

Set whether to export formulas
Specify the following values.

Constant	Value	Description
$SS_EXCELSAVEFLAGNONE	0	Save the formula
$SS_EXCELSAVEFLAG_NOFORMULA	1	Do not save formulas

Exception EXT-25 No valid Writer object specified

EXT-28 An error occurred in the ExportExcelBookEx method

Example of use

    var fs = new FileSystem();
    var f = fs.SaveDialog("Save", "Excel File(*.xls)=*.xls", "xls", "");
    ExportExcelBookEx(f, $SS_EXCELSAVEFLAG_NOFORMULAS);
    f.Close();

Related item ExportExcelBook, ExportToExcelEx, ImportExcelSheet methods