To create a new table, follow the steps below:

1. Open MS Excel.
2. Click Open Report on the Aspose.Cells.Report.Designer toolbar to open a RDL Report file that contains the data sources, datasets and Report Parameters created in advance. Once the file has been opened successfully all its information is available for use, for example, its datasets are listed in the DataSet combo box.

3. Open MS Excel Sheet and design the table header as following.

4. Select a dataset “EmpSalesDetail” from dataset combo box control.

5. All the fields of dataset “EmpSalesDetail” are listed in the fields combo box. Select the cell under the OrderNumber column Cell and then select “SalesOrderNumber” field from the fields combo box to insert a data marker into the cell.

6. Repeat the step 5 to insert ProdCat and SubCat fields.