---
title: "Create XLSX Output - Lasernet Form Editor 9 Training"
slug: "create-xlsx-output"
description: "In this exercise, you are proposed to create an output in the XLSX format. The XLSX format is an output format used to create an output."
tags: ["Lasernet 9 ", "Lasernet Developer", "XLSX"]
updated: 2026-03-06T07:49:45Z
published: 2026-03-06T07:49:45Z
canonical: "kb.lasernetgroup.com/create-xlsx-output"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create XLSX Output

**Applies to:** Lasernet 9

## Introduction

The XLSX format is an output format used to create an output. The Form Engine retrieves data from the input file, processes it, and adds defined fields to the output along with static elements and text added by a user while modifying the output in the Editor.

As an input, the DataSet format is always used.

You can use a Microsoft Excel-type interface to deal with an output of the XLSX format.

In this exercise, you are proposed to create an output in the XLSX format.

> [!NOTE]
> Note
> 
> This article describes a software version that is no longer supported. Although the software will no longer receive updates or technical support, existing documentation, such as this article, will be retained for reference purposes but will no longer be updated. If you have any questions, contact [Lasernet Support](https://support.lasernetgroup.com/new-ticket).

## Exercise

Download and import the attached configuration called **08. Create XLSX Output** in Lasernet Developer 9. Afterward, navigate to the **Forms** section and open the **Sample** form.

To create an output of the XLSX format, follow these steps:

1. Open a grab file named **Sample**. To this end, first, on the **Form** menu, click **Select Grab File(s)**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090376590.png)

1. In the **Select Grab File(s)** dialog that opens, select the **Sample** file, and then click **Open**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090378359.png)

1. Open a template based on which you want to create the output. To this end, click **Open Template**, select the one from the list, and then click **Open**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090376981.png)

1. Start creating your output document by specifying a template range. To this end, select a cell range to outline a region to which all cells of the template belong, and then click the **Detail** button on the **Mail Merge Extended** toolbar.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090378850.png)

1. On the **Mail Merge Extended** toolbar, click the **Select Data Member** button.
2. With the **Select Data Member** dialog displayed, select a mail merge table as a data member for the worksheet data set.
3. Once you are done, click **OK**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090377683.png)

1. Add a nested level to the **Detail** range to display the detail-level data from the child table. To this end, select the required cell range in the output to outline a region of the **Detail** range, then click **Master-Detail**, and then click **Detail Level**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090379041.png)

As a result, the **DetailLevel0** range is created.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090379257.png)

1. To specify a nested data member for **DetailLevel0**, on the **Mail Merge Extended** toolbar, click **Master-Detail**, and then click **Data Member**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090377469.png)

1. It is now time to insert mail merge fields. To this end, select a cell in the template, and then double-click a field in the input which value you want to insert to the selected cell. Fill in the cells of the **Detail** range with field values of the master detail table.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090377849.png)

Repeat the same action for each cell to fill it in with the required field value.

Start with adding fields for the first column in the following order:

- contactname
- shipname
- shipaddress
- shipcity
- shipcountry

Afterwards, add fields for the second column in the following order:

- orderid
- freight
- orderdate
- requireddate
- shippeddate

As you can see, the formatting specified for the current template is automatically applied to the inserted fields.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090377223.png)

1. Fill in now cells of **DetailLevel0** with field values of the nested table. Do it as it shown on the picture below.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090378577.png)

1. To make sure that all the required elements are added to the template, preview it by clicking the **Preview** button on the toolbar.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628090378121.png)

## Attachments

- [08.-Create-XLSX-Output.lnconfigx](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/08.-Create-XLSX-Output.lnconfigx)