Skip to main content

XlExport.CreateExporter(XlDocumentFormat, IXlFormulaParser) Method

Creates an exporter that performs data export to the specified Excel format using the specified formula parser.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public static IXlExporter CreateExporter(
    XlDocumentFormat documentFormat,
    IXlFormulaParser formulaParser
)

Parameters

Name Type Description
documentFormat XlDocumentFormat

One of the XlDocumentFormat enumeration members that specifies the type of the output document.

formulaParser DevExpress.Export.Xl.IXlFormulaParser

An object exposing the IXlFormulaParser interface that provides the capability to parse worksheet formulas. Required to validate worksheet formulas before export.

Returns

Type Description
IXlExporter

An object exposing the IXlExporter interface.

Remarks

Use the CreateExporter method with the new instance of the XlFormulaParser passed as the parameter to parse and validate strings used as formulas in the IXlCell.SetFormula and IXlCell.SetSharedFormula methods.

If the formula parser is not specified,

  • export to .XLSX format is performed without validation (i.e., a formula can contain unsupported defined names or syntax errors).
  • export to .XLS format fails and throws the System.InvalidOperationException exception with a message detailing the missing parser.

Note

The XlFormulaParser class used as a formula parser requires a reference to the DevExpress.Spreadsheet.v24.1.Core.dll assembly.

Example

In this code, the exporter instance is created with the XlExport.CreateExporter method which also creates the formula parser. A worksheet contains a heading row and four rows populated with data. The last column in each data row contains a formula created by supplying a formula string to the IXlCell.SetFormula method.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Create an exporter instance.
IXlExporter exporter = XlExport.CreateExporter(documentFormat, new XlFormulaParser());
// Create a new document.
using (IXlDocument document = exporter.CreateDocument(stream)) {
    document.Options.Culture = CultureInfo.CurrentCulture;
    // Create a worksheet.
    using (IXlSheet sheet = document.CreateSheet()) {
        // Create worksheet columns and set their widths.
        for (int i = 0; i < 4; i++) {
            using (IXlColumn column = sheet.CreateColumn()) {
                column.WidthInPixels = 80;
            }
        }
        // Generate data for the document.
        string[] header = new string[] { "Description", "QTY", "Price", "Amount" };
        string[] product = new string[] { "Camembert", "Gorgonzola", "Mascarpone", "Mozzarella" };
        int[] qty = new int[] { 12, 15, 25, 10 };
        double[] price = new double[] { 23.25, 15.50, 12.99, 8.95 };
        double discount = 0.2;
        // Create the header row.
        using (IXlRow row = sheet.CreateRow()) {
            for (int i = 0; i < 4; i++) {
                using (IXlCell cell = row.CreateCell()) {
                    cell.Value = header[i];
                }
            }
        }
        // Create data rows using string formulas.
        for (int i = 0; i < 4; i++) {
            using (IXlRow row = sheet.CreateRow()) {
                using (IXlCell cell = row.CreateCell()) {
                    cell.Value = product[i];
                }
                using (IXlCell cell = row.CreateCell()) {
                    cell.Value = qty[i];
                }
                using (IXlCell cell = row.CreateCell()) {
                    cell.Value = price[i];
                }
                using (IXlCell cell = row.CreateCell()) {
                    // Set the formula to calculate the amount 
                    // applying 20% quantity discount on orders more than 15 items. 
                    cell.SetFormula(String.Format("=IF(B{0}>15,C{0}*B{0}*(1-{1}),C{0}*B{0})", i + 2, discount));
                }
            }
        }

    }
}

The following code snippets (auto-collected from DevExpress Examples) contain references to the CreateExporter(XlDocumentFormat, IXlFormulaParser) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also