---
title: "How Do I Create Microsoft Excel Output Using a Lasernet Dataset?"
slug: "create-microsoft-excel-output-using-a-lasernet-dataset"
description: "This article will demonstrate how to import a Dataset produced from XML in Lasernet, and export this as Excel output. First create a Dataset file."
updated: 2024-06-17T14:12:05Z
published: 2024-06-17T14:12:05Z
canonical: "kb.lasernetgroup.com/create-microsoft-excel-output-using-a-lasernet-dataset"
---

> ## 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.

# How Do I Create Microsoft Excel Output Using a Lasernet Dataset?

This article will demonstrate how to import a Dataset produced from XML in Lasernet, and export this as Excel output. You will need to first create a Dataset file, read [this article](https://kb.lasernet.online/v1/docs/how-do-i-create-a-dataset-in-lasernet).

Ensure that the **Dataset XML** grab has a **Parent Table**, which should appear in your **Dataset** such as follows:

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

> [!NOTE]
> Note
> 
> The presence of **Parent Table** will affect the eventual output in Excel. This is because there are two reference points for the Excel Form. The following image shows the output of **Fields** in Excel when the **Data Member** and **Detail** point at the same table level (**No Parent Table**). As you can see the data rows will split into different workbooks:
> 
> ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1661249107163(1).png)
> 
> The following image presents the Excel output from the same **Fields** that have been nested inside a **Parent Table**:
> 
> ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1661249178034.png)

For this scenario, we will use the following layout as our data, with **SaleOrder** as our **Parent**:

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

1. Under the **Form** option, create a Form and then select **XLSX** as the **Output Format**. The **Input Format** will then automatically select the option **Dataset**.

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

1. Once the Form is created, ensure that the **Toolbar** can be seen from the top. If the **Toolbar** buttons cannot be viewed, right-click and select which of them should be displayed on the interface.

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

1. Open your **Dataset** grab (**Form** > **Select Grab File(s)** option) and select your dataset data. Then select a large area to be the **Detail** area in the spreadsheet. Then click the **Detail** button on the Toolbar at the top, and the specified area will become the **Detail Range**.

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

Lasernet should now appear as follows:

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

1. It is now necessary to select the **Data Member** for the **Detail Range**. The **Parent Table SalesOrder** will be used here as the **Data Member** for the **Detail Range**.

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

1. A **Header** or **Footer** can be added to the **Detail Range**. To do this, select the area above the **Detail Range** and click the **Header** button.

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

The **Header** should now look like this:

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

The same steps can be applied to the **Footer**, by specifying the area under the **Detail Range**.

1. We will now return to our **Main Detail**. Select an area to be used for the **Table** within **Detail**. In this example, the **Items Table** will be used. When the selected area has been specified, click the **Master Detail** and select **Detail Level**, creating **DetailLevel0**.

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

1. **DetailsLevel0** will now need to be associated with the **Items Table**. To do this, click **Master Detail** and select **Data Member** to specify the desired table.

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

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

> [!NOTE]
> Notes
> 
> When adding more **Details Levels** and associating them with the desired table, every time you open **Data Member**, it will always default to the first **Detail Level (DetailLevel0)**. You will need to make sure you are assigning the correct **Data Member** to the correct **Data Level**.

1. After the correct **Data Member** has been assigned to **DetailLevel0**, we will then select the fields for Items. Select cell **F7** and then double-click **Value**. It should look like this:

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

1. Now, the same process must be followed for the other columns. The columns in the spreadsheet can be adjusted as needed to correctly display the cell contents.

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

Previewing should show **Data** in an Excel output.

1. Titles can also now be added to the top of the fields.

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

1. The text can also be centered. To do this, select the rows for the titles and then click the **Center** button, as follows:

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

1. Borders can also be added to the titles by selecting the **Border** drop-down and choosing the desired border structure, as follows:

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

1. The background colors of the cells can be changed by selecting the desired cells to color and clicking **Fill**.

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

All of these options allow for extensive customization of the Excel output. To see how the output of the Excel document will appear, select **Preview** at the top left of the Toolbar. If the **Preview** shows multiple **Excel Workbooks**, then review the **Data Member** selection.

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